Skip to content

Could not find rte error when using path variable in WHERE #1045

@MuhammadTahaNaveed

Description

@MuhammadTahaNaveed

Describe the bug
Could not find rte error when using path variable in WHERE

How are you accessing AGE (Command line, driver, etc.)?

  • terminal

What data setup do we need to do?

SELECT * FROM cypher('graph',$$
    CREATE (n)-[:KNOWS {n:'hello'}]->({n:'hello'})
$$) as (a agtype);

What is the command that caused the error?

SELECT * FROM cypher('graph', $$
    MATCH p = (m)-[]->(b) 
    WHERE length(p) >1
    RETURN p
$$) AS (pattern agtype);
ERROR:  could not find rte for p
LINE 3:     WHERE length(p) >1 return p
                         ^

Expected behavior
Expected it to work without error.

Environment (please complete the following information):

  • latest (PG13 master)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions