Bug: Index not used when AND is added to WHERE clause

[ioannist]

Describe the bug

Create a table and create an index:
DEFINE INDEX blockIndex ON TABLE table FIELDS block

This query (1) returns all results
SELECT * FROM table WHERE block = 10

This query (2) times out (looks like the index is not used):
SELECT * FROM table WHERE block = 10 AND observation.value.num IS NOT NONE

This query (3) executes successfully and returns the correct results:
SELECT * FROM (SELECT * FROM table WHERE block = 10) WHERE observation.value.num IS NOT NONE

Steps to reproduce

See above. You might have to enter many records to make the second query time out. Alternatively, you can check if the index is being used.

Expected behaviour

Query 2 should work and return the same results as query 3.

SurrealDB version

v1.1.1

Contact Details

No response

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct

[prabirshrestha]

This seems to be dupe of #2900

[ioannist]

Indeed, this is the same issue. Closing in favor of #2900