From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- src/test/regress/sql/oid.sql | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 43 insertions(+) create mode 100644 src/test/regress/sql/oid.sql (limited to 'src/test/regress/sql/oid.sql') 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; -- cgit v1.2.3