Different result when adding "WHERE a=a" · Issue #3221 · RedisGraph/RedisGraph · GitHub
Skip to content

Different result when adding "WHERE a=a" #3221

Open

Description

@ljhhuxiaoba

I execute two queries on my RedisGraph and get an error.

Redis version:7.2.0
RedisGraph version: v2.12.10
operating system: windows 11
API:Cypher version 9

To create graph:
input01.txt

Query pair:
Ⅰ: MATCH (dqowryyf:Person)<-[]-()-[]-(wscygnst:Movie)-[]-(milyqbqp:Person) RETURN DISTINCT count(milyqbqp)
Ⅱ: MATCH (dqowryyf:Person)<-[]-()-[]-(wscygnst:Movie)-[]-(milyqbqp:Person) WHERE wscygnst=wscygnst RETURN DISTINCT count(milyqbqp)

I think these two queries are equivalent, but the first returns 13 and second returns 15.

Activity

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