-- start_ignore create schema functionProperty_501_600; set search_path to functionProperty_501_600; DROP TABLE foo; ERROR: table "foo" does not exist DROP TABLE bar; ERROR: table "bar" does not exist DROP FUNCTION func1_nosql_imm(x int) ; ERROR: function func1_nosql_imm(integer) does not exist DROP FUNCTION func1_sql_int_imm(x int) ; ERROR: function func1_sql_int_imm(integer) does not exist DROP FUNCTION func1_sql_setint_imm(x int) ; ERROR: function func1_sql_setint_imm(integer) does not exist DROP FUNCTION func1_read_int_sql_imm(x int) ; ERROR: function func1_read_int_sql_imm(integer) does not exist DROP FUNCTION func1_read_setint_sql_imm(x int) ; ERROR: function func1_read_setint_sql_imm(integer) does not exist DROP FUNCTION func1_mod_int_imm(x int) ; ERROR: function func1_mod_int_imm(integer) does not exist DROP FUNCTION func1_mod_setint_imm(x int) ; ERROR: function func1_mod_setint_imm(integer) does not exist DROP FUNCTION func1_nosql_stb(x int) ; ERROR: function func1_nosql_stb(integer) does not exist DROP FUNCTION func1_sql_int_stb(x int) ; ERROR: function func1_sql_int_stb(integer) does not exist DROP FUNCTION func1_sql_setint_stb(x int) ; ERROR: function func1_sql_setint_stb(integer) does not exist DROP FUNCTION func1_read_int_sql_stb(x int) ; ERROR: function func1_read_int_sql_stb(integer) does not exist DROP FUNCTION func1_read_setint_sql_stb(x int) ; ERROR: function func1_read_setint_sql_stb(integer) does not exist DROP FUNCTION func1_mod_int_stb(x int) ; ERROR: function func1_mod_int_stb(integer) does not exist DROP FUNCTION func1_mod_setint_stb(x int) ; ERROR: function func1_mod_setint_stb(integer) does not exist DROP FUNCTION func1_nosql_vol(x int) ; ERROR: function func1_nosql_vol(integer) does not exist DROP FUNCTION func1_sql_int_vol(x int) ; ERROR: function func1_sql_int_vol(integer) does not exist DROP FUNCTION func1_sql_setint_vol(x int) ; ERROR: function func1_sql_setint_vol(integer) does not exist DROP FUNCTION func1_read_int_sql_vol(x int) ; ERROR: function func1_read_int_sql_vol(integer) does not exist DROP FUNCTION func1_read_setint_sql_vol(x int) ; ERROR: function func1_read_setint_sql_vol(integer) does not exist DROP FUNCTION func1_mod_int_vol(x int) ; ERROR: function func1_mod_int_vol(integer) does not exist DROP FUNCTION func1_mod_setint_vol(x int) ; ERROR: function func1_mod_setint_vol(integer) does not exist DROP FUNCTION func2_nosql_imm(x int) ; ERROR: function func2_nosql_imm(integer) does not exist DROP FUNCTION func2_sql_int_imm(x int) ; ERROR: function func2_sql_int_imm(integer) does not exist DROP FUNCTION func2_read_int_imm(x int) ; ERROR: function func2_read_int_imm(integer) does not exist DROP FUNCTION func2_mod_int_imm(x int) ; ERROR: function func2_mod_int_imm(integer) does not exist DROP FUNCTION func2_nosql_stb(x int) ; ERROR: function func2_nosql_stb(integer) does not exist DROP FUNCTION func2_sql_int_stb(x int) ; ERROR: function func2_sql_int_stb(integer) does not exist DROP FUNCTION func2_read_int_stb(x int) ; ERROR: function func2_read_int_stb(integer) does not exist DROP FUNCTION func2_mod_int_stb(x int) ; ERROR: function func2_mod_int_stb(integer) does not exist DROP FUNCTION func2_nosql_vol(x int) ; ERROR: function func2_nosql_vol(integer) does not exist DROP FUNCTION func2_sql_int_vol(x int) ; ERROR: function func2_sql_int_vol(integer) does not exist DROP FUNCTION func2_read_int_vol(x int) ; ERROR: function func2_read_int_vol(integer) does not exist DROP FUNCTION func2_mod_int_vol(x int) ; ERROR: function func2_mod_int_vol(integer) does not exist CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- func1 IMMUTABLE CREATE FUNCTION func1_nosql_imm(x int) RETURNS int AS $$ BEGIN RETURN $1 +1; END $$ LANGUAGE plpgsql NO SQL IMMUTABLE; CREATE FUNCTION func1_sql_int_imm(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT $1 + 1 INTO r; return r; END $$ LANGUAGE plpgsql CONTAINS SQL IMMUTABLE; CREATE FUNCTION func1_sql_setint_imm(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN FOR r in SELECT generate_series($1, $1+5) LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql CONTAINS SQL IMMUTABLE; --CREATE FUNCTION func1_read_int_sql_imm(x int) RETURNS int AS $$ --DECLARE -- r int; --BEGIN -- SELECT d FROM bar WHERE c = $1 LIMIT 1 INTO r; -- return r; --END --$$ LANGUAGE plpgsql IMMUTABLE READS SQL DATA; -- --CREATE FUNCTION func1_read_setint_sql_imm(x int) RETURNS setof int AS $$ --DECLARE -- r int; --BEGIN -- FOR r in SELECT d FROM bar WHERE c <> $1 -- LOOP -- RETURN NEXT r; -- END LOOP; -- RETURN; --END --$$ LANGUAGE plpgsql IMMUTABLE READS SQL DATA; -- --CREATE FUNCTION func1_mod_int_imm(x int) RETURNS int AS $$ --BEGIN --UPDATE bar SET d = d+1 WHERE c = $1; --RETURN $1 + 1; --END --$$ LANGUAGE plpgsql IMMUTABLE MODIFIES SQL DATA; -- --CREATE FUNCTION func1_mod_setint_imm(x int) RETURNS setof int AS $$ --DECLARE -- r int; --BEGIN -- UPDATE bar SET d = d+1 WHERE c > $1; -- FOR r in SELECT d FROM bar WHERE c > $1 -- LOOP -- RETURN NEXT r; -- END LOOP; -- RETURN; --END --$$ LANGUAGE plpgsql MODIFIES SQL DATA IMMUTABLE; -- ----func2 IMMUTABLE CREATE FUNCTION func2_nosql_imm(x int) RETURNS int AS $$ BEGIN RETURN $1 + 1; END $$ LANGUAGE plpgsql NO SQL IMMUTABLE; CREATE FUNCTION func2_sql_int_imm(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT $1 + 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql CONTAINS SQL IMMUTABLE; -- --CREATE FUNCTION func2_read_int_imm(x int) RETURNS int AS $$ --DECLARE -- r int; --BEGIN -- SELECT d FROM bar WHERE c = $1 LIMIT 1 INTO r; -- RETURN r; --END --$$ LANGUAGE plpgsql IMMUTABLE READS SQL DATA; -- --CREATE FUNCTION func2_mod_int_imm(x int) RETURNS int AS $$ --BEGIN --UPDATE bar SET d = d+1 WHERE c = $1; --RETURN $1 + 1; --END --$$ LANGUAGE plpgsql IMMUTABLE MODIFIES SQL DATA; -- func1 STABLE CREATE FUNCTION func1_nosql_stb(x int) RETURNS int AS $$ BEGIN RETURN $1 +1; END $$ LANGUAGE plpgsql STABLE NO SQL; CREATE FUNCTION func1_sql_int_stb(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT $1 + 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql STABLE CONTAINS SQL; CREATE FUNCTION func1_sql_setint_stb(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN FOR r in SELECT generate_series($1, $1+5) LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql STABLE CONTAINS SQL; CREATE FUNCTION func1_read_int_sql_stb(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT d FROM bar WHERE c = $1 LIMIT 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql STABLE READS SQL DATA; CREATE FUNCTION func1_read_setint_sql_stb(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN FOR r in SELECT d FROM bar WHERE c <> $1 LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql STABLE READS SQL DATA; CREATE FUNCTION func1_mod_int_stb(x int) RETURNS int AS $$ BEGIN UPDATE bar SET d = d+1 WHERE c = $1; RETURN $1 + 1; END $$ LANGUAGE plpgsql STABLE MODIFIES SQL DATA; CREATE FUNCTION func1_mod_setint_stb(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN UPDATE bar SET d = d+1 WHERE c > $1; FOR r in SELECT d FROM bar WHERE c > $1 LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql STABLE MODIFIES SQL DATA; --func2 STABLE CREATE FUNCTION func2_nosql_stb(x int) RETURNS int AS $$ BEGIN RETURN $1 + 1; END $$ LANGUAGE plpgsql STABLE NO SQL; CREATE FUNCTION func2_sql_int_stb(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT $1 + 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql STABLE CONTAINS SQL; CREATE FUNCTION func2_read_int_stb(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT d FROM bar WHERE c = $1 LIMIT 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql STABLE READS SQL DATA; CREATE FUNCTION func2_mod_int_stb(x int) RETURNS int AS $$ BEGIN UPDATE bar SET d = d+1 WHERE c = $1; RETURN $1 + 1; END $$ LANGUAGE plpgsql STABLE MODIFIES SQL DATA; -- func1 VOLATILE CREATE FUNCTION func1_nosql_vol(x int) RETURNS int AS $$ BEGIN RETURN $1 +1; END $$ LANGUAGE plpgsql VOLATILE NO SQL; CREATE FUNCTION func1_sql_int_vol(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT $1 + 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql VOLATILE CONTAINS SQL; CREATE FUNCTION func1_sql_setint_vol(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN FOR r in SELECT generate_series($1, $1+5) LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql VOLATILE CONTAINS SQL; CREATE FUNCTION func1_read_int_sql_vol(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT d FROM bar WHERE c = $1 LIMIT 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql VOLATILE READS SQL DATA; CREATE FUNCTION func1_read_setint_sql_vol(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN FOR r in SELECT d FROM bar WHERE c <> $1 LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql VOLATILE READS SQL DATA; CREATE FUNCTION func1_mod_int_vol(x int) RETURNS int AS $$ BEGIN UPDATE bar SET d = d+1 WHERE c = $1; RETURN $1 + 1; END $$ LANGUAGE plpgsql VOLATILE MODIFIES SQL DATA; CREATE FUNCTION func1_mod_setint_vol(x int) RETURNS setof int AS $$ DECLARE r int; BEGIN UPDATE bar SET d = d+1 WHERE c > $1; FOR r in SELECT d FROM bar WHERE c > $1 LOOP RETURN NEXT r; END LOOP; RETURN; END $$ LANGUAGE plpgsql VOLATILE MODIFIES SQL DATA; --func2 VOLATILE CREATE FUNCTION func2_nosql_vol(x int) RETURNS int AS $$ BEGIN RETURN $1 + 1; END $$ LANGUAGE plpgsql VOLATILE NO SQL; CREATE FUNCTION func2_sql_int_vol(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT $1 + 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql VOLATILE CONTAINS SQL; CREATE FUNCTION func2_read_int_vol(x int) RETURNS int AS $$ DECLARE r int; BEGIN SELECT d FROM bar WHERE c = $1 LIMIT 1 INTO r; RETURN r; END $$ LANGUAGE plpgsql VOLATILE READS SQL DATA; CREATE FUNCTION func2_mod_int_vol(x int) RETURNS int AS $$ BEGIN UPDATE bar SET d = d+1 WHERE c = $1; RETURN $1 + 1; END $$ LANGUAGE plpgsql VOLATILE MODIFIES SQL DATA; -- end_ignore -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_88.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties 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) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_89.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties 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" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_9.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties 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" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_90.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_nosql_vol(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_91.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_nosql_stb(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_92.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_nosql_imm(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_93.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_sql_int_vol(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_94.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_sql_int_stb(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_95.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_sql_int_imm(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_96.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_read_int_vol(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_97.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_read_int_stb(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_98.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT * FROM func1_read_int_sql_vol(func2_mod_int_vol(5)) order by 1; func1_read_int_sql_vol ------------------------ 7 (1 row) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_from_withfunc2_99.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties 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" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_0.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_vol(a) FROM foo order by 1; func1_nosql_vol ----------------- 2 3 4 5 6 7 8 9 10 11 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_1.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(a) FROM foo order by 1; func1_nosql_stb ----------------- 2 3 4 5 6 7 8 9 10 11 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_10.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(a) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_11.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(a) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_12.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(a) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_13.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(a) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_14.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(a) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_15.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(a) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_16.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_stb(a) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_2.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_imm(a) FROM foo order by 1; func1_nosql_imm ----------------- 2 3 4 5 6 7 8 9 10 11 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_3.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_sql_int_vol(a) FROM foo order by 1; func1_sql_int_vol ------------------- 2 3 4 5 6 7 8 9 10 11 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_4.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_sql_int_stb(a) FROM foo order by 1; func1_sql_int_stb ------------------- 2 3 4 5 6 7 8 9 10 11 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_5.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_sql_int_imm(a) FROM foo order by 1; func1_sql_int_imm ------------------- 2 3 4 5 6 7 8 9 10 11 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_6.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_sql_setint_vol(a) FROM foo order by 1; func1_sql_setint_vol ---------------------- 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 9 9 9 10 10 10 10 10 10 11 11 11 11 11 12 12 12 12 13 13 13 14 14 15 (60 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_7.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_sql_setint_stb(a) FROM foo order by 1; func1_sql_setint_stb ---------------------- 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 9 9 9 10 10 10 10 10 10 11 11 11 11 11 12 12 12 12 13 13 13 14 14 15 (60 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_8.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_sql_setint_imm(a) FROM foo order by 1; func1_sql_setint_imm ---------------------- 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 9 9 9 10 10 10 10 10 10 11 11 11 11 11 12 12 12 12 13 13 13 14 14 15 (60 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_9.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_vol(a) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_0.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_vol(func2_nosql_vol(a)) FROM foo order by 1; func1_nosql_vol ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_1.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_vol(func2_nosql_stb(a)) FROM foo order by 1; func1_nosql_vol ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_10.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_nosql_vol(a)) FROM foo order by 1; func1_nosql_stb ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_100.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_101.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_nosql_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_102.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_nosql_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_103.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_sql_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_104.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_sql_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_105.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_sql_int_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func1_read_int_sql_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_106.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_107.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_read_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_108.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_mod_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_109.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_int_sql_stb(func2_mod_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_11.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_nosql_stb(a)) FROM foo order by 1; func1_nosql_stb ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_110.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_111.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_nosql_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_112.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_nosql_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_113.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_sql_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_114.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_sql_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_115.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_sql_int_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_vol" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_116.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_117.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_read_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_118.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_mod_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_119.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_vol(func2_mod_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_12.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_nosql_imm(a)) FROM foo order by 1; func1_nosql_stb ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_120.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_121.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_nosql_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_122.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_nosql_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_123.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_sql_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_124.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_sql_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_125.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_sql_int_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement " SELECT d FROM bar WHERE c <> $1 " PL/pgSQL function "func1_read_setint_sql_stb" line 4 at for over select rows -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_126.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_127.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_read_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_128.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_mod_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_129.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_read_setint_sql_stb(func2_mod_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_13.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_sql_int_vol(a)) FROM foo order by 1; func1_nosql_stb ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_130.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_131.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_nosql_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_132.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_nosql_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_133.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_sql_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_134.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_sql_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_135.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_sql_int_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_136.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_137.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_read_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_138.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_mod_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_139.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_vol(func2_mod_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_14.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_sql_int_stb(a)) FROM foo order by 1; func1_nosql_stb ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_140.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_141.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_nosql_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_142.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_nosql_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_143.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_sql_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_144.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_sql_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_145.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_sql_int_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func1_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_146.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_147.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_read_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_148.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_mod_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_149.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_int_stb(func2_mod_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_15.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_sql_int_imm(a)) FROM foo order by 1; func1_nosql_stb ----------------- 3 4 5 6 7 8 9 10 11 12 (10 rows) -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_150.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_151.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_nosql_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_152.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_nosql_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_153.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_sql_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_154.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_sql_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_155.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_sql_int_imm(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_156.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_157.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_read_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_stb" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_158.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_mod_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg0 slice1 hyuan-mac:25432 pid=37383) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_159.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_vol(func2_mod_int_stb(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg2 slice1 hyuan-mac:25434 pid=37385) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c = $1 " PL/pgSQL function "func2_mod_int_stb" line 2 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @description function_in_select_column_withfunc2_16.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_nosql_stb(func2_read_int_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it accesses relation "functionproperty_501_600.bar" (functions.c:155) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "SELECT d FROM bar WHERE c = $1 LIMIT 1" PL/pgSQL function "func2_read_int_vol" line 4 at SQL statement -- start_ignore DROP TABLE foo; DROP TABLE bar; CREATE TABLE foo (a int, b int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO foo select i, i+1 from generate_series(1,10) i; CREATE TABLE bar (c int, d int); NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c' as the Greenplum Database data distribution key for this table. HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. INSERT INTO bar select i, i+1 from generate_series(1,10) i; -- end_ignore -- @executemode ORCA_PLANNER_DIFF -- @description function_in_select_column_withfunc2_160.sql -- @db_name functionproperty -- @author tungs1 -- @modified 2013-04-03 12:00:00 -- @created 2013-04-03 12:00:00 -- @tags functionProperties SELECT func1_mod_setint_stb(func2_nosql_vol(a)) FROM foo order by 1; ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg1 slice1 hyuan-mac:25433 pid=37384) DETAIL: SQL statement "UPDATE bar SET d = d+1 WHERE c > $1 " PL/pgSQL function "func1_mod_setint_stb" line 4 at SQL statement -- start_ignore drop schema functionProperty_501_600 cascade; NOTICE: drop cascades to table bar NOTICE: drop cascades to table foo NOTICE: drop cascades to function func2_mod_int_vol(integer) NOTICE: drop cascades to function func2_read_int_vol(integer) NOTICE: drop cascades to function func2_sql_int_vol(integer) NOTICE: drop cascades to function func2_nosql_vol(integer) NOTICE: drop cascades to function func1_mod_setint_vol(integer) NOTICE: drop cascades to function func1_mod_int_vol(integer) NOTICE: drop cascades to function func1_read_setint_sql_vol(integer) NOTICE: drop cascades to function func1_read_int_sql_vol(integer) NOTICE: drop cascades to function func1_sql_setint_vol(integer) NOTICE: drop cascades to function func1_sql_int_vol(integer) NOTICE: drop cascades to function func1_nosql_vol(integer) NOTICE: drop cascades to function func2_mod_int_stb(integer) NOTICE: drop cascades to function func2_read_int_stb(integer) NOTICE: drop cascades to function func2_sql_int_stb(integer) NOTICE: drop cascades to function func2_nosql_stb(integer) NOTICE: drop cascades to function func1_mod_setint_stb(integer) NOTICE: drop cascades to function func1_mod_int_stb(integer) NOTICE: drop cascades to function func1_read_setint_sql_stb(integer) NOTICE: drop cascades to function func1_read_int_sql_stb(integer) NOTICE: drop cascades to function func1_sql_setint_stb(integer) NOTICE: drop cascades to function func1_sql_int_stb(integer) NOTICE: drop cascades to function func1_nosql_stb(integer) NOTICE: drop cascades to function func2_sql_int_imm(integer) NOTICE: drop cascades to function func2_nosql_imm(integer) NOTICE: drop cascades to function func1_sql_setint_imm(integer) NOTICE: drop cascades to function func1_sql_int_imm(integer) NOTICE: drop cascades to function func1_nosql_imm(integer) -- end_ignore