Inconsistent results caused by adding “ORDER BY" · Issue #3205 · RedisGraph/RedisGraph · GitHub
Skip to content

Inconsistent results caused by adding “ORDER BY" #3205

Open

Description

@ljhhuxiaoba

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

  1. gkorland commented on Oct 3, 2023

    @gkorland
    Contributor

    ref #3205

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions