rewriteGraphTable: Fix missing RTEs in FROM clause by setting inFromCl=true

Edit
ID 6602
Title rewriteGraphTable: Fix missing RTEs in FROM clause by setting inFromCl=true
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +1−1, All patches: +1−1
Tags Bugfix
Created 2026-03-20 10:09:42
Last modified 2026-03-20 10:09:43 (2 hours ago)
Latest email 2026-03-20 10:14:52 (2 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version 19
Authors Man Zeng (zengman)
Reviewers Become reviewer
Committer
Links
Emails
SQL Property Graph Queries (SQL/PGQ)
First at 2024-02-16 14:53:11 by Peter Eisentraut <peter at eisentraut.org>
Latest at 2026-03-20 10:14:52 by zengman <zengman at halodbtech.com>
Latest attachment (0001-Correcting-the-value-of-rte-inFromCl-in-SQL-PGQ.patch) at 2026-03-19 13:17:07 from zengman <zengman at halodbtech.com>
    Attachment (0001-Correcting-the-value-of-rte-inFromCl-in-SQL-PGQ.patch) at 2026-03-19 13:17:07 from zengman <zengman at halodbtech.com> (Patch: Yes)
    Attachment (v20260318-0002-Cross-variable-references-in-graph-pattern.patch) at 2026-03-18 16:01:06 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-GRAPH_TABLE-collect-variables-across-full-clause.patch) at 2026-03-18 15:58:07 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v20260318-0001-Cleanup-users-and-roles-in-graph_table_rls.patch) at 2026-03-18 15:32:35 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-GRAPH_TABLE-collect-variables-across-full-clause.patch) at 2026-03-18 13:15:40 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (cleanup_rewrite_graphtable.patch.no_cibot) at 2026-03-16 16:28:47 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260316-0001-WIP-Dump-labels-in-reproducible-order.patch) at 2026-03-16 15:54:58 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (cleanup_rewriteGraphTable.no-cfbot) at 2026-03-16 15:08:41 from zengman <zengman at halodbtech.com> (Patch: Yes)
    Attachment (0001-WIP-Dump-labels-in-reproducible-order.patch) at 2026-03-16 12:43:29 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260311_SQL_PGQ.tar.gz) at 2026-03-11 07:34:43 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v20260306-0002-Simplify-property-not-found-error-message.patch) at 2026-03-06 09:32:32 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260227-0002-Simplify-property-not-found-error-message.patch) at 2026-02-27 17:06:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260226-0003-Move-GraphTableParseState-to-parsenodes.h.patch) at 2026-02-26 11:06:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Add-BEGIN_CATALOG_STRUCT-END_CATALOG_STRUCT.patch) at 2026-02-25 11:33:58 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260225-0002-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-25 08:28:21 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260225-0002-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-25 06:40:55 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Sort-out-RELKIND_PROPGRAPH-table_open-v2.patch) at 2026-02-19 09:31:22 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-18 15:28:02 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260113-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2026-01-13 16:14:22 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Various-small-updates.patch.nocfbot) at 2026-01-13 10:23:25 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260109-0003-SQL-PGQ-Support-multi-pattern-path-matching-in-GRAPH.txt) at 2026-01-09 06:53:29 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20260102-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2026-01-02 08:48:03 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (valgrind.tgz) at 2026-01-01 06:16:00 from Henson Choi <assam258 at gmail.com> (Patch: No)
    Attachment (coverage.tgz) at 2025-12-31 06:23:13 from Henson Choi <assam258 at gmail.com> (Patch: No)
    Attachment (v20251230-2-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-30 11:27:15 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v20251230-0002-Fix-some-more-references-and-edit-document.patch) at 2025-12-30 09:44:02 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20251226-0002-SQL-PGQ-Add-PROPERTY_NAMES-graph-element-function.patch) at 2025-12-26 12:33:41 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20251225-0001-Add-LABELS-graph-element-function.patch) at 2025-12-24 16:23:11 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20251218-0002-create_property_graph-test-changes.patch) at 2025-12-18 09:15:29 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Add-test-for-properties-typmod-mismatch.patch.nocfbot) at 2025-12-17 08:58:22 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20251217-0002-Edge-in-any-direction-bug.patch) at 2025-12-17 05:32:30 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20251215-0002-Edge-in-any-direction-bug.patch) at 2025-12-15 13:13:08 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (test2.sql) at 2025-12-13 19:57:56 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
    Attachment (v20251209-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-09 10:21:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v-20251202-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-02 10:00:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Typos-and-minor-style-fixes.patch.nocfbot) at 2025-11-25 13:52:21 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (order_keyword_fix.diff.txt) at 2025-11-24 05:00:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (SQL_PGQ_20251120.zip) at 2025-11-20 15:13:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (sql_pgq_one_patch_20250807.zip) at 2025-08-07 10:47:37 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (SQL_PGQ_20250722.zip) at 2025-07-22 11:40:26 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (pg-sql-pgq-20250311-nodups.tar.gz) at 2025-07-06 16:10:47 from Hannu Krosing <hannuk at google.com> (Patch: No)
    Attachment (pg-sql-pgq-20250311.zip) at 2025-03-11 07:21:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v14-0011-handle-RTE_GRAPH_TABLE-in-AcquireRewriteLocks.patch) at 2025-03-11 06:06:41 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v12-0010-adapt-property-graph-to-more-intuitive-titles.patch) at 2025-02-26 14:34:38 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v11-0013-refactor-insert_property_record-and-reduce-call-.patch) at 2025-02-23 12:54:53 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v10-0011-do-not-use-default-COLLATE.patch) at 2025-02-10 15:00:05 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (0001-trivial-refactor-of-property-graph-object-address.txt) at 2025-02-06 14:52:32 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (pg_sql_pgq-20250128.zip) at 2025-01-28 10:26:45 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0002-trivial-refactor.patch) at 2025-01-24 15:46:30 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (sql_pgq_patch_set_20250124.zip) at 2025-01-24 13:36:11 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (sql-pgq-2025-01-01.zip) at 2025-01-01 09:01:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0002-support-WHERE-clause-in-graph-pattern-20250101.patch) at 2025-01-01 08:52:29 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Broken-out-tokeniziation-of-arrows.patch) at 2024-12-21 21:45:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v1-0001-fix-wrong-ref-keys.txt) at 2024-12-21 12:51:04 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (0004-Fixes-following-issues-20241205.patch) at 2024-12-05 11:42:11 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-support-WHERE-clause-in-graph-pattern-20241122.patch) at 2024-11-22 13:59:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0004-Fixes-following-issues-20241105.patch) at 2024-11-05 15:41:24 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Broken-out-tokeniziation-of-arrows.patch) at 2024-10-29 19:55:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (0004-Fix-spurious-column-not-found-error-20240828.patch) at 2024-08-28 10:18:46 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (testcase.sql) at 2024-08-13 10:38:07 from Ajay Pal <ajay.pal.k at gmail.com> (Patch: No)
    Attachment (testcase.sql) at 2024-08-13 09:52:43 from Ajay Pal <ajay.pal.k at gmail.com> (Patch: No)
    Attachment (0003-Fix-compilation-error-20240805.patch) at 2024-08-10 09:21:43 from Imran Zaheer <imran.zhir at gmail.com> (Patch: Yes)
    Attachment (0004-Fix-spurious-column-not-found-error-20240805.patch) at 2024-08-05 12:41:20 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0006-Support-for-EXCEPT-list-in-Labels-and-properties.patch) at 2024-08-04 07:02:07 from Imran Zaheer <imran.zhir at gmail.com> (Patch: Yes)
    Attachment (0002-pgperltidy-fixes-20240722.patch) at 2024-07-22 12:01:42 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0003-Fix-compilation-error-20240717.patch) at 2024-07-17 05:34:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Fix-compilation-error-20240708.patch) at 2024-07-08 13:37:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2024-06-27 12:31:00 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
    Attachment (0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ-20240305.patch) at 2024-03-05 12:08:30 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v0-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2024-02-16 14:53:11 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
History
When Who What
2026-03-20 10:09:43 Man Zeng (zengman) Attached mail thread a855795d-e697-4fa5-8698-d20122126567@eisentraut.org
2026-03-20 10:09:42 Man Zeng (zengman) Created patch record
Edit