I have 2 entity types, which I want to query, ParserJob and Tag. Unfortunately there seems to be a bug if I use the lower date select:
SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated < :date
This returns a SIZE(j.tags) of 0 Tags, but the only existing ParserJob has 1 Tag. If I run the query:
SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated >= :date
I get the correct result (1 Tag).
You find a test case at <deleted>. Please start the Tester.main(), both queries should return the same results. I use the latest ObjectDB 2.7.2_05 on Windows 10 but the bug also exists in older versions.
Thanks in advance