--
-- 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 ('');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
-- bad inputs
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: ""
-- bad inputs
^
INSERT INTO OID_TBL(f1) VALUES (' ');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES (' ');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: " "
INSERT INTO OID_TBL(f1) VALUES (' ');
^
INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: "asdfasd"
INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
^
INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: "99asdfasd"
INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
^
INSERT INTO OID_TBL(f1) VALUES ('5 d');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES ('5 d');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: "5 d"
INSERT INTO OID_TBL(f1) VALUES ('5 d');
^
INSERT INTO OID_TBL(f1) VALUES (' 5d');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES (' 5d');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: " 5d"
INSERT INTO OID_TBL(f1) VALUES (' 5d');
^
INSERT INTO OID_TBL(f1) VALUES ('5 5');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES ('5 5');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: "5 5"
INSERT INTO OID_TBL(f1) VALUES ('5 5');
^
INSERT INTO OID_TBL(f1) VALUES (' - 500');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES (' - 500');
^
-stdin-::1:1: Fatal: ERROR: invalid input syntax for type oid: " - 500"
INSERT INTO OID_TBL(f1) VALUES (' - 500');
^
INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
^
-stdin-::1:1: Fatal: ERROR: value "32958209582039852935" is out of range for type oid
INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
^
INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
^
-stdin-::1:1: Fatal: ERROR: value "-23582358720398502385" is out of range for type oid
INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
^
SELECT * FROM OID_TBL;
SELECT o.* FROM OID_TBL o WHERE o.f1 = 1234;
SELECT o.* FROM OID_TBL o WHERE o.f1 <> '1234';
SELECT o.* FROM OID_TBL o WHERE o.f1 <= '1234';
SELECT o.* FROM OID_TBL o WHERE o.f1 < '1234';
SELECT o.* FROM OID_TBL o WHERE o.f1 >= '1234';
SELECT o.* FROM OID_TBL o WHERE o.f1 > '1234';
DROP TABLE OID_TBL;