cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
73 stars 7 forks source link

WITH clause segmentation fault #129

Closed Dtenwolde closed 3 months ago

Dtenwolde commented 3 months ago

The following query leads to a segmentation fault:

WITH foo as (SELECT * FROM GRAPH_TABLE(snb MATCH (a:Person))) select * from foo;

Full code:

install duckpgq from community;
load duckpgq;
import database '/Users/dljtw/git/duckpgq-experiments/data/SNB0.003-projected|';
CREATE PROPERTY GRAPH snb
    VERTEX TABLES (
      Person,
      Message,
      Forum
    )
    EDGE TABLES (
      Person_knows_person     SOURCE KEY (Person1Id) REFERENCES Person (id)
                              DESTINATION KEY (Person2Id) REFERENCES Person (id)
                              LABEL Knows,
      Forum_hasMember_Person  SOURCE KEY (ForumId) REFERENCES Forum (id)
                              DESTINATION KEY (PersonId) REFERENCES Person (id)
                              LABEL hasMember,
        Person_likes_Message    SOURCE KEY (PersonId) REFERENCES Person (id)
                              DESTINATION KEY (id) REFERENCES Message (id)
); 
WITH foo as (SELECT * FROM GRAPH_TABLE(snb MATCH (a:Person))) select * from foo;