[Patch]Add Graph* node support to expression_tree_mutator - Mailing list pgsql-hackers

From SATYANARAYANA NARLAPURAM
Subject [Patch]Add Graph* node support to expression_tree_mutator
Date
Msg-id CAHg+QDc97WFTSkXg=g_ZAH8GnY2gJrvq72cs+YjqEAuZgXnkAQ@mail.gmail.com
Whole thread
Responses Re: [Patch]Add Graph* node support to expression_tree_mutator
List 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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: First draft of PG 19 release notes
Next
From: Alexander Korotkov
Date:
Subject: Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.