diff options
| -rw-r--r-- | src/test/regress/input/misc.source | 13 | ||||
| -rw-r--r-- | src/test/regress/output/misc.source | 18 |
2 files changed, 0 insertions, 31 deletions
diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source index c46223bedf..c0f1634198 100644 --- a/src/test/regress/input/misc.source +++ b/src/test/regress/input/misc.source @@ -253,19 +253,6 @@ SELECT class, aa, a FROM a_star* ORDER BY 1,2; -- SELECT *, (equipment(CAST((h.*) AS hobbies_r))).name FROM hobbies_r h ORDER BY 1,2,3; -- --- 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 ORDER BY 1,2,3; - -drop table oldstyle_test; - --- -- functional joins -- diff --git a/src/test/regress/output/misc.source b/src/test/regress/output/misc.source index da98fa561d..71aaa06979 100644 --- a/src/test/regress/output/misc.source +++ b/src/test/regress/output/misc.source @@ -538,24 +538,6 @@ SELECT class, aa, a FROM a_star* ORDER BY 1,2; -- -- SELECT *, (equipment(CAST((h.*) AS hobbies_r))).name FROM hobbies_r h ORDER BY 1,2,3; -- --- 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 ORDER BY 1,2,3; - i | length | octet_length | oldstyle_length -------+--------+--------------+----------------- - 0 | 2 | 2 | 2 - 0 | 50000 | 50000 | 50000 - 1000 | 2 | 2 | 1002 - | | | -(4 rows) - -drop table oldstyle_test; --- -- functional joins -- -- |