match where clause with multiple condition (InValid index)

[czpmango]

(czp@nebula) [nba]> match (n:player) where n.age>43   return n.age,n.name
+-------+-------------------+
| n.age | n.name            |
+-------+-------------------+
| 45    | "Jason Kidd"      |
+-------+-------------------+
| 46    | "Grant Hill"      |
+-------+-------------------+
| 47    | "Shaquile O'Neal" |
+-------+-------------------+
| 45    | "Steve Nash"      |
+-------+-------------------+
Got 4 rows (time spent 35201/35831 us)

Tue, 19 Jan 2021 17:20:07 CST

(czp@nebula) [nba]> match (n:player) where n.age>43 and n.name > "S"  return n.age,n.name
[ERROR (-8)]: IndexNotFound: No valid index found

[czpmango]

This is a TCK test case from OpenCypher.

[avently]

Actually I have the same problem with
LOOKUP ON profile WHERE profile.name == "something" AND profile.email == "something"

Is there a workaround?

[CPWstatic]

LOOKUP ON profile WHERE profile.name == "something" YIELD profile.email as email | YIELD $-.email WHERE $-.email == "something"

[avently]

@CPWstatic thanks!