This issue has been created
 
 
LLM AI Integration / cid:jira-generated-image-avatar-f8101f94-df25-4c4b-86f1-4e2e358b13ab LLMAI-198 Open

query_objects filters and sort silently skip objects with no stored row for the field

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-1ed84f0f-056e-4b4f-a95e-61c3baef0058 Paul Pantiru created this issue on 30/Sep/26 17:42
 
Summary: query_objects filters and sort silently skip objects with no stored row for the field
Issue Type: cid:jira-generated-image-avatar-f8101f94-df25-4c4b-86f1-4e2e358b13ab Improvement
Affects Versions: 0.10
Assignee: Unassigned
Created: 30/Sep/26 17:42
Priority: cid:jira-generated-image-static-minor-1e2554c6-8054-4d73-be54-faad708f93be Minor
Reporter: Paul Pantiru
Description:

Filters and sort are compiled as an inner join on the property row, so an object that has no stored row for the field (created through write_object without that field, or the field was added to the class after the object was saved) never matches a filter on it, not even !=, and never appears in a sort on it. A stored empty value is included and sorts wherever the database orders nulls.