Type check failed in match where clause

[czpmango]

(czp@nebula) [nba]>       MATCH p = (n:player)<-[e:like]-(m)       WHERE n.age >= 33.0000000000011         RETURN n.name AS player, n.age AS age
[ERROR (-12)]: SemanticError: Data type error of field : age

Mon, 01 Feb 2021 11:06:47 CST

(czp@nebula) [nba]>       MATCH p = (n:player)<-[e:like]-(m)       WHERE n.age >= 33         RETURN n.name AS player, n.age AS age
+---------------------+-----+
| player              | age |
+---------------------+-----+
| "Shaquile O'Neal"   | 47  |
+---------------------+-----+
| "Kobe Bryant"       | 40  |
+---------------------+-----+
| "Kobe Bryant"       | 40  |
+---------------------+-----+

[jievince]

The filter condition of IndexScan is too strict.

[Aiee]

vesoft-inc/nebula-graph#784 only fixed LOOKUP. This issue in MATCH retains.

[HarrisChu]

MATCH bug still in v2.0.1

[czpmango]

I test this query with the latest version and no errors were reported:

(czp@nebula) [nba]>    MATCH p = (n:player)<-[e:like]-(m)       WHERE n.age >= 33.0000000000011         RETURN n.name AS player, n.age AS age limit 3
+---------------------+-----+
| player              | age |
+---------------------+-----+
| "LaMarcus Aldridge" | 33  |
| "LaMarcus Aldridge" | 33  |
| "Chris Paul"        | 33  |
+---------------------+-----+

But, the result is still incorrect. Close it and reopen another issue(#3577).