diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/oid.out | 13 | ||||
| -rw-r--r-- | src/test/regress/sql/oid.sql | 2 |
2 files changed, 4 insertions, 11 deletions
diff --git a/src/test/regress/expected/oid.out b/src/test/regress/expected/oid.out index ce43b92bbf5..570a4c77b36 100644 --- a/src/test/regress/expected/oid.out +++ b/src/test/regress/expected/oid.out @@ -7,7 +7,6 @@ INSERT INTO OID_TBL(f1) VALUES ('1235'); INSERT INTO OID_TBL(f1) VALUES ('987'); INSERT INTO OID_TBL(f1) VALUES ('-1040'); INSERT INTO OID_TBL(f1) VALUES ('99999999'); -INSERT INTO OID_TBL(f1) VALUES (''); -- bad inputs INSERT INTO OID_TBL(f1) VALUES ('asdfasd'); ERROR: invalid input syntax for type oid: "asdfasd" @@ -21,8 +20,7 @@ SELECT '' AS six, OID_TBL.*; | 987 | 4294966256 | 99999999 - | 0 -(6 rows) +(5 rows) SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; one | f1 @@ -37,23 +35,20 @@ SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; | 987 | 4294966256 | 99999999 - | 0 -(5 rows) +(4 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; three | f1 -------+------ | 1234 | 987 - | 0 -(3 rows) +(2 rows) SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 < '1234'; two | f1 -----+----- | 987 - | 0 -(2 rows) +(1 row) SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; four | f1 diff --git a/src/test/regress/sql/oid.sql b/src/test/regress/sql/oid.sql index 17bfd01942d..a19f8fe998f 100644 --- a/src/test/regress/sql/oid.sql +++ b/src/test/regress/sql/oid.sql @@ -14,8 +14,6 @@ INSERT INTO OID_TBL(f1) VALUES ('-1040'); INSERT INTO OID_TBL(f1) VALUES ('99999999'); -INSERT INTO OID_TBL(f1) VALUES (''); - -- bad inputs INSERT INTO OID_TBL(f1) VALUES ('asdfasd'); |