Re: Generating code for query jumbling through gen_node_support.pl

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "Drouvot, Bertrand" <bdrouvot(at)amazon(dot)com>
Subject: Re: Generating code for query jumbling through gen_node_support.pl
Date: 2023-01-07 10:47:59
Message-ID: Y7lN323eAAkPcqAZ@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jan 07, 2023 at 07:37:49AM +0100, Peter Eisentraut wrote:
> The generation script already has a way to identify location fields, by ($t
> eq 'int' && $f =~ 'location$'), so you could use that as well.

I recall that some of the nodes may need renames to map with this
choice. That could be just one patch on top of the actual feature.

> I'm concerned about the large number of additional field annotations this
> adds. We have been careful so far to document the use of each attribute,
> e.g., *why* does a field not need to be copied etc. This patch adds dozens
> and dozens of annotations without any explanation at all. Now, the code
> this replaces also has no documentation, but maybe this is the time to add
> some.

In most cases, the addition of the node marker would be enough to
self-explain why they are included, but there is a trend for a lot of
the nodes when it comes to collations and typmods where we don't want
to see these in the jumbling calculations. I'll look at providing
more info for all that. (Note: I'm out for now.)
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2023-01-07 11:02:26 Re: [PATCH] Add function to_oct
Previous Message Amit Kapila 2023-01-07 10:30:32 Re: Notify downstream to discard the streamed transaction which was aborted due to crash.