| From: | SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
| Subject: | [Patch]Add Graph* node support to expression_tree_mutator |
| Date: | 2026-04-21 15:56:44 |
| Message-ID: | CAHg+QDc97WFTSkXg=g_ZAH8GnY2gJrvq72cs+YjqEAuZgXnkAQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi hackers,
expression_tree_mutator_impl() was missing case handlers for
T_GraphPattern, T_GraphElementPattern, and T_GraphPropertyRef.
The corresponding expression_tree_walker_impl() already handled
all three node types, but the mutator did not, causing an
"unrecognized node type: 106" error whenever a GRAPH_TABLE
subquery appeared in a HAVING clause.
SELECT 1 FROM hv GROUP BY id
HAVING (SELECT COUNT(*) FROM GRAPH_TABLE(gh MATCH (a) COLUMNS (a.id AS x)))
> 0;
SET
ERROR: unrecognized node type: 106
Attached a patch to address this.
Thanks,
Satya
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Add-Graph-node-support-to-expression_tree_mutator.patch | application/octet-stream | 4.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2026-04-21 15:57:33 | Re: MERGE PARTITIONS and DEPENDS ON EXTENSION. |
| Previous Message | Andres Freund | 2026-04-21 15:52:37 | Re: First draft of PG 19 release notes |