Bug that occur when comparing different types of values

[w158937299]

Agensgraph version: 2.13.0 Operating system: (Windows 11） API/Driver: (psycopg2 2.9.7) Steps to reproduce

As shown in this picture, query 1 returns the names of all nodes with the property "p2" greater than 50. Neo4j returns an empty set, while Agensgraph returns the names of some nodes. Query 2 returns the names and "p2" property values of all nodes. We can see that the type of the "p2" property value is a boolean constant, and it cannot be compared with an integer constant. However, Agensgraph still returns results. Therefore, we suspect that Agensgraph may have a bug in setting the priority of boolean constant higher than integer constants when comparing values of different types.

[w158937299]

HI @yjy44 , could you please check on this？