From: | Amit Langote <amitlan(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: SQL/JSON: Fix some oversights in commit b6e1157e7 |
Date: | 2024-10-20 03:40:47 |
Message-ID: | E1t2MoC-001a3f-8e@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
SQL/JSON: Fix some oversights in commit b6e1157e7
The decision in b6e1157e7 to ignore raw_expr when evaluating a
JsonValueExpr was incorrect. While its value is not ultimately
used (since formatted_expr's value is), failing to initialize it
can lead to problems, for instance, when the expression tree in
raw_expr contains Aggref nodes, which must be initialized to
ensure the parent Agg node works correctly.
Also, optimize eval_const_expressions_mutator()'s handling of
JsonValueExpr a bit. Currently, when formatted_expr cannot be folded
into a constant, we end up processing it twice -- once directly in
eval_const_expressions_mutator() and again recursively via
ece_generic_processing(). This recursive processing is required to
handle raw_expr. To avoid the redundant processing of formatted_expr,
we now process raw_expr directly in eval_const_expressions_mutator().
Finally, update the comment of JsonValueExpr to describe the roles of
raw_expr and formatted_expr more clearly.
Bug: #18657
Reported-by: Alexander Lakhin <exclusion(at)gmail(dot)com>
Diagnosed-by: Fabio R. Sluzala <fabio3rs(at)gmail(dot)com>
Diagnosed-by: Tender Wang <tndrwang(at)gmail(dot)com>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/18657-1b90ccce2b16bdb8@postgresql.org
Backpatch-through: 16
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/7148cb3e3067a21f98031ff4d01be8895b5d164e
Modified Files
--------------
src/backend/executor/execExpr.c | 2 ++
src/backend/optimizer/util/clauses.c | 24 ++++++++++++-----
src/include/nodes/primnodes.h | 14 ++++++----
src/test/regress/expected/sqljson.out | 49 +++++++++++++++++++++++++++++++++++
src/test/regress/sql/sqljson.sql | 14 ++++++++++
5 files changed, 92 insertions(+), 11 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2024-10-20 03:41:01 | pgsql: SQL/JSON: Fix some oversights in commit b6e1157e7 |
Previous Message | Amit Langote | 2024-10-20 03:40:34 | pgsql: SQL/JSON: Fix some oversights in commit b6e1157e7 |