create schema db_func_4;
set current_schema to 'db_func_4';
CREATE FUNCTION f1 (s CHAR(20)) RETURNS int SQL SECURITY DEFINER AS $$ select 1 $$ ;
CREATE FUNCTION f2 (s int) RETURNS int NO SQL SQL SECURITY DEFINER AS $$ select s; $$ ;
CREATE FUNCTION f3 (s int) RETURNS int SQL SECURITY INVOKER READS SQL DATA LANGUAGE SQL AS $$ select s; $$ ;
CREATE FUNCTION f4 (s int) RETURNS int SQL SECURITY INVOKER CONTAINS SQL LANGUAGE SQL AS $$ select s; $$ ;
call f1(1);
ERROR: Only support procedure in muiti result call statement
call f2(2);
ERROR: Only support procedure in muiti result call statement
call f3(3);
ERROR: Only support procedure in muiti result call statement
call f4(4);
ERROR: Only support procedure in muiti result call statement
drop schema db_func_4 cascade;
NOTICE: drop cascades to 4 other objects
DETAIL: drop cascades to function f1(character)
drop cascades to function f2(integer)
drop cascades to function f3(integer)
drop cascades to function f4(integer)
reset current_schema;