Google Git
Sign in
apache / cloudberry / refs/heads/cbdb-postgres-merge / . / src / test / regress / expected / qp_functions_in_from.out
blob: f6426617468664eb3acb2b2a9de9d9842c42e3ed [file] [log] [blame]
-- Create our own copies of these test tables in our own
-- schema (see qp_functions_in_contexts_setup.sql)
CREATE SCHEMA qp_funcs_in_from;
set search_path='qp_funcs_in_from', 'qp_funcs_in_contexts';
CREATE TABLE foo (a int, b int);
INSERT INTO foo select i, i+1 from generate_series(1,10) i;
CREATE TABLE bar (c int, d int);
INSERT INTO bar select i, i+1 from generate_series(1,10) i;
ANALYZE foo;
ANALYZE bar;
-- @description function_in_from_0.sql
SELECT * FROM func1_nosql_vol(5) order by 1;
func1_nosql_vol
-----------------
6
(1 row)
-- @description function_in_from_1.sql
SELECT * FROM func1_nosql_stb(5) order by 1;
func1_nosql_stb
-----------------
6
(1 row)
-- @description function_in_from_2.sql
SELECT * FROM func1_nosql_imm(5) order by 1;
func1_nosql_imm
-----------------
6
(1 row)
-- @description function_in_from_3.sql
SELECT * FROM func1_sql_int_vol(5) order by 1;
func1_sql_int_vol
-------------------
6
(1 row)
-- @description function_in_from_4.sql
SELECT * FROM func1_sql_int_stb(5) order by 1;
func1_sql_int_stb
-------------------
6
(1 row)
-- @description function_in_from_5.sql
SELECT * FROM func1_sql_int_imm(5) order by 1;
func1_sql_int_imm
-------------------
6
(1 row)
-- @description function_in_from_6.sql
SELECT * FROM func1_sql_setint_vol(5) order by 1;
func1_sql_setint_vol
----------------------
5
6
7
8
9
10
(6 rows)
-- @description function_in_from_7.sql
SELECT * FROM func1_sql_setint_stb(5) order by 1;
func1_sql_setint_stb
----------------------
5
6
7
8
9
10
(6 rows)
-- @description function_in_from_8.sql
SELECT * FROM func1_sql_setint_imm(5) order by 1;
func1_sql_setint_imm
----------------------
5
6
7
8
9
10
(6 rows)
-- @description function_in_from_9.sql
SELECT * FROM func1_read_int_sql_vol(5) order by 1;
func1_read_int_sql_vol
------------------------
6
(1 row)
-- @description function_in_from_10.sql
SELECT * FROM func1_read_int_sql_stb(5) order by 1;
func1_read_int_sql_stb
------------------------
6
(1 row)
-- @description function_in_from_11.sql
SELECT * FROM func1_read_setint_sql_vol(5) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
7
8
9
10
11
(9 rows)
-- @description function_in_from_12.sql
SELECT * FROM func1_read_setint_sql_stb(5) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
7
8
9
10
11
(9 rows)
-- @description function_in_from_13.sql
begin;
SELECT * FROM func1_mod_int_vol(5) order by 1;
func1_mod_int_vol
-------------------
6
(1 row)
rollback;
-- @description function_in_from_14.sql
begin;
SELECT * FROM func1_mod_int_stb(5) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_15.sql
begin;
SELECT * FROM func1_mod_setint_vol(5) order by 1;
func1_mod_setint_vol
----------------------
8
9
10
11
12
(5 rows)
rollback;
-- @description function_in_from_16.sql
begin;
SELECT * FROM func1_mod_setint_stb(5) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_0.sql
SELECT * FROM func1_nosql_vol(5), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_1.sql
SELECT * FROM func1_nosql_stb(5), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_2.sql
SELECT * FROM func1_nosql_imm(5), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_3.sql
SELECT * FROM func1_sql_int_vol(5), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_4.sql
SELECT * FROM func1_sql_int_stb(5), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_5.sql
SELECT * FROM func1_sql_int_imm(5), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_6.sql
SELECT * FROM func1_sql_setint_vol(5), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
5 | 1 | 2
5 | 2 | 3
5 | 3 | 4
5 | 4 | 5
5 | 5 | 6
5 | 6 | 7
5 | 7 | 8
5 | 8 | 9
5 | 9 | 10
5 | 10 | 11
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
(60 rows)
-- @description function_in_from_join_7.sql
SELECT * FROM func1_sql_setint_stb(5), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
5 | 1 | 2
5 | 2 | 3
5 | 3 | 4
5 | 4 | 5
5 | 5 | 6
5 | 6 | 7
5 | 7 | 8
5 | 8 | 9
5 | 9 | 10
5 | 10 | 11
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
(60 rows)
-- @description function_in_from_join_8.sql
SELECT * FROM func1_sql_setint_imm(5), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
5 | 1 | 2
5 | 2 | 3
5 | 3 | 4
5 | 4 | 5
5 | 5 | 6
5 | 6 | 7
5 | 7 | 8
5 | 8 | 9
5 | 9 | 10
5 | 10 | 11
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
(60 rows)
-- @description function_in_from_join_9.sql
SELECT * FROM func1_read_int_sql_vol(5), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_10.sql
SELECT * FROM func1_read_int_sql_stb(5), foo order by 1,2,3;
func1_read_int_sql_stb | a | b
------------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
(10 rows)
-- @description function_in_from_join_13.sql
begin;
SELECT * FROM func1_mod_int_vol(5), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_14.sql
begin;
SELECT * FROM func1_mod_int_stb(5), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_0.sql
SELECT * FROM func1_nosql_vol(func2_nosql_vol(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_1.sql
SELECT * FROM func1_nosql_vol(func2_nosql_stb(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_2.sql
SELECT * FROM func1_nosql_vol(func2_nosql_imm(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_3.sql
SELECT * FROM func1_nosql_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_4.sql
SELECT * FROM func1_nosql_vol(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_5.sql
SELECT * FROM func1_nosql_vol(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_6.sql
SELECT * FROM func1_nosql_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_7.sql
SELECT * FROM func1_nosql_vol(func2_read_int_stb(5)), foo order by 1,2,3;
func1_nosql_vol | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_8.sql
begin;
SELECT * FROM func1_nosql_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_9.sql
begin;
SELECT * FROM func1_nosql_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_10.sql
SELECT * FROM func1_nosql_stb(func2_nosql_vol(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_11.sql
SELECT * FROM func1_nosql_stb(func2_nosql_stb(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_12.sql
SELECT * FROM func1_nosql_stb(func2_nosql_imm(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_13.sql
SELECT * FROM func1_nosql_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_14.sql
SELECT * FROM func1_nosql_stb(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_15.sql
SELECT * FROM func1_nosql_stb(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_16.sql
SELECT * FROM func1_nosql_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_17.sql
SELECT * FROM func1_nosql_stb(func2_read_int_stb(5)), foo order by 1,2,3;
func1_nosql_stb | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_18.sql
begin;
SELECT * FROM func1_nosql_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_19.sql
begin;
SELECT * FROM func1_nosql_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_20.sql
SELECT * FROM func1_nosql_imm(func2_nosql_vol(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_21.sql
SELECT * FROM func1_nosql_imm(func2_nosql_stb(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_22.sql
SELECT * FROM func1_nosql_imm(func2_nosql_imm(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_23.sql
SELECT * FROM func1_nosql_imm(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_24.sql
SELECT * FROM func1_nosql_imm(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_25.sql
SELECT * FROM func1_nosql_imm(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_26.sql
SELECT * FROM func1_nosql_imm(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_27.sql
SELECT * FROM func1_nosql_imm(func2_read_int_stb(5)), foo order by 1,2,3;
func1_nosql_imm | a | b
-----------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_28.sql
begin;
SELECT * FROM func1_nosql_imm(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_29.sql
begin;
SELECT * FROM func1_nosql_imm(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_30.sql
SELECT * FROM func1_sql_int_vol(func2_nosql_vol(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_31.sql
SELECT * FROM func1_sql_int_vol(func2_nosql_stb(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_32.sql
SELECT * FROM func1_sql_int_vol(func2_nosql_imm(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_33.sql
SELECT * FROM func1_sql_int_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_34.sql
SELECT * FROM func1_sql_int_vol(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_35.sql
SELECT * FROM func1_sql_int_vol(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_36.sql
SELECT * FROM func1_sql_int_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_37.sql
SELECT * FROM func1_sql_int_vol(func2_read_int_stb(5)), foo order by 1,2,3;
func1_sql_int_vol | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_38.sql
begin;
SELECT * FROM func1_sql_int_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_39.sql
begin;
SELECT * FROM func1_sql_int_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_40.sql
SELECT * FROM func1_sql_int_stb(func2_nosql_vol(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_41.sql
SELECT * FROM func1_sql_int_stb(func2_nosql_stb(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_42.sql
SELECT * FROM func1_sql_int_stb(func2_nosql_imm(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_43.sql
SELECT * FROM func1_sql_int_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_44.sql
SELECT * FROM func1_sql_int_stb(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_45.sql
SELECT * FROM func1_sql_int_stb(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_46.sql
SELECT * FROM func1_sql_int_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_47.sql
SELECT * FROM func1_sql_int_stb(func2_read_int_stb(5)), foo order by 1,2,3;
func1_sql_int_stb | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_48.sql
begin;
SELECT * FROM func1_sql_int_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_49.sql
begin;
SELECT * FROM func1_sql_int_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_50.sql
SELECT * FROM func1_sql_int_imm(func2_nosql_vol(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_51.sql
SELECT * FROM func1_sql_int_imm(func2_nosql_stb(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_52.sql
SELECT * FROM func1_sql_int_imm(func2_nosql_imm(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_53.sql
SELECT * FROM func1_sql_int_imm(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_54.sql
SELECT * FROM func1_sql_int_imm(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_55.sql
SELECT * FROM func1_sql_int_imm(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_56.sql
SELECT * FROM func1_sql_int_imm(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_57.sql
SELECT * FROM func1_sql_int_imm(func2_read_int_stb(5)), foo order by 1,2,3;
func1_sql_int_imm | a | b
-------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_58.sql
begin;
SELECT * FROM func1_sql_int_imm(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_59.sql
begin;
SELECT * FROM func1_sql_int_imm(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_60.sql
SELECT * FROM func1_sql_setint_vol(func2_nosql_vol(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_61.sql
SELECT * FROM func1_sql_setint_vol(func2_nosql_stb(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_62.sql
SELECT * FROM func1_sql_setint_vol(func2_nosql_imm(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_63.sql
SELECT * FROM func1_sql_setint_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_64.sql
SELECT * FROM func1_sql_setint_vol(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_65.sql
SELECT * FROM func1_sql_setint_vol(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_66.sql
SELECT * FROM func1_sql_setint_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_67.sql
SELECT * FROM func1_sql_setint_vol(func2_read_int_stb(5)), foo order by 1,2,3;
func1_sql_setint_vol | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_68.sql
begin;
SELECT * FROM func1_sql_setint_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_69.sql
begin;
SELECT * FROM func1_sql_setint_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_70.sql
SELECT * FROM func1_sql_setint_stb(func2_nosql_vol(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_71.sql
SELECT * FROM func1_sql_setint_stb(func2_nosql_stb(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_72.sql
SELECT * FROM func1_sql_setint_stb(func2_nosql_imm(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_73.sql
SELECT * FROM func1_sql_setint_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_74.sql
SELECT * FROM func1_sql_setint_stb(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_75.sql
SELECT * FROM func1_sql_setint_stb(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_76.sql
SELECT * FROM func1_sql_setint_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_77.sql
SELECT * FROM func1_sql_setint_stb(func2_read_int_stb(5)), foo order by 1,2,3;
func1_sql_setint_stb | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_78.sql
begin;
SELECT * FROM func1_sql_setint_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_79.sql
begin;
SELECT * FROM func1_sql_setint_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_80.sql
SELECT * FROM func1_sql_setint_imm(func2_nosql_vol(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_81.sql
SELECT * FROM func1_sql_setint_imm(func2_nosql_stb(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_82.sql
SELECT * FROM func1_sql_setint_imm(func2_nosql_imm(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_83.sql
SELECT * FROM func1_sql_setint_imm(func2_sql_int_vol(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_84.sql
SELECT * FROM func1_sql_setint_imm(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_85.sql
SELECT * FROM func1_sql_setint_imm(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_86.sql
SELECT * FROM func1_sql_setint_imm(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_87.sql
SELECT * FROM func1_sql_setint_imm(func2_read_int_stb(5)), foo order by 1,2,3;
func1_sql_setint_imm | a | b
----------------------+----+----
6 | 1 | 2
6 | 2 | 3
6 | 3 | 4
6 | 4 | 5
6 | 5 | 6
6 | 6 | 7
6 | 7 | 8
6 | 8 | 9
6 | 9 | 10
6 | 10 | 11
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
8 | 1 | 2
8 | 2 | 3
8 | 3 | 4
8 | 4 | 5
8 | 5 | 6
8 | 6 | 7
8 | 7 | 8
8 | 8 | 9
8 | 9 | 10
8 | 10 | 11
9 | 1 | 2
9 | 2 | 3
9 | 3 | 4
9 | 4 | 5
9 | 5 | 6
9 | 6 | 7
9 | 7 | 8
9 | 8 | 9
9 | 9 | 10
9 | 10 | 11
10 | 1 | 2
10 | 2 | 3
10 | 3 | 4
10 | 4 | 5
10 | 5 | 6
10 | 6 | 7
10 | 7 | 8
10 | 8 | 9
10 | 9 | 10
10 | 10 | 11
11 | 1 | 2
11 | 2 | 3
11 | 3 | 4
11 | 4 | 5
11 | 5 | 6
11 | 6 | 7
11 | 7 | 8
11 | 8 | 9
11 | 9 | 10
11 | 10 | 11
(60 rows)
-- @description function_in_from_join_withfunc2_88.sql
begin;
SELECT * FROM func1_sql_setint_imm(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_89.sql
begin;
SELECT * FROM func1_sql_setint_imm(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_90.sql
SELECT * FROM func1_read_int_sql_vol(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_91.sql
SELECT * FROM func1_read_int_sql_vol(func2_nosql_stb(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_92.sql
SELECT * FROM func1_read_int_sql_vol(func2_nosql_imm(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_93.sql
SELECT * FROM func1_read_int_sql_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_94.sql
SELECT * FROM func1_read_int_sql_vol(func2_sql_int_stb(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_95.sql
SELECT * FROM func1_read_int_sql_vol(func2_sql_int_imm(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_96.sql
SELECT * FROM func1_read_int_sql_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_97.sql
SELECT * FROM func1_read_int_sql_vol(func2_read_int_stb(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_98.sql
begin;
SELECT * FROM func1_read_int_sql_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_99.sql
begin;
SELECT * FROM func1_read_int_sql_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_100.sql
SELECT * FROM func1_read_int_sql_stb(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_stb(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_101.sql
SELECT * FROM func1_read_int_sql_stb(func2_nosql_stb(5)), foo order by 1,2,3;
func1_read_int_sql_stb | a | b
------------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_102.sql
SELECT * FROM func1_read_int_sql_stb(func2_nosql_imm(5)), foo order by 1,2,3;
func1_read_int_sql_stb | a | b
------------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_103.sql
SELECT * FROM func1_read_int_sql_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_stb(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_104.sql
SELECT * FROM func1_read_int_sql_stb(func2_sql_int_stb(5)), foo order by 1,2,3;
func1_read_int_sql_stb | a | b
------------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_105.sql
SELECT * FROM func1_read_int_sql_stb(func2_sql_int_imm(5)), foo order by 1,2,3;
func1_read_int_sql_stb | a | b
------------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_106.sql
SELECT * FROM func1_read_int_sql_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_107.sql
SELECT * FROM func1_read_int_sql_stb(func2_read_int_stb(5)), foo order by 1,2,3;
func1_read_int_sql_stb | a | b
------------------------+----+----
7 | 1 | 2
7 | 2 | 3
7 | 3 | 4
7 | 4 | 5
7 | 5 | 6
7 | 6 | 7
7 | 7 | 8
7 | 8 | 9
7 | 9 | 10
7 | 10 | 11
(10 rows)
-- @description function_in_from_join_withfunc2_108.sql
begin;
SELECT * FROM func1_read_int_sql_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_109.sql
begin;
SELECT * FROM func1_read_int_sql_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_110.sql
SELECT * FROM func1_read_setint_sql_vol(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_vol(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_join_withfunc2_113.sql
SELECT * FROM func1_read_setint_sql_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_vol(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_join_withfunc2_116.sql
SELECT * FROM func1_read_setint_sql_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_118.sql
begin;
SELECT * FROM func1_read_setint_sql_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_119.sql
begin;
SELECT * FROM func1_read_setint_sql_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_120.sql
SELECT * FROM func1_read_setint_sql_stb(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_stb(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_join_withfunc2_123.sql
SELECT * FROM func1_read_setint_sql_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_stb(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_join_withfunc2_126.sql
SELECT * FROM func1_read_setint_sql_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_join_withfunc2_128.sql
begin;
SELECT * FROM func1_read_setint_sql_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_129.sql
begin;
SELECT * FROM func1_read_setint_sql_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_130.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_131.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_nosql_stb(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_132.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_nosql_imm(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_133.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_134.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_sql_int_stb(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_135.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_sql_int_imm(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_136.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_137.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_read_int_stb(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_138.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_139.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_140.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_141.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_nosql_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_142.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_nosql_imm(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_143.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_144.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_sql_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_145.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_sql_int_imm(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_146.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_147.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_read_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_148.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=118114)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_149.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_150.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_153.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_156.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_158.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_159.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_160.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_nosql_vol(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_163.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_sql_int_vol(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_166.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_read_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_168.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_mod_int_vol(5)), foo order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_join_withfunc2_169.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_mod_int_stb(5)), foo order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_0.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(5)) r order by 1,2,3 ;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_1.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(5)) r order by 1,2,3 ;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_2.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(5)) r order by 1,2,3 ;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_3.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(5)) r order by 1,2,3 ;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_4.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(5)) r order by 1,2,3 ;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_5.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(5)) r order by 1,2,3 ;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_6.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(5)) r order by 1,2,3 ;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 5
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
2 | 3 | 5
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
3 | 4 | 5
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
4 | 5 | 5
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
5 | 6 | 5
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
6 | 7 | 5
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
7 | 8 | 5
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
8 | 9 | 5
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
9 | 10 | 5
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
10 | 11 | 5
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
(60 rows)
-- @description function_in_from_subqry_7.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(5)) r order by 1,2,3 ;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 5
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
2 | 3 | 5
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
3 | 4 | 5
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
4 | 5 | 5
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
5 | 6 | 5
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
6 | 7 | 5
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
7 | 8 | 5
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
8 | 9 | 5
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
9 | 10 | 5
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
10 | 11 | 5
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
(60 rows)
-- @description function_in_from_subqry_8.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(5)) r order by 1,2,3 ;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 5
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
2 | 3 | 5
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
3 | 4 | 5
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
4 | 5 | 5
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
5 | 6 | 5
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
6 | 7 | 5
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
7 | 8 | 5
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
8 | 9 | 5
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
9 | 10 | 5
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
10 | 11 | 5
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
(60 rows)
-- @description function_in_from_subqry_9.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(5)) r order by 1,2,3 ;
a | b | func1_read_int_sql_vol
----+----+------------------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_10.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(5)) r order by 1,2,3 ;
a | b | func1_read_int_sql_stb
----+----+------------------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
-- @description function_in_from_subqry_13.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(5)) r order by 1,2,3 ;
a | b | func1_mod_int_vol
----+----+-------------------
1 | 2 | 6
2 | 3 | 6
3 | 4 | 6
4 | 5 | 6
5 | 6 | 6
6 | 7 | 6
7 | 8 | 6
8 | 9 | 6
9 | 10 | 6
10 | 11 | 6
(10 rows)
rollback;
-- @description function_in_from_subqry_14.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(5)) r order by 1,2,3 ;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_0.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_1.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_2.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_3.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_4.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_5.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_6.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_read_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_7.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_8.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_mod_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_vol
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_9.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_nosql_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_10.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_11.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_12.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_13.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_14.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_15.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_16.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_read_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_17.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_18.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_mod_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_stb
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_19.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_nosql_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_20.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_21.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_22.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_23.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_24.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_25.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_26.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_read_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_27.sql
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_28.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_mod_int_vol(5))) r order by 1,2,3;
a | b | func1_nosql_imm
----+----+-----------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_29.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_nosql_imm(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_30.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_31.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_32.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_33.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_34.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_35.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_36.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_read_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_37.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_38.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_mod_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_39.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_int_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_40.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_41.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_42.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_43.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_44.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_45.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_46.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_read_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_47.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_48.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_mod_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_stb
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_49.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_int_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_50.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_51.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_52.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_53.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_54.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_55.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_56.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_read_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_57.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_58.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_mod_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_int_imm
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_59.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_int_imm(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_60.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_61.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_62.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_63.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_64.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_65.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_66.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_67.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_vol
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_68.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_69.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_70.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_71.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_72.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_73.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_74.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_75.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_76.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_77.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_stb
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_78.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_79.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_80.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_nosql_vol(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_81.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_82.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_83.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_sql_int_vol(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_84.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_85.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_86.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_87.sql
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_sql_setint_imm
----+----+----------------------
1 | 2 | 6
1 | 2 | 7
1 | 2 | 8
1 | 2 | 9
1 | 2 | 10
1 | 2 | 11
2 | 3 | 6
2 | 3 | 7
2 | 3 | 8
2 | 3 | 9
2 | 3 | 10
2 | 3 | 11
3 | 4 | 6
3 | 4 | 7
3 | 4 | 8
3 | 4 | 9
3 | 4 | 10
3 | 4 | 11
4 | 5 | 6
4 | 5 | 7
4 | 5 | 8
4 | 5 | 9
4 | 5 | 10
4 | 5 | 11
5 | 6 | 6
5 | 6 | 7
5 | 6 | 8
5 | 6 | 9
5 | 6 | 10
5 | 6 | 11
6 | 7 | 6
6 | 7 | 7
6 | 7 | 8
6 | 7 | 9
6 | 7 | 10
6 | 7 | 11
7 | 8 | 6
7 | 8 | 7
7 | 8 | 8
7 | 8 | 9
7 | 8 | 10
7 | 8 | 11
8 | 9 | 6
8 | 9 | 7
8 | 9 | 8
8 | 9 | 9
8 | 9 | 10
8 | 9 | 11
9 | 10 | 6
9 | 10 | 7
9 | 10 | 8
9 | 10 | 9
9 | 10 | 10
9 | 10 | 11
10 | 11 | 6
10 | 11 | 7
10 | 11 | 8
10 | 11 | 9
10 | 11 | 10
10 | 11 | 11
(60 rows)
-- @description function_in_from_subqry_withfunc2_88.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_89.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_90.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119522)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_91.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_read_int_sql_vol
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_92.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_read_int_sql_vol
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_93.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119539)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_94.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_read_int_sql_vol
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_95.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_read_int_sql_vol
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_96.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119555)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_97.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_read_int_sql_vol
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_98.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119569)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_99.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_100.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119569)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_stb(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_101.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_read_int_sql_stb
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_102.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_read_int_sql_stb
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_103.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119569)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_stb(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_104.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_read_int_sql_stb
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_105.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_read_int_sql_stb
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_106.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119569)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_stb(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_107.sql
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_read_int_sql_stb
----+----+------------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
-- @description function_in_from_subqry_withfunc2_108.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it accesses relation "qp_funcs_in_from.bar" (entry db 172.17.0.6:15432 pid=119569)
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func1_read_int_sql_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_109.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_int_sql_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_110.sql
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_vol(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_vol(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_subqry_withfunc2_113.sql
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_vol(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_vol(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_subqry_withfunc2_116.sql
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_vol(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_118.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_vol(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_119.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_120.sql
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_stb(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_stb(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_subqry_withfunc2_123.sql
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_stb(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c <> $1"
PL/pgSQL function func1_read_setint_sql_stb(integer) line 5 at FOR over SELECT rows
-- @description function_in_from_subqry_withfunc2_126.sql
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_stb(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
-- @description function_in_from_subqry_withfunc2_128.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_stb(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_129.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_read_setint_sql_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_130.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119569)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_131.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_nosql_stb(5))) r order by 1,2,3;
a | b | func1_mod_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_132.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_nosql_imm(5))) r order by 1,2,3;
a | b | func1_mod_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_133.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119637)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_134.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_sql_int_stb(5))) r order by 1,2,3;
a | b | func1_mod_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_135.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_sql_int_imm(5))) r order by 1,2,3;
a | b | func1_mod_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_136.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119651)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_137.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_read_int_stb(5))) r order by 1,2,3;
a | b | func1_mod_int_vol
----+----+-------------------
1 | 2 | 7
2 | 3 | 7
3 | 4 | 7
4 | 5 | 7
5 | 6 | 7
6 | 7 | 7
7 | 8 | 7
8 | 9 | 7
9 | 10 | 7
10 | 11 | 7
(10 rows)
rollback;
-- @description function_in_from_subqry_withfunc2_138.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119666)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_139.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_140.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119666)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_141.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_nosql_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_142.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_nosql_imm(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_143.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119666)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_144.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_sql_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_145.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_sql_int_imm(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_146.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119666)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_147.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_read_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_148.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: function cannot execute on a QE slice because it issues a non-SELECT statement (entry db 172.17.0.6:15432 pid=119666)
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_149.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_int_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_150.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_vol(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_153.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_vol(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_156.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_vol(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_158.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_vol(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_159.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_vol(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_160.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_stb(func2_nosql_vol(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_163.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_stb(func2_sql_int_vol(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_166.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_stb(func2_read_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1"
PL/pgSQL function func2_read_int_vol(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_168.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_stb(func2_mod_int_vol(5))) r order by 1,2,3;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_vol(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_subqry_withfunc2_169.sql
begin;
SELECT * FROM foo, (SELECT * FROM func1_mod_setint_stb(func2_mod_int_stb(5))) r order by 1,2,3;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_0.sql
SELECT * FROM func1_nosql_vol(func2_nosql_vol(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_1.sql
SELECT * FROM func1_nosql_vol(func2_nosql_stb(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_2.sql
SELECT * FROM func1_nosql_vol(func2_nosql_imm(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_3.sql
SELECT * FROM func1_nosql_vol(func2_sql_int_vol(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_4.sql
SELECT * FROM func1_nosql_vol(func2_sql_int_stb(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_5.sql
SELECT * FROM func1_nosql_vol(func2_sql_int_imm(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_6.sql
SELECT * FROM func1_nosql_vol(func2_read_int_vol(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_7.sql
SELECT * FROM func1_nosql_vol(func2_read_int_stb(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_8.sql
begin;
SELECT * FROM func1_nosql_vol(func2_mod_int_vol(5)) order by 1;
func1_nosql_vol
-----------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_9.sql
begin;
SELECT * FROM func1_nosql_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_10.sql
SELECT * FROM func1_nosql_stb(func2_nosql_vol(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_11.sql
SELECT * FROM func1_nosql_stb(func2_nosql_stb(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_12.sql
SELECT * FROM func1_nosql_stb(func2_nosql_imm(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_13.sql
SELECT * FROM func1_nosql_stb(func2_sql_int_vol(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_14.sql
SELECT * FROM func1_nosql_stb(func2_sql_int_stb(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_15.sql
SELECT * FROM func1_nosql_stb(func2_sql_int_imm(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_16.sql
SELECT * FROM func1_nosql_stb(func2_read_int_vol(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_17.sql
SELECT * FROM func1_nosql_stb(func2_read_int_stb(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_18.sql
begin;
SELECT * FROM func1_nosql_stb(func2_mod_int_vol(5)) order by 1;
func1_nosql_stb
-----------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_19.sql
begin;
SELECT * FROM func1_nosql_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_20.sql
SELECT * FROM func1_nosql_imm(func2_nosql_vol(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_21.sql
SELECT * FROM func1_nosql_imm(func2_nosql_stb(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_22.sql
SELECT * FROM func1_nosql_imm(func2_nosql_imm(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_23.sql
SELECT * FROM func1_nosql_imm(func2_sql_int_vol(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_24.sql
SELECT * FROM func1_nosql_imm(func2_sql_int_stb(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_25.sql
SELECT * FROM func1_nosql_imm(func2_sql_int_imm(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_26.sql
SELECT * FROM func1_nosql_imm(func2_read_int_vol(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_27.sql
SELECT * FROM func1_nosql_imm(func2_read_int_stb(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
-- @description function_in_from_withfunc2_28.sql
begin;
SELECT * FROM func1_nosql_imm(func2_mod_int_vol(5)) order by 1;
func1_nosql_imm
-----------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_29.sql
begin;
SELECT * FROM func1_nosql_imm(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_30.sql
SELECT * FROM func1_sql_int_vol(func2_nosql_vol(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_31.sql
SELECT * FROM func1_sql_int_vol(func2_nosql_stb(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_32.sql
SELECT * FROM func1_sql_int_vol(func2_nosql_imm(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_33.sql
SELECT * FROM func1_sql_int_vol(func2_sql_int_vol(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_34.sql
SELECT * FROM func1_sql_int_vol(func2_sql_int_stb(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_35.sql
SELECT * FROM func1_sql_int_vol(func2_sql_int_imm(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_36.sql
SELECT * FROM func1_sql_int_vol(func2_read_int_vol(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_37.sql
SELECT * FROM func1_sql_int_vol(func2_read_int_stb(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_38.sql
begin;
SELECT * FROM func1_sql_int_vol(func2_mod_int_vol(5)) order by 1;
func1_sql_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_39.sql
begin;
SELECT * FROM func1_sql_int_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_40.sql
SELECT * FROM func1_sql_int_stb(func2_nosql_vol(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_41.sql
SELECT * FROM func1_sql_int_stb(func2_nosql_stb(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_42.sql
SELECT * FROM func1_sql_int_stb(func2_nosql_imm(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_43.sql
SELECT * FROM func1_sql_int_stb(func2_sql_int_vol(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_44.sql
SELECT * FROM func1_sql_int_stb(func2_sql_int_stb(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_45.sql
SELECT * FROM func1_sql_int_stb(func2_sql_int_imm(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_46.sql
SELECT * FROM func1_sql_int_stb(func2_read_int_vol(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_47.sql
SELECT * FROM func1_sql_int_stb(func2_read_int_stb(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_48.sql
begin;
SELECT * FROM func1_sql_int_stb(func2_mod_int_vol(5)) order by 1;
func1_sql_int_stb
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_49.sql
begin;
SELECT * FROM func1_sql_int_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_50.sql
SELECT * FROM func1_sql_int_imm(func2_nosql_vol(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_51.sql
SELECT * FROM func1_sql_int_imm(func2_nosql_stb(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_52.sql
SELECT * FROM func1_sql_int_imm(func2_nosql_imm(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_53.sql
SELECT * FROM func1_sql_int_imm(func2_sql_int_vol(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_54.sql
SELECT * FROM func1_sql_int_imm(func2_sql_int_stb(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_55.sql
SELECT * FROM func1_sql_int_imm(func2_sql_int_imm(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_56.sql
SELECT * FROM func1_sql_int_imm(func2_read_int_vol(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_57.sql
SELECT * FROM func1_sql_int_imm(func2_read_int_stb(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
-- @description function_in_from_withfunc2_58.sql
begin;
SELECT * FROM func1_sql_int_imm(func2_mod_int_vol(5)) order by 1;
func1_sql_int_imm
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_59.sql
begin;
SELECT * FROM func1_sql_int_imm(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_60.sql
SELECT * FROM func1_sql_setint_vol(func2_nosql_vol(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_61.sql
SELECT * FROM func1_sql_setint_vol(func2_nosql_stb(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_62.sql
SELECT * FROM func1_sql_setint_vol(func2_nosql_imm(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_63.sql
SELECT * FROM func1_sql_setint_vol(func2_sql_int_vol(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_64.sql
SELECT * FROM func1_sql_setint_vol(func2_sql_int_stb(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_65.sql
SELECT * FROM func1_sql_setint_vol(func2_sql_int_imm(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_66.sql
SELECT * FROM func1_sql_setint_vol(func2_read_int_vol(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_67.sql
SELECT * FROM func1_sql_setint_vol(func2_read_int_stb(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_68.sql
begin;
SELECT * FROM func1_sql_setint_vol(func2_mod_int_vol(5)) order by 1;
func1_sql_setint_vol
----------------------
6
7
8
9
10
11
(6 rows)
rollback;
-- @description function_in_from_withfunc2_69.sql
begin;
SELECT * FROM func1_sql_setint_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_70.sql
SELECT * FROM func1_sql_setint_stb(func2_nosql_vol(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_71.sql
SELECT * FROM func1_sql_setint_stb(func2_nosql_stb(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_72.sql
SELECT * FROM func1_sql_setint_stb(func2_nosql_imm(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_73.sql
SELECT * FROM func1_sql_setint_stb(func2_sql_int_vol(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_74.sql
SELECT * FROM func1_sql_setint_stb(func2_sql_int_stb(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_75.sql
SELECT * FROM func1_sql_setint_stb(func2_sql_int_imm(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_76.sql
SELECT * FROM func1_sql_setint_stb(func2_read_int_vol(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_77.sql
SELECT * FROM func1_sql_setint_stb(func2_read_int_stb(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_78.sql
begin;
SELECT * FROM func1_sql_setint_stb(func2_mod_int_vol(5)) order by 1;
func1_sql_setint_stb
----------------------
6
7
8
9
10
11
(6 rows)
rollback;
-- @description function_in_from_withfunc2_79.sql
begin;
SELECT * FROM func1_sql_setint_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_80.sql
SELECT * FROM func1_sql_setint_imm(func2_nosql_vol(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_81.sql
SELECT * FROM func1_sql_setint_imm(func2_nosql_stb(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_82.sql
SELECT * FROM func1_sql_setint_imm(func2_nosql_imm(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_83.sql
SELECT * FROM func1_sql_setint_imm(func2_sql_int_vol(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_84.sql
SELECT * FROM func1_sql_setint_imm(func2_sql_int_stb(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_85.sql
SELECT * FROM func1_sql_setint_imm(func2_sql_int_imm(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_86.sql
SELECT * FROM func1_sql_setint_imm(func2_read_int_vol(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_87.sql
SELECT * FROM func1_sql_setint_imm(func2_read_int_stb(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
-- @description function_in_from_withfunc2_88.sql
begin;
SELECT * FROM func1_sql_setint_imm(func2_mod_int_vol(5)) order by 1;
func1_sql_setint_imm
----------------------
6
7
8
9
10
11
(6 rows)
rollback;
-- @description function_in_from_withfunc2_89.sql
begin;
SELECT * FROM func1_sql_setint_imm(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_90.sql
SELECT * FROM func1_read_int_sql_vol(func2_nosql_vol(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_91.sql
SELECT * FROM func1_read_int_sql_vol(func2_nosql_stb(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_92.sql
SELECT * FROM func1_read_int_sql_vol(func2_nosql_imm(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_93.sql
SELECT * FROM func1_read_int_sql_vol(func2_sql_int_vol(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_94.sql
SELECT * FROM func1_read_int_sql_vol(func2_sql_int_stb(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_95.sql
SELECT * FROM func1_read_int_sql_vol(func2_sql_int_imm(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_96.sql
SELECT * FROM func1_read_int_sql_vol(func2_read_int_vol(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_97.sql
SELECT * FROM func1_read_int_sql_vol(func2_read_int_stb(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_98.sql
begin;
SELECT * FROM func1_read_int_sql_vol(func2_mod_int_vol(5)) order by 1;
func1_read_int_sql_vol
------------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_99.sql
begin;
SELECT * FROM func1_read_int_sql_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_100.sql
SELECT * FROM func1_read_int_sql_stb(func2_nosql_vol(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_101.sql
SELECT * FROM func1_read_int_sql_stb(func2_nosql_stb(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_102.sql
SELECT * FROM func1_read_int_sql_stb(func2_nosql_imm(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_103.sql
SELECT * FROM func1_read_int_sql_stb(func2_sql_int_vol(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_104.sql
SELECT * FROM func1_read_int_sql_stb(func2_sql_int_stb(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_105.sql
SELECT * FROM func1_read_int_sql_stb(func2_sql_int_imm(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_106.sql
SELECT * FROM func1_read_int_sql_stb(func2_read_int_vol(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_107.sql
SELECT * FROM func1_read_int_sql_stb(func2_read_int_stb(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
-- @description function_in_from_withfunc2_108.sql
begin;
SELECT * FROM func1_read_int_sql_stb(func2_mod_int_vol(5)) order by 1;
func1_read_int_sql_stb
------------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_109.sql
begin;
SELECT * FROM func1_read_int_sql_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_110.sql
SELECT * FROM func1_read_setint_sql_vol(func2_nosql_vol(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_111.sql
SELECT * FROM func1_read_setint_sql_vol(func2_nosql_stb(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_112.sql
SELECT * FROM func1_read_setint_sql_vol(func2_nosql_imm(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_113.sql
SELECT * FROM func1_read_setint_sql_vol(func2_sql_int_vol(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_114.sql
SELECT * FROM func1_read_setint_sql_vol(func2_sql_int_stb(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_115.sql
SELECT * FROM func1_read_setint_sql_vol(func2_sql_int_imm(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_116.sql
SELECT * FROM func1_read_setint_sql_vol(func2_read_int_vol(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_117.sql
SELECT * FROM func1_read_setint_sql_vol(func2_read_int_stb(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_118.sql
begin;
SELECT * FROM func1_read_setint_sql_vol(func2_mod_int_vol(5)) order by 1;
func1_read_setint_sql_vol
---------------------------
2
3
4
5
7
8
9
10
11
(9 rows)
rollback;
-- @description function_in_from_withfunc2_119.sql
begin;
SELECT * FROM func1_read_setint_sql_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_120.sql
SELECT * FROM func1_read_setint_sql_stb(func2_nosql_vol(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_121.sql
SELECT * FROM func1_read_setint_sql_stb(func2_nosql_stb(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_122.sql
SELECT * FROM func1_read_setint_sql_stb(func2_nosql_imm(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_123.sql
SELECT * FROM func1_read_setint_sql_stb(func2_sql_int_vol(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_124.sql
SELECT * FROM func1_read_setint_sql_stb(func2_sql_int_stb(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_125.sql
SELECT * FROM func1_read_setint_sql_stb(func2_sql_int_imm(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_126.sql
SELECT * FROM func1_read_setint_sql_stb(func2_read_int_vol(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_127.sql
SELECT * FROM func1_read_setint_sql_stb(func2_read_int_stb(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
6
8
9
10
11
(9 rows)
-- @description function_in_from_withfunc2_128.sql
begin;
SELECT * FROM func1_read_setint_sql_stb(func2_mod_int_vol(5)) order by 1;
func1_read_setint_sql_stb
---------------------------
2
3
4
5
7
8
9
10
11
(9 rows)
rollback;
-- @description function_in_from_withfunc2_129.sql
begin;
SELECT * FROM func1_read_setint_sql_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_130.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_nosql_vol(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_131.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_nosql_stb(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_132.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_nosql_imm(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_133.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_sql_int_vol(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_134.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_sql_int_stb(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_135.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_sql_int_imm(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_136.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_read_int_vol(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_137.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_read_int_stb(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_138.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_mod_int_vol(5)) order by 1;
func1_mod_int_vol
-------------------
7
(1 row)
rollback;
-- @description function_in_from_withfunc2_139.sql
begin;
SELECT * FROM func1_mod_int_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_140.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_nosql_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_141.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_nosql_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_142.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_nosql_imm(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_143.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_sql_int_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_144.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_sql_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_145.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_sql_int_imm(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_146.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_read_int_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_147.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_read_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_148.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_mod_int_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func1_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_149.sql
begin;
SELECT * FROM func1_mod_int_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_150.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_nosql_vol(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_151.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_nosql_stb(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_152.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_nosql_imm(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_153.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_sql_int_vol(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_154.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_sql_int_stb(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_155.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_sql_int_imm(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_156.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_read_int_vol(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_157.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_read_int_stb(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_158.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_mod_int_vol(5)) order by 1;
func1_mod_setint_vol
----------------------
9
10
11
12
(4 rows)
rollback;
-- @description function_in_from_withfunc2_159.sql
begin;
SELECT * FROM func1_mod_setint_vol(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;
-- @description function_in_from_withfunc2_160.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_nosql_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_161.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_nosql_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_162.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_nosql_imm(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_163.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_sql_int_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_164.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_sql_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_165.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_sql_int_imm(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_166.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_read_int_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_167.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_read_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_168.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_mod_int_vol(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1"
PL/pgSQL function func1_mod_setint_stb(integer) line 5 at SQL statement
rollback;
-- @description function_in_from_withfunc2_169.sql
begin;
SELECT * FROM func1_mod_setint_stb(func2_mod_int_stb(5)) order by 1;
ERROR: UPDATE is not allowed in a non-volatile function
CONTEXT: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1"
PL/pgSQL function func2_mod_int_stb(integer) line 3 at SQL statement
rollback;