diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/rangefuncs.out | 11 | ||||
| -rw-r--r-- | src/test/regress/sql/rangefuncs.sql | 7 |
2 files changed, 18 insertions, 0 deletions
diff --git a/src/test/regress/expected/rangefuncs.out b/src/test/regress/expected/rangefuncs.out index 45ffd85b1b7..37391dcfce7 100644 --- a/src/test/regress/expected/rangefuncs.out +++ b/src/test/regress/expected/rangefuncs.out @@ -1247,6 +1247,17 @@ SELECT * FROM foo(3); (9 rows) DROP FUNCTION foo(int); +-- case that causes change of typmod knowledge during inlining +CREATE OR REPLACE FUNCTION foo() +RETURNS TABLE(a varchar(5)) +AS $$ SELECT 'hello'::varchar(5) $$ LANGUAGE sql STABLE; +SELECT * FROM foo() GROUP BY 1; + a +------- + hello +(1 row) + +DROP FUNCTION foo(); -- -- some tests on SQL functions with RETURNING -- diff --git a/src/test/regress/sql/rangefuncs.sql b/src/test/regress/sql/rangefuncs.sql index d522cdb10e4..e82a1d55712 100644 --- a/src/test/regress/sql/rangefuncs.sql +++ b/src/test/regress/sql/rangefuncs.sql @@ -330,6 +330,13 @@ AS $$ SELECT a, b SELECT * FROM foo(3); DROP FUNCTION foo(int); +-- case that causes change of typmod knowledge during inlining +CREATE OR REPLACE FUNCTION foo() +RETURNS TABLE(a varchar(5)) +AS $$ SELECT 'hello'::varchar(5) $$ LANGUAGE sql STABLE; +SELECT * FROM foo() GROUP BY 1; +DROP FUNCTION foo(); + -- -- some tests on SQL functions with RETURNING -- |