Horton

Re: SQL Property Graph Queries (SQL/PGQ)

Alexander Lakhin <exclusion@gmail.com>

View thread
From: Alexander Lakhin <exclusion@gmail.com>
To: Peter Eisentraut <peter@eisentraut.org>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, assam258@gmail.com
Cc: Amit Langote <amitlangote09@gmail.com>, Junwang Zhao <zhjwpku@gmail.com>, Vik Fearing <vik@postgresfriends.org>, Ajay Pal <ajay.pal.k@gmail.com>, Imran Zaheer <imran.zhir@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2026-05-16T12:00:00Z
Lists: pgsql-hackers 
Hello hackers,

Please look at an internal error produced with the following script added
to src/test/regress/sql/graph_table.sql:
CREATE TABLE x(a int);
SELECT * FROM x, GRAPH_TABLE (myshop MATCH (c IS customers) ->(l IS orders | wishlists) COLUMNS (c.name, x.a AS a));

ERROR:  XX000: plan should not reference subplan's variable
LOCATION:  finalize_plan, subselect.c:3159

Best regards,
Alexander