Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Array functions not recognizing VPC #1044

Closed
MuhammadTahaNaveed opened this issue Jul 17, 2023 · 1 comment · Fixed by #1064
Closed

Array functions not recognizing VPC #1044

MuhammadTahaNaveed opened this issue Jul 17, 2023 · 1 comment · Fixed by #1064
Labels
bug Something isn't working

Comments

@MuhammadTahaNaveed
Copy link
Member

MuhammadTahaNaveed commented Jul 17, 2023

Describe the bug
I encountered an error when trying to get size of vle edge array in where clause which should have executed without error.

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 (m)-[v *]->(b) 
    WHERE size(v) >1
    RETURN b
$$) AS (a agtype);
ERROR:  size() unsupported argument

Expected behavior
Should have returned

 {"id": 281474976710658, "label": "", "properties": {"n": "hello"}}::vertex

Environment (please complete the following information):

  • latest (PG13 master)

Additional context
same error exists in all array functions i.e. they dont recognize VPC.

@MuhammadTahaNaveed MuhammadTahaNaveed added the bug Something isn't working label Jul 17, 2023
@titoausten
Copy link

titoausten commented Jul 17, 2023

The condition beside the WHERE clause is > 1, this will return an error as the size is not greater than 1.

size(v) = 1
1 > 1 is FALSE.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants