diff options
| -rw-r--r-- | src/test/regress/expected/create_procedure.out | 17 | ||||
| -rw-r--r-- | src/test/regress/sql/create_procedure.sql | 9 |
2 files changed, 26 insertions, 0 deletions
diff --git a/src/test/regress/expected/create_procedure.out b/src/test/regress/expected/create_procedure.out index 8a32fd960c6..2177ba35090 100644 --- a/src/test/regress/expected/create_procedure.out +++ b/src/test/regress/expected/create_procedure.out @@ -227,6 +227,23 @@ CALL ptest6b(1.1, null, null); 1.1 | {1.1} (1 row) +CREATE PROCEDURE ptest6c(inout a anyelement, inout b anyelement) +LANGUAGE SQL +AS $$ +SELECT $1, 1; +$$; +CALL ptest6c(1, null); + a | b +---+--- + 1 | 1 +(1 row) + +CALL ptest6c(1.1, null); -- fails before v13 + a | b +-----+--- + 1.1 | 1 +(1 row) + -- collation assignment CREATE PROCEDURE ptest7(a text, b text) LANGUAGE SQL diff --git a/src/test/regress/sql/create_procedure.sql b/src/test/regress/sql/create_procedure.sql index b10cf71ca48..069a3727ced 100644 --- a/src/test/regress/sql/create_procedure.sql +++ b/src/test/regress/sql/create_procedure.sql @@ -149,6 +149,15 @@ $$; CALL ptest6b(1, null, null); CALL ptest6b(1.1, null, null); +CREATE PROCEDURE ptest6c(inout a anyelement, inout b anyelement) +LANGUAGE SQL +AS $$ +SELECT $1, 1; +$$; + +CALL ptest6c(1, null); +CALL ptest6c(1.1, null); -- fails before v13 + -- collation assignment |