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

Syntax error at or near ->* #146

Open
2 tasks done
Dtenwolde opened this issue Sep 5, 2024 · 1 comment · May be fixed by cwida/duckdb-pgq#205 or #169
Open
2 tasks done

Syntax error at or near ->* #146

Dtenwolde opened this issue Sep 5, 2024 · 1 comment · May be fixed by cwida/duckdb-pgq#205 or #169

Comments

@Dtenwolde
Copy link
Contributor

What happens?

A query with an * or + directly attached to the -> results in a syntax error.

To Reproduce

create table student(id INT); INSERT INTO student(id) VALUES (10), (20), (30), (40);
create table know(src INT, dst INT); INSERT INTO know(src, dst) VALUES (40, 20), (10,30), (10,10), (20,10), (30,10);
-CREATE PROPERTY GRAPH g
VERTEX TABLES (student)
EDGE TABLES (know    SOURCE KEY ( src ) REFERENCES Student ( id )
                         DESTINATION KEY ( dst ) REFERENCES Student ( id )
                         );

-FROM GRAPH_TABLE (g
    MATCH p = ANY SHORTEST (src:Student WHERE src.id = 10)-[k:knows]->*(dst:Student)
    COLUMNS (element_id(p) AS path));

OS:

macOs 13 - Apple M1 Pro

DuckDB Version:

v1.0.0

DuckDB Client:

CLI

Full Name:

Daniel ten Wolde

Affiliation:

CWI

How did you load the extension?

Community extension version

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

  • Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

  • Yes, I have
@Dtenwolde
Copy link
Contributor Author

Dtenwolde commented Sep 5, 2024

The workaround for now is to separate the -> and * with a space: -> * or -> +.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant