diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/oidjoins.out | 16 | ||||
| -rw-r--r-- | src/test/regress/expected/opr_sanity.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/oidjoins.sql | 8 |
3 files changed, 14 insertions, 14 deletions
diff --git a/src/test/regress/expected/oidjoins.out b/src/test/regress/expected/oidjoins.out index 46bc60f6955..95c24879857 100644 --- a/src/test/regress/expected/oidjoins.out +++ b/src/test/regress/expected/oidjoins.out @@ -57,14 +57,6 @@ WHERE pg_am.aminsert != 0 AND -----+---------- (0 rows) -SELECT oid, pg_am.amdelete -FROM pg_am -WHERE pg_am.amdelete != 0 AND - NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amdelete); - oid | amdelete ------+---------- -(0 rows) - SELECT oid, pg_am.ambeginscan FROM pg_am WHERE pg_am.ambeginscan != 0 AND @@ -113,6 +105,14 @@ WHERE pg_am.ambuild != 0 AND -----+--------- (0 rows) +SELECT oid, pg_am.ambulkdelete +FROM pg_am +WHERE pg_am.ambulkdelete != 0 AND + NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.ambulkdelete); + oid | ambulkdelete +-----+-------------- +(0 rows) + SELECT oid, pg_am.amcostestimate FROM pg_am WHERE pg_am.amcostestimate != 0 AND diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out index 41328c53b1d..533655c52ea 100644 --- a/src/test/regress/expected/opr_sanity.out +++ b/src/test/regress/expected/opr_sanity.out @@ -480,8 +480,8 @@ WHERE p1.aggtransfn = p2.oid AND (p2.pronargs = 1 AND p1.aggbasetype = 0))); oid | aggname | oid | proname -------+---------+-----+------------- - 16963 | max | 768 | int4larger - 16977 | min | 769 | int4smaller + 16959 | max | 768 | int4larger + 16973 | min | 769 | int4smaller (2 rows) -- Cross-check finalfn (if present) against its entry in pg_proc. diff --git a/src/test/regress/sql/oidjoins.sql b/src/test/regress/sql/oidjoins.sql index 88727a6c76e..34352128f44 100644 --- a/src/test/regress/sql/oidjoins.sql +++ b/src/test/regress/sql/oidjoins.sql @@ -29,10 +29,6 @@ SELECT oid, pg_am.aminsert FROM pg_am WHERE pg_am.aminsert != 0 AND NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.aminsert); -SELECT oid, pg_am.amdelete -FROM pg_am -WHERE pg_am.amdelete != 0 AND - NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amdelete); SELECT oid, pg_am.ambeginscan FROM pg_am WHERE pg_am.ambeginscan != 0 AND @@ -57,6 +53,10 @@ SELECT oid, pg_am.ambuild FROM pg_am WHERE pg_am.ambuild != 0 AND NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.ambuild); +SELECT oid, pg_am.ambulkdelete +FROM pg_am +WHERE pg_am.ambulkdelete != 0 AND + NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.ambulkdelete); SELECT oid, pg_am.amcostestimate FROM pg_am WHERE pg_am.amcostestimate != 0 AND |
