inconsistent results using * and sortby

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

  1. (integer) 101233
  2. p:789181
    1. _t
    2. 1561614302

FT.SEARCH ip1 “@tags:{f\:suzukicycles}” RETURN 1 _t LIMIT 0 1 SORTBY _t DESC

  1. (integer) 6
  2. p:792514
    1. _t
    2. 1561671353

I expected the first query to return p:792514 as the top result since its “_t” field is bigger than p:789181.

Michael

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