You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Inconsistent results caused by adding “ORDER BY" #3205
I execute two queries on my empty RedisGraph and get an error.
Redis version:7.2.0
RedisGraph version: v2.12.10
operating system: windows 11
API:Cypher version 9
Steps to reproduce:
Execute the following two queries separately GRAPH.QUERY graph "UNWIND NULL AS a0 OPTIONAL MATCH (:LL) RETURN percentileDisc(NULL,0) AS a1"
GRAPH.QUERY graph "UNWIND NULL AS a0 OPTIONAL MATCH (:LL) RETURN percentileDisc(NULL,0) AS a1 ORDER BY TRUE"
I think these two queries are equivalent, but the first query returns a single row of results, while the second returns an empty result.
I think the "ORDER BY TRUE" clause should not change the return result.
Activity
gkorland commentedon Oct 3, 2023
ref #3205