Hello,
There seems to be a strange behaviour when querying a compound index on a property that is a large number (actually a long ).
For example, if you create the following 3 documents :
{ "dateTicks": 636320336400000000, "userId": "55" }
{ "dateTicks": 636320337000000000, "userId": "55" }
{ "dateTicks": 636320337600000000, "userId": "55" }
And then create the index :
`> CREATE INDEX myIndex ON default(dateTicks,userId ) WHERE ((dateTicks is not missing) and (userId is not missing) )
Then if you query :
select count(*) from `default` where dateTicks >= 636320336400000000 and dateTicks <= 636320337600000000 and userId is not missing
You will get 2 results.
But if you query :
select count(*) from `default` where dateTicks >= 636320336400000000 and dateTicks <= 636320337600000000 and userId = "55"
You will get 3 results, wich is the correct result actually.
Can anybody please tell me, what did I do wrong ?
Thank you,
Bogdan