diff options
Diffstat (limited to 'src/test/regress/input/misc.source')
| -rw-r--r-- | src/test/regress/input/misc.source | 63 |
1 files changed, 0 insertions, 63 deletions
diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source index 74d2d84bc6..8151ff3a5a 100644 --- a/src/test/regress/input/misc.source +++ b/src/test/regress/input/misc.source @@ -80,19 +80,6 @@ SELECT * FROM stud_emp; -- --- test the random function --- --- count the number of tuples originally -SELECT count(*) FROM onek; - --- select roughly 1/10 of the tuples -SELECT count(*) FROM onek where oidrand(onek.oid, 10); - --- select again, the count should be different -SELECT count(*) FROM onek where oidrand(onek.oid, 10); - - --- -- inheritance stress test -- SELECT * FROM a_star*; @@ -228,53 +215,3 @@ SELECT user_relns() AS user_relns -- -- rewrite rules -- - --- --- ARRAYS --- -SELECT * FROM arrtest; - -SELECT arrtest.a[1], - arrtest.b[1][1][1], - arrtest.c[1], - arrtest.d[1][1], - arrtest.e[0] - FROM arrtest; --- ??? what about --- SELECT a[1], b[1][1][1], c[1], d[1][1], e[0] --- FROM arrtest; - -SELECT arrtest.a[1:3], - arrtest.b[1:1][1:2][1:2], - arrtest.c[1:2], - arrtest.d[1:1][1:2] - FROM arrtest; - --- returns three different results-- -SELECT array_dims(arrtest.b) AS x; - --- returns nothing -SELECT * - FROM arrtest - WHERE arrtest.a[1] < 5 and - arrtest.c = '{"foobar"}'::_char16; - --- updating array subranges seems to be broken --- --- UPDATE arrtest --- SET a[1:2] = '{16,25}', --- b[1:1][1:1][1:2] = '{113, 117}', --- c[1:1] = '{"new_word"}'; - -SELECT arrtest.a[1:3], - arrtest.b[1:1][1:2][1:2], - arrtest.c[1:2], - arrtest.d[1:1][1:2] - FROM arrtest; - - --- --- expensive functions --- - - |
