projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 065583c) | patch
SQL/JSON: Fix coercion of constructor outputs to types with typmod
authorAmit Langote
Fri, 28 Jun 2024 12:37:14 +0000 (21:37 +0900)
committerAmit Langote
Fri, 28 Jun 2024 12:48:44 +0000 (21:48 +0900)
commitc2d93c3802b205d135d1ae1d7ac167d74e08a274
tree1ae99e52fd159f09b2bb8f35f794f89c42c9f8bbtree
parent065583cf460f980a182498941ac52810f709a897commit | diff
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
Reviewed-by: Jian He
Discussion: https://postgr.es/m/202405271326.5a5rprki64aw%40alvherre.pgsql
src/backend/parser/parse_expr.c diff | blob | blame | history
src/test/regress/expected/sqljson.out diff | blob | blame | history
src/test/regress/sql/sqljson.sql diff | blob | blame | history
This is the main PostgreSQL git repository.