This is an automated email from the ASF dual-hosted git repository.
chenjinbao1989 pushed a commit to branch cbdb-postgres-merge
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/cbdb-postgres-merge by this
push:
new c533d09c808 Remove create_function_x.source
c533d09c808 is described below
commit c533d09c808b320baf5734732c9ecbc308df58eb
Author: Jinbao Chen <[email protected]>
AuthorDate: Thu Dec 18 21:58:57 2025 +0800
Remove create_function_x.source
---
src/test/regress/input/create_function_0.source | 100 -----------------------
src/test/regress/input/create_function_2.source | 90 --------------------
src/test/regress/output/create_function_0.source | 91 ---------------------
src/test/regress/output/create_function_2.source | 71 ----------------
4 files changed, 352 deletions(-)
diff --git a/src/test/regress/input/create_function_0.source
b/src/test/regress/input/create_function_0.source
deleted file mode 100644
index 54c76f9a8ed..00000000000
--- a/src/test/regress/input/create_function_0.source
+++ /dev/null
@@ -1,100 +0,0 @@
---
--- CREATE_FUNCTION_0
---
-
--- Create a bunch of C functions that will be used by later tests:
-
-CREATE FUNCTION check_primary_key ()
- RETURNS trigger
- AS '@libdir@/refint@DLSUFFIX@'
- LANGUAGE C;
-
-CREATE FUNCTION check_foreign_key ()
- RETURNS trigger
- AS '@libdir@/refint@DLSUFFIX@'
- LANGUAGE C;
-
-CREATE FUNCTION autoinc ()
- RETURNS trigger
- AS '@libdir@/autoinc@DLSUFFIX@'
- LANGUAGE C;
-
-CREATE FUNCTION trigger_return_old ()
- RETURNS trigger
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C;
-
-CREATE FUNCTION ttdummy ()
- RETURNS trigger
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C;
-
-CREATE FUNCTION set_ttdummy (int4)
- RETURNS int4
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION make_tuple_indirect (record)
- RETURNS record
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION test_atomic_ops()
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C;
-
-CREATE FUNCTION test_fdw_handler()
- RETURNS fdw_handler
- AS '@libdir@/regress@DLSUFFIX@', 'test_fdw_handler'
- LANGUAGE C;
-
-CREATE FUNCTION test_support_func(internal)
- RETURNS internal
- AS '@libdir@/regress@DLSUFFIX@', 'test_support_func'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION test_opclass_options_func(internal)
- RETURNS void
- AS '@libdir@/regress@DLSUFFIX@', 'test_opclass_options_func'
- LANGUAGE C;
-
-
-CREATE FUNCTION test_enc_setup() RETURNS void
- AS '@libdir@/regress@DLSUFFIX@', 'test_enc_setup'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION test_enc_conversion(bytea, name, name, bool, validlen OUT int,
result OUT bytea)
- AS '@libdir@/regress@DLSUFFIX@', 'test_enc_conversion'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION binary_coercible(oid, oid)
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@', 'binary_coercible'
- LANGUAGE C STRICT STABLE PARALLEL SAFE;
-
--- Things that shouldn't work:
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'SELECT ''not an integer'';';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'not even SQL';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'SELECT 1, 2, 3;';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'SELECT $2;';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'a', 'b';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE C
- AS 'nosuchfile';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE C
- AS '@libdir@/regress@DLSUFFIX@', 'nosuchsymbol';
-
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE internal
- AS 'nosuch';
diff --git a/src/test/regress/input/create_function_2.source
b/src/test/regress/input/create_function_2.source
deleted file mode 100644
index 34a201df080..00000000000
--- a/src/test/regress/input/create_function_2.source
+++ /dev/null
@@ -1,90 +0,0 @@
---
--- CREATE_FUNCTION_2
---
-CREATE FUNCTION hobbies(person)
- RETURNS setof hobbies_r
- AS 'select * from hobbies_r where person = $1.name'
- LANGUAGE SQL READS SQL DATA;
-
-
-CREATE FUNCTION hobby_construct(text, text)
- RETURNS hobbies_r
- AS 'select $1 as name, $2 as hobby'
- LANGUAGE SQL READS SQL DATA;
-
-
-CREATE FUNCTION hobby_construct_named(name text, hobby text)
- RETURNS hobbies_r
- AS 'select name, hobby'
- LANGUAGE SQL;
-
-
-CREATE FUNCTION hobbies_by_name(hobbies_r.name%TYPE)
- RETURNS hobbies_r.person%TYPE
- -- GPDB: use an order by to force the later test in 'misc' to return
- -- a particular person, when multiple persons have the same hobby.
- AS 'select person from hobbies_r where name = $1 order by person'
- LANGUAGE SQL READS SQL DATA;
-
-
-CREATE FUNCTION equipment(hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby = $1.name'
- LANGUAGE SQL READS SQL DATA;
-
-
-CREATE FUNCTION equipment_named(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where equipment_r.hobby =
equipment_named.hobby.name'
- LANGUAGE SQL;
-
-CREATE FUNCTION equipment_named_ambiguous_1a(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby =
equipment_named_ambiguous_1a.hobby.name'
- LANGUAGE SQL;
-
-CREATE FUNCTION equipment_named_ambiguous_1b(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where equipment_r.hobby = hobby.name'
- LANGUAGE SQL;
-
-CREATE FUNCTION equipment_named_ambiguous_1c(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby = hobby.name'
- LANGUAGE SQL;
-
-CREATE FUNCTION equipment_named_ambiguous_2a(hobby text)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby =
equipment_named_ambiguous_2a.hobby'
- LANGUAGE SQL;
-
-CREATE FUNCTION equipment_named_ambiguous_2b(hobby text)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where equipment_r.hobby = hobby'
- LANGUAGE SQL;
-
-
-CREATE FUNCTION pt_in_widget(point, widget)
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION overpaid(emp)
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION interpt_pp(path, path)
- RETURNS point
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION reverse_name(name)
- RETURNS name
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-
---
--- Function dynamic loading
---
-LOAD '@libdir@/regress@DLSUFFIX@';
diff --git a/src/test/regress/output/create_function_0.source
b/src/test/regress/output/create_function_0.source
deleted file mode 100644
index 7d3908967ac..00000000000
--- a/src/test/regress/output/create_function_0.source
+++ /dev/null
@@ -1,91 +0,0 @@
---
--- CREATE_FUNCTION_0
---
--- Create a bunch of C functions that will be used by later tests:
-CREATE FUNCTION check_primary_key ()
- RETURNS trigger
- AS '@libdir@/refint@DLSUFFIX@'
- LANGUAGE C;
-CREATE FUNCTION check_foreign_key ()
- RETURNS trigger
- AS '@libdir@/refint@DLSUFFIX@'
- LANGUAGE C;
-CREATE FUNCTION autoinc ()
- RETURNS trigger
- AS '@libdir@/autoinc@DLSUFFIX@'
- LANGUAGE C;
-CREATE FUNCTION trigger_return_old ()
- RETURNS trigger
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C;
-CREATE FUNCTION ttdummy ()
- RETURNS trigger
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C;
-CREATE FUNCTION set_ttdummy (int4)
- RETURNS int4
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-CREATE FUNCTION make_tuple_indirect (record)
- RETURNS record
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-CREATE FUNCTION test_atomic_ops()
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C;
-CREATE FUNCTION test_fdw_handler()
- RETURNS fdw_handler
- AS '@libdir@/regress@DLSUFFIX@', 'test_fdw_handler'
- LANGUAGE C;
-CREATE FUNCTION test_support_func(internal)
- RETURNS internal
- AS '@libdir@/regress@DLSUFFIX@', 'test_support_func'
- LANGUAGE C STRICT;
-CREATE FUNCTION test_opclass_options_func(internal)
- RETURNS void
- AS '@libdir@/regress@DLSUFFIX@', 'test_opclass_options_func'
- LANGUAGE C;
-CREATE FUNCTION test_enc_setup() RETURNS void
- AS '@libdir@/regress@DLSUFFIX@', 'test_enc_setup'
- LANGUAGE C STRICT;
-CREATE FUNCTION test_enc_conversion(bytea, name, name, bool, validlen OUT int,
result OUT bytea)
- AS '@libdir@/regress@DLSUFFIX@', 'test_enc_conversion'
- LANGUAGE C STRICT;
-CREATE FUNCTION binary_coercible(oid, oid)
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@', 'binary_coercible'
- LANGUAGE C STRICT STABLE PARALLEL SAFE;
--- Things that shouldn't work:
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'SELECT ''not an integer'';';
-ERROR: return type mismatch in function declared to return integer
-DETAIL: Actual return type is text.
-CONTEXT: SQL function "test1"
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'not even SQL';
-ERROR: syntax error at or near "not"
-LINE 2: AS 'not even SQL';
- ^
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'SELECT 1, 2, 3;';
-ERROR: return type mismatch in function declared to return integer
-DETAIL: Final statement must return exactly one column.
-CONTEXT: SQL function "test1"
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'SELECT $2;';
-ERROR: there is no parameter $2
-LINE 2: AS 'SELECT $2;';
- ^
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE SQL
- AS 'a', 'b';
-ERROR: only one AS item needed for language "sql"
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE C
- AS 'nosuchfile';
-ERROR: could not access file "nosuchfile": No such file or directory
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE C
- AS '@libdir@/regress@DLSUFFIX@', 'nosuchsymbol';
-ERROR: could not find function "nosuchsymbol" in file
"@libdir@/regress@DLSUFFIX@"
-CREATE FUNCTION test1 (int) RETURNS int LANGUAGE internal
- AS 'nosuch';
-ERROR: there is no built-in function named "nosuch"
diff --git a/src/test/regress/output/create_function_2.source
b/src/test/regress/output/create_function_2.source
deleted file mode 100644
index 87d909f7ca8..00000000000
--- a/src/test/regress/output/create_function_2.source
+++ /dev/null
@@ -1,71 +0,0 @@
---
--- CREATE_FUNCTION_2
---
-CREATE FUNCTION hobbies(person)
- RETURNS setof hobbies_r
- AS 'select * from hobbies_r where person = $1.name'
- LANGUAGE SQL READS SQL DATA;
-CREATE FUNCTION hobby_construct(text, text)
- RETURNS hobbies_r
- AS 'select $1 as name, $2 as hobby'
- LANGUAGE SQL READS SQL DATA;
-CREATE FUNCTION hobby_construct_named(name text, hobby text)
- RETURNS hobbies_r
- AS 'select name, hobby'
- LANGUAGE SQL;
-CREATE FUNCTION hobbies_by_name(hobbies_r.name%TYPE)
- RETURNS hobbies_r.person%TYPE
- -- GPDB: use an order by to force the later test in 'misc' to return
- -- a particular person, when multiple persons have the same hobby.
- AS 'select person from hobbies_r where name = $1 order by person'
- LANGUAGE SQL READS SQL DATA;
-NOTICE: type reference hobbies_r.name%TYPE converted to text
-NOTICE: type reference hobbies_r.person%TYPE converted to text
-CREATE FUNCTION equipment(hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby = $1.name'
- LANGUAGE SQL READS SQL DATA;
-CREATE FUNCTION equipment_named(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where equipment_r.hobby =
equipment_named.hobby.name'
- LANGUAGE SQL;
-CREATE FUNCTION equipment_named_ambiguous_1a(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby =
equipment_named_ambiguous_1a.hobby.name'
- LANGUAGE SQL;
-CREATE FUNCTION equipment_named_ambiguous_1b(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where equipment_r.hobby = hobby.name'
- LANGUAGE SQL;
-CREATE FUNCTION equipment_named_ambiguous_1c(hobby hobbies_r)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby = hobby.name'
- LANGUAGE SQL;
-CREATE FUNCTION equipment_named_ambiguous_2a(hobby text)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where hobby =
equipment_named_ambiguous_2a.hobby'
- LANGUAGE SQL;
-CREATE FUNCTION equipment_named_ambiguous_2b(hobby text)
- RETURNS setof equipment_r
- AS 'select * from equipment_r where equipment_r.hobby = hobby'
- LANGUAGE SQL;
-CREATE FUNCTION pt_in_widget(point, widget)
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-CREATE FUNCTION overpaid(emp)
- RETURNS bool
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-CREATE FUNCTION interpt_pp(path, path)
- RETURNS point
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
-CREATE FUNCTION reverse_name(name)
- RETURNS name
- AS '@libdir@/regress@DLSUFFIX@'
- LANGUAGE C STRICT;
---
--- Function dynamic loading
---
-LOAD '@libdir@/regress@DLSUFFIX@';
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
