| From: | Amit Langote <amitlan(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: SQL/JSON: Improve error-handling of JsonBehavior expressions |
| Date: | 2024-07-26 07:43:43 |
| Message-ID: | E1sXFc7-001Ge8-2C@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
SQL/JSON: Improve error-handling of JsonBehavior expressions
Instead of returning a NULL when the JsonBehavior expression value
could not be coerced to the RETURNING type, throw the error message
informing the user that it is the JsonBehavior expression that caused
the error with the actual coercion error message shown in its DETAIL
line.
Discussion: https://postgr.es/m/CACJufxEo4sUjKCYtda0_qt9tazqqKPmF1cqhW9KBOUeJFqQd2g@mail.gmail.com
Backpatch-through: 17
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/231b7d670b218d6a5cde0574cf160c8157ab91fb
Modified Files
--------------
src/backend/executor/execExprInterp.c | 78 +++++++++++++++++++++---
src/test/regress/expected/sqljson_jsontable.out | 7 +--
src/test/regress/expected/sqljson_queryfuncs.out | 21 ++-----
3 files changed, 78 insertions(+), 28 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2024-07-26 09:19:30 | pgsql: Disable all TLS session tickets |
| Previous Message | Amit Langote | 2024-07-26 07:43:29 | pgsql: SQL/JSON: Improve error-handling of JsonBehavior expressions |