cwida / duckpgq-extension

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

Failing query when internal query includes path keyword #37

Closed Dtenwolde closed 1 year ago

Dtenwolde commented 1 year ago

The query following fails due to the edge table reference a non-existing vertex table. This is correct, however DuckDB then triggers an internal query: "SELECT database_oid AS seq, database_name AS name, path AS file FROM duckdb_databases() WHERE NOT internal ORDER BY 1". This includes the word path which has become a reserved keyword. Related to cwida/duckdb-pgq#86

-CREATE PROPERTY GRAPH pg3
VERTEX TABLES (
    School  LABEL School IN School_kind (Hogeschool, University)
    )
EDGE TABLES (
    Students    SOURCE KEY ( src ) REFERENCES School ( id )
            DESTINATION KEY ( dst ) REFERENCES Student ( id )
            PROPERTIES ( createDate ) LABEL Knows
    )