Hi, I am getting inconsistent results in the following two queries. The queries ask for different constraints, but with the exact same modifiers (SORTBY, LIMIT, RETURN).
FT.SEARCH ip1 “* ” RETURN 1 _t LIMIT 0 1 SORTBY _t DESC
(integer) 101233
“p:789181 ”
_t
“1561614302 ”
FT.SEARCH ip1 “@tags :{f\:suzukicycles} ” RETURN 1 _t LIMIT 0 1 SORTBY _t DESC
(integer) 6
“p:792514 ”
_t
“1561671353 ”
I expected the first query to return p:792514 as the top result since its “_t” field is bigger than p:789181.
Michael
meirsh
June 29, 2019, 5:11pm
2
Can you specify which version you are using?
I went to look at this again, and now I get the correct answer I expect. So I can’t reproduce this problem anymore.
Thank you for getting back to me, I 'll let you know if it happens again.
For the record, I don’t think it’s a timeout issue as both queries returned almost immediately and the index is only ~ O(100K) large.
Also, this is the same index that is causing problems in this ticket, so who knows what state it’s in:
https://github.com/RediSearch/RediSearch/issues/736
Michael