duckpgq-extension icon indicating copy to clipboard operation
duckpgq-extension copied to clipboard

Parser error with any shortest in wrong place

Open Dtenwolde opened this issue 6 months ago • 0 comments

What happens?

A segmentation fault occurs in pgq.y with the following query:

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

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 ANY SHORTEST p = (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?

Built from source

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

Yes

Did you include all code required to reproduce the issue?

  • [X] Yes, I have

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

  • [X] Yes, I have

Dtenwolde avatar Sep 05 '24 08:09 Dtenwolde