diff options
Diffstat (limited to 'src/test/regress/expected/rangefuncs.out')
| -rw-r--r-- | src/test/regress/expected/rangefuncs.out | 24 |
1 files changed, 23 insertions, 1 deletions
diff --git a/src/test/regress/expected/rangefuncs.out b/src/test/regress/expected/rangefuncs.out index 7991e993f14..6dabe503cc0 100644 --- a/src/test/regress/expected/rangefuncs.out +++ b/src/test/regress/expected/rangefuncs.out @@ -2034,7 +2034,7 @@ select x from int8_tbl, extractq2(int8_tbl) f(x); (5 rows) create function extractq2_2(t int8_tbl) returns table(ret1 int8) as $$ - select extractq2(t) + select extractq2(t) offset 0 $$ language sql immutable; explain (verbose, costs off) select x from int8_tbl, extractq2_2(int8_tbl) f(x); @@ -2058,3 +2058,25 @@ select x from int8_tbl, extractq2_2(int8_tbl) f(x); -4567890123456789 (5 rows) +-- without the "offset 0", this function gets optimized quite differently +create function extractq2_2_opt(t int8_tbl) returns table(ret1 int8) as $$ + select extractq2(t) +$$ language sql immutable; +explain (verbose, costs off) +select x from int8_tbl, extractq2_2_opt(int8_tbl) f(x); + QUERY PLAN +----------------------------- + Seq Scan on public.int8_tbl + Output: int8_tbl.q2 +(2 rows) + +select x from int8_tbl, extractq2_2_opt(int8_tbl) f(x); + x +------------------- + 456 + 4567890123456789 + 123 + 4567890123456789 + -4567890123456789 +(5 rows) + |