1--disable_warnings
2DROP TABLE IF EXISTS t1;
3--enable_warnings
4--disable_warnings
5DROP TABLE IF EXISTS t2;
6--enable_warnings
7CREATE TABLE t1 (c1 INT, c2 CHAR(100));
8INSERT INTO t1 VALUES (null,null);
9INSERT INTO t1 VALUES (1,'');
10INSERT INTO t1 VALUES (2,'abcde');
11INSERT INTO t1 VALUES (100,'abcdefghij');
12CREATE TABLE t2 (c1 INT);
13INSERT INTO t2 VALUES (null);
14INSERT INTO t2 VALUES (2);
15INSERT INTO t2 VALUES (100);
16SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
17SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
18SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
19SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
20SELECT c1 FROM t1 WHERE c1 <> ANY  (SELECT c1 FROM t2);
21DROP TABLE t1;
22DROP TABLE t2;
23CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
24INSERT INTO t1 VALUES (null,null);
25INSERT INTO t1 VALUES (1,'');
26INSERT INTO t1 VALUES (2,'abcde');
27INSERT INTO t1 VALUES (100,'abcdefghij');
28CREATE TABLE t2 (c1 INT);
29INSERT INTO t2 VALUES (null);
30INSERT INTO t2 VALUES (2);
31INSERT INTO t2 VALUES (100);
32SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
33SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
34SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
35SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
36SELECT c1 FROM t1 WHERE c1 <> ANY  (SELECT c1 FROM t2);
37DROP TABLE t1;
38DROP TABLE t2;
39CREATE TABLE t1 (c1 INT, c2 BINARY(100));
40INSERT INTO t1 VALUES (null,null);
41INSERT INTO t1 VALUES (1,'');
42INSERT INTO t1 VALUES (2,'abcde');
43INSERT INTO t1 VALUES (100,'abcdefghij');
44CREATE TABLE t2 (c1 INT);
45INSERT INTO t2 VALUES (null);
46INSERT INTO t2 VALUES (2);
47INSERT INTO t2 VALUES (100);
48SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
49SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
50SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
51SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
52SELECT c1 FROM t1 WHERE c1 <> ANY  (SELECT c1 FROM t2);
53DROP TABLE t1;
54DROP TABLE t2;
55CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
56INSERT INTO t1 VALUES (null,null);
57INSERT INTO t1 VALUES (1,'');
58INSERT INTO t1 VALUES (2,'abcde');
59INSERT INTO t1 VALUES (100,'abcdefghij');
60CREATE TABLE t2 (c1 INT);
61INSERT INTO t2 VALUES (null);
62INSERT INTO t2 VALUES (2);
63INSERT INTO t2 VALUES (100);
64SELECT c1 FROM t1 WHERE c1 > ANY (SELECT c1 FROM t2);
65SELECT c1 FROM t1 WHERE c1 >= ANY (SELECT c1 FROM t2);
66SELECT c1 FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2);
67SELECT c1 FROM t1 WHERE c1 <= ANY (SELECT c1 FROM t2);
68SELECT c1 FROM t1 WHERE c1 <> ANY  (SELECT c1 FROM t2);
69DROP TABLE t1;
70DROP TABLE t2;
71
72