SQL/JSON: Fix coercion of constructor outputs to types with typmod Ensure SQL/JSON constructor functions that allow specifying the target type using the RETURNING clause perform implicit cast to that type. This ensures that output values that exceed the specified length produce an error rather than being silently truncated. This behavior conforms to the SQL standard.
Reported-by: Alvaro Herrera <[email protected]> Reviewed-by: Jian He <[email protected]> Discussion: https://postgr.es/m/202405271326.5a5rprki64aw%40alvherre.pgsql Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/c2d93c3802b205d135d1ae1d7ac167d74e08a274 Modified Files -------------- src/backend/parser/parse_expr.c | 24 +++++++++++++++++++++++- src/test/regress/expected/sqljson.out | 17 +++++++++++++++++ src/test/regress/sql/sqljson.sql | 12 ++++++++++++ 3 files changed, 52 insertions(+), 1 deletion(-)
