diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-09-30 17:37:32 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-09-30 17:37:32 +0000 |
| commit | 40ed132ce7a006ec8c54d5c97738563c1d7d05f3 (patch) | |
| tree | 7e2cf95adb6c86983c446f7fc01269eb8b2509f8 | |
| parent | 650c1750421213d16842072d63c49b50bf7e98a6 (diff) | |
| download | postgresql-40ed132ce7a006ec8c54d5c97738563c1d7d05f3.tar.gz postgresql-40ed132ce7a006ec8c54d5c97738563c1d7d05f3.zip | |
Addition of xid=int4 operator makes opr_sanity unhappy.
| -rw-r--r-- | src/test/regress/expected/opr_sanity.out | 9 | ||||
| -rw-r--r-- | src/test/regress/sql/opr_sanity.sql | 6 |
2 files changed, 8 insertions, 7 deletions
diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out index f42b0ffcbad..be08da82371 100644 --- a/src/test/regress/expected/opr_sanity.out +++ b/src/test/regress/expected/opr_sanity.out @@ -337,9 +337,9 @@ WHERE p1.oprlsortop != p1.oprrsortop AND -- Hashing only works on simple equality operators "type = sametype", -- since the hash itself depends on the bitwise representation of the type. -- Check that allegedly hashable operators look like they might be "=". --- NOTE: in 6.5, this search finds int4eqoid and oideqint4. Until we have --- some cleaner way of dealing with binary-equivalent types, just leave --- those two tuples in the expected output. +-- NOTE: in 7.2, this search finds int4eqoid, oideqint4, and xideqint4. +-- Until we have some cleaner way of dealing with binary-equivalent types, +-- just leave those three tuples in the expected output. SELECT p1.oid, p1.oprname FROM pg_operator AS p1 WHERE p1.oprcanhash AND NOT @@ -347,9 +347,10 @@ WHERE p1.oprcanhash AND NOT p1.oprname = '=' AND p1.oprcom = p1.oid); oid | oprname ------+--------- + 353 | = 1136 | = 1137 | = -(2 rows) +(3 rows) -- In 6.5 we accepted hashable array equality operators when the array element -- type is hashable. However, what we actually need to make hashjoin work on diff --git a/src/test/regress/sql/opr_sanity.sql b/src/test/regress/sql/opr_sanity.sql index c07d89ee0fa..7a5991a74a1 100644 --- a/src/test/regress/sql/opr_sanity.sql +++ b/src/test/regress/sql/opr_sanity.sql @@ -275,9 +275,9 @@ WHERE p1.oprlsortop != p1.oprrsortop AND -- Hashing only works on simple equality operators "type = sametype", -- since the hash itself depends on the bitwise representation of the type. -- Check that allegedly hashable operators look like they might be "=". --- NOTE: in 6.5, this search finds int4eqoid and oideqint4. Until we have --- some cleaner way of dealing with binary-equivalent types, just leave --- those two tuples in the expected output. +-- NOTE: in 7.2, this search finds int4eqoid, oideqint4, and xideqint4. +-- Until we have some cleaner way of dealing with binary-equivalent types, +-- just leave those three tuples in the expected output. SELECT p1.oid, p1.oprname FROM pg_operator AS p1 |