Re: Add Nullif case for eval_const_expressions_mutator - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add Nullif case for eval_const_expressions_mutator
Date
Msg-id 888621.1616514337@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add Nullif case for eval_const_expressions_mutator  (David Steele <david@pgmasters.net>)
Responses RE: Add Nullif case for eval_const_expressions_mutator  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
List pgsql-hackers
David Steele <david@pgmasters.net> writes:
> Peter, thoughts on the new patch in [1]?

I'm not Peter, but I have a complaint about this bit:

+                if (!has_nonconst_input)
+                    return ece_evaluate_expr(expr);

That's not okay without a further check to see if the comparison function
used by the node is immutable.  Compare ScalarArrayOpExpr, for instance.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: multi-install PostgresNode
Next
From: Alvaro Herrera
Date:
Subject: Re: Nicer error when connecting to standby with hot_standby=off