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