diff options
Diffstat (limited to '')
| -rw-r--r-- | src/test/regress/sql/oid.sql | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/src/test/regress/sql/oid.sql b/src/test/regress/sql/oid.sql new file mode 100644 index 0000000..4a09689 --- /dev/null +++ b/src/test/regress/sql/oid.sql @@ -0,0 +1,43 @@ +-- +-- OID +-- + +CREATE TABLE OID_TBL(f1 oid); + +INSERT INTO OID_TBL(f1) VALUES ('1234'); +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 ('5 '); +INSERT INTO OID_TBL(f1) VALUES (' 10 '); +-- leading/trailing hard tab is also allowed +INSERT INTO OID_TBL(f1) VALUES (' 15 '); + +-- bad inputs +INSERT INTO OID_TBL(f1) VALUES (''); +INSERT INTO OID_TBL(f1) VALUES (' '); +INSERT INTO OID_TBL(f1) VALUES ('asdfasd'); +INSERT INTO OID_TBL(f1) VALUES ('99asdfasd'); +INSERT INTO OID_TBL(f1) VALUES ('5 d'); +INSERT INTO OID_TBL(f1) VALUES (' 5d'); +INSERT INTO OID_TBL(f1) VALUES ('5 5'); +INSERT INTO OID_TBL(f1) VALUES (' - 500'); +INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935'); +INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385'); + +SELECT '' AS six, * FROM OID_TBL; + +SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; + +SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; + +SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; + +SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 < '1234'; + +SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; + +SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234'; + +DROP TABLE OID_TBL; |