diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/test/regress/results/graph_table.out --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2024-12-08 00:04:10.505699981 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/graph_table.out 2024-12-08 00:09:24.944173681 +0000 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loop_name ASC; self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loop_name COLLATE "C" ASC; @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."default" AS loop_name)) ORDER BY loop_name ASC; self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 (2 rows) SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b WHERE b.elname > 'g2.E331']->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname AS loop_name)); @@ -636,22 +636,19 @@ (1 row) SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b WHERE b.elname > 'g2.e331' COLLATE pg_catalog."default"]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname AS loop_name)); - self | loop_name ---------+----------- - g2.v33 | g2.E331 -(1 row) + self | loop_name +------+----------- +(0 rows) SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) WHERE b.elname > 'g2.e331' COLLATE pg_catalog."default" COLUMNS (a.elname AS self, b.elname AS loop_name)); - self | loop_name ---------+----------- - g2.v33 | g2.E331 -(1 row) + self | loop_name +------+----------- +(0 rows) SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname AS loop_name)) WHERE loop_name > 'g2.e331' COLLATE pg_catalog."default"; - self | loop_name ---------+----------- - g2.v33 | g2.E331 -(1 row) + self | loop_name +------+----------- +(0 rows) CREATE VIEW customers_us AS SELECT customer_name FROM GRAPH_TABLE (myshop MATCH (c IS customers WHERE c.address = 'US')-[IS customer_orders]->(o IS orders) COLUMNS (c.name AS customer_name)); SELECT pg_get_viewdef('customers_us'::regclass);