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