Re: [PATCH] Query Jumbling for CALL and SET utility statements

Hi,

On Thu, Sep 08, 2022 at 11:06:51AM +0200, Drouvot, Bertrand wrote:
> Hi,
>
> On 9/8/22 8:50 AM, Julien Rouhaud wrote:
>
> Thanks for looking at it!
>
> > On Thu, Sep 08, 2022 at 02:23:19PM +0900, Michael Paquier wrote:
> > > On Wed, Sep 07, 2022 at 06:19:42PM -0700, Jeremy Schneider wrote:
> > > > I didn't fully debug yet, but here's the backtrace on my 14.4 build with
> > > > the patch
> > > What happens on HEAD? That would be the target branch for a new
> > > feature.
> > It would be the same AFAICS. From v3:
> >
> > + case T_VariableSetStmt:
> > + {
> > + VariableSetStmt *stmt = (VariableSetStmt *) node;
> > +
> > + APP_JUMB_STRING(stmt->name);
> > + JumbleExpr(jstate, (Node *) stmt->args);
> > + }
> >
> > For a RESET ALL command stmt->name is NULL.
>
> Right, please find attached v4 addressing the issue and also Sami's comments
> [1].

(Sorry I've not been following this thread until now)

IME if your application relies on 2PC it's very likely that you will hit the
exact same problems described in your original email. What do you think about
normalizing those too while working on the subject?