1 DROP TABLE IF EXISTS t1;
2 DROP TABLE IF EXISTS t2;
3 CREATE TABLE t1 (c1 INT, c2 CHAR(100));
4 INSERT INTO t1 VALUES (null,null);
5 INSERT INTO t1 VALUES (1,'');
6 INSERT INTO t1 VALUES (2,'abcde');
7 INSERT INTO t1 VALUES (100,'abcdefghij');
8 CREATE TABLE t2 (c1 INT);
9 INSERT INTO t2 VALUES (null);
10 INSERT INTO t2 VALUES (2);
11 INSERT INTO t2 VALUES (100);
12 SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
15 SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
19 SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
23 SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
28 SELECT c1 FROM t1 WHERE c1 <> ANY (SELECT c1 FROM t2);
35 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
36 INSERT INTO t1 VALUES (null,null);
37 INSERT INTO t1 VALUES (1,'');
38 INSERT INTO t1 VALUES (2,'abcde');
39 INSERT INTO t1 VALUES (100,'abcdefghij');
40 CREATE TABLE t2 (c1 INT);
41 INSERT INTO t2 VALUES (null);
42 INSERT INTO t2 VALUES (2);
43 INSERT INTO t2 VALUES (100);
44 SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
47 SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
51 SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
55 SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
60 SELECT c1 FROM t1 WHERE c1 <> ANY (SELECT c1 FROM t2);
67 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
68 INSERT INTO t1 VALUES (null,null);
69 INSERT INTO t1 VALUES (1,'');
70 INSERT INTO t1 VALUES (2,'abcde');
71 INSERT INTO t1 VALUES (100,'abcdefghij');
72 CREATE TABLE t2 (c1 INT);
73 INSERT INTO t2 VALUES (null);
74 INSERT INTO t2 VALUES (2);
75 INSERT INTO t2 VALUES (100);
76 SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
79 SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
83 SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
87 SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
92 SELECT c1 FROM t1 WHERE c1 <> ANY (SELECT c1 FROM t2);
99 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
100 INSERT INTO t1 VALUES (null,null);
101 INSERT INTO t1 VALUES (1,'');
102 INSERT INTO t1 VALUES (2,'abcde');
103 INSERT INTO t1 VALUES (100,'abcdefghij');
104 CREATE TABLE t2 (c1 INT);
105 INSERT INTO t2 VALUES (null);
106 INSERT INTO t2 VALUES (2);
107 INSERT INTO t2 VALUES (100);
108 SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
111 SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
115 SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
119 SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
124 SELECT c1 FROM t1 WHERE c1 <> ANY (SELECT c1 FROM t2);