1-- 2-- OID 3-- 4 5CREATE TABLE OID_TBL(f1 oid); 6 7INSERT INTO OID_TBL(f1) VALUES ('1234'); 8INSERT INTO OID_TBL(f1) VALUES ('1235'); 9INSERT INTO OID_TBL(f1) VALUES ('987'); 10INSERT INTO OID_TBL(f1) VALUES ('-1040'); 11INSERT INTO OID_TBL(f1) VALUES ('99999999'); 12INSERT INTO OID_TBL(f1) VALUES ('5 '); 13INSERT INTO OID_TBL(f1) VALUES (' 10 '); 14-- leading/trailing hard tab is also allowed 15INSERT INTO OID_TBL(f1) VALUES (' 15 '); 16 17-- bad inputs 18INSERT INTO OID_TBL(f1) VALUES (''); 19INSERT INTO OID_TBL(f1) VALUES (' '); 20INSERT INTO OID_TBL(f1) VALUES ('asdfasd'); 21INSERT INTO OID_TBL(f1) VALUES ('99asdfasd'); 22INSERT INTO OID_TBL(f1) VALUES ('5 d'); 23INSERT INTO OID_TBL(f1) VALUES (' 5d'); 24INSERT INTO OID_TBL(f1) VALUES ('5 5'); 25INSERT INTO OID_TBL(f1) VALUES (' - 500'); 26INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935'); 27INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385'); 28 29SELECT '' AS six, * FROM OID_TBL; 30 31SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; 32 33SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; 34 35SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; 36 37SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 < '1234'; 38 39SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; 40 41SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234'; 42 43DROP TABLE OID_TBL; 44