diff options
Diffstat (limited to 'src/test/regress/input')
| -rw-r--r-- | src/test/regress/input/create_function_1.source | 12 | ||||
| -rw-r--r-- | src/test/regress/input/create_function_2.source | 13 | ||||
| -rw-r--r-- | src/test/regress/input/misc.source | 13 |
3 files changed, 28 insertions, 10 deletions
diff --git a/src/test/regress/input/create_function_1.source b/src/test/regress/input/create_function_1.source index 0f82a3bea4..6d91674cd5 100644 --- a/src/test/regress/input/create_function_1.source +++ b/src/test/regress/input/create_function_1.source @@ -15,30 +15,30 @@ CREATE FUNCTION widget_out(opaque) CREATE FUNCTION check_primary_key () RETURNS opaque AS '@abs_builddir@/../../../contrib/spi/refint@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION check_foreign_key () RETURNS opaque AS '@abs_builddir@/../../../contrib/spi/refint@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION autoinc () RETURNS opaque AS '@abs_builddir@/../../../contrib/spi/autoinc@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION funny_dup17 () RETURNS opaque AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION ttdummy () RETURNS opaque AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION set_ttdummy (int4) RETURNS int4 AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; diff --git a/src/test/regress/input/create_function_2.source b/src/test/regress/input/create_function_2.source index af6695764a..b1c0eab138 100644 --- a/src/test/regress/input/create_function_2.source +++ b/src/test/regress/input/create_function_2.source @@ -30,28 +30,33 @@ CREATE FUNCTION user_relns() CREATE FUNCTION pt_in_widget(point, widget) RETURNS bool AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION overpaid(emp) RETURNS bool AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION boxarea(box) RETURNS float8 AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION interpt_pp(path, path) RETURNS point AS '@abs_builddir@/regress@DLSUFFIX@' - LANGUAGE 'newC'; + LANGUAGE 'C'; CREATE FUNCTION reverse_name(name) RETURNS name AS '@abs_builddir@/regress@DLSUFFIX@' LANGUAGE 'c'; +CREATE FUNCTION oldstyle_length(int4, text) + RETURNS int4 + AS '@abs_builddir@/regress@DLSUFFIX@' + LANGUAGE 'c'; + -- -- Function dynamic loading -- diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source index 9e9ebdb75b..dbb8df8470 100644 --- a/src/test/regress/input/misc.source +++ b/src/test/regress/input/misc.source @@ -216,6 +216,19 @@ SELECT user_relns() AS user_relns -- +-- check that old-style C functions work properly with TOASTed values +-- +create table oldstyle_test(i int4, t text); +insert into oldstyle_test values(null,null); +insert into oldstyle_test values(0,'12'); +insert into oldstyle_test values(1000,'12'); +insert into oldstyle_test values(0, repeat('x', 50000)); + +select i, length(t), octet_length(t), oldstyle_length(i,t) from oldstyle_test; + +drop table oldstyle_test; + +-- -- functional joins -- |
