duckpgq-extension
duckpgq-extension copied to clipboard
cwida
DuckDB extension that adds support for SQL/PGQ
Query IS 6 from the LDBC SNB Interactive workload does not terminate due to the replyOf edge. This edge is supposed to find the original post of a comment, which...
There is currently a test commented out ``` Query unexpectedly failed (/Users/dljtw/git/duckpgq/test/sql/duckpgq.test:20) ================================================================================ SELECT duckpgq_openssl_version('Michael'); ================================================================================ Actual result: Binder Error: Registered state not found ``` Goal of this issue is...
This query will return a list of rowids alternating between the vertex rowid and the edge rowid between a source and destination We will only support (ANY) SHORTEST path for...
Unsure how this should be handled. When updating a table that has been registered within a property graph, the following query won't work anymore, since the primary (or foreign key)...
The following query results in a seg fault: ```sql -FROM GRAPH_TABLE (pg MATCH p = ANY SHORTEST 5 WALK (a:Person)-[k:knows]-> *(b:Person) WHERE a.name = 'Daniel' COLUMNS (p, a.name as name,...
If given the query (a)-[b where b.val > 100]->*(c) A way to handle the filter would be to create a csr only on the filtered edges. Have to check if...
Some large query plans get chopped off with the default text mode. I think it would be possible to add a new mode to profiling output, can call it graph....
This issue gathers some syntax ideas to alter an existing property graph. This is specified in the SQL/PGQ standard: `11.20 ` Please double-check that the proposed queries here adhere to...
```sql CREATE PROPERTY GRAPH MovieRentals VERTEX TABLES ( Customer, Movie ) EDGE TABLES ( CustSales SOURCE Customer DESTINATION Movie ); ``` Would reuse the already existing primary and foreign key...