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, c2 VARCHAR(100)); 13INSERT INTO t2 VALUES (1,'abcde'); 14INSERT INTO t2 VALUES (2,'abcde'); 15SELECT c1 FROM t1 WHERE EXISTS (SELECT 1); 16SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1); 17SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2); 18SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 = 19t2.c2); 20DROP TABLE t1; 21DROP TABLE t2; 22CREATE TABLE t1 (c1 INT, c2 VARCHAR(100)); 23INSERT INTO t1 VALUES (null,null); 24INSERT INTO t1 VALUES (1,''); 25INSERT INTO t1 VALUES (2,'abcde'); 26INSERT INTO t1 VALUES (100,'abcdefghij'); 27CREATE TABLE t2 (c1 INT, c2 VARCHAR(100)); 28INSERT INTO t2 VALUES (1,'abcde'); 29INSERT INTO t2 VALUES (2,'abcde'); 30SELECT c1 FROM t1 WHERE EXISTS (SELECT 1); 31SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1); 32SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2); 33SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 = 34t2.c2); 35DROP TABLE t1; 36DROP TABLE t2; 37CREATE TABLE t1 (c1 INT, c2 BINARY(100)); 38INSERT INTO t1 VALUES (null,null); 39INSERT INTO t1 VALUES (1,''); 40INSERT INTO t1 VALUES (2,'abcde'); 41INSERT INTO t1 VALUES (100,'abcdefghij'); 42CREATE TABLE t2 (c1 INT, c2 VARCHAR(100)); 43INSERT INTO t2 VALUES (1,'abcde'); 44INSERT INTO t2 VALUES (2,'abcde'); 45SELECT c1 FROM t1 WHERE EXISTS (SELECT 1); 46SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1); 47SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2); 48SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 = 49t2.c2); 50DROP TABLE t1; 51DROP TABLE t2; 52CREATE TABLE t1 (c1 INT, c2 VARBINARY(100)); 53INSERT INTO t1 VALUES (null,null); 54INSERT INTO t1 VALUES (1,''); 55INSERT INTO t1 VALUES (2,'abcde'); 56INSERT INTO t1 VALUES (100,'abcdefghij'); 57CREATE TABLE t2 (c1 INT, c2 VARCHAR(100)); 58INSERT INTO t2 VALUES (1,'abcde'); 59INSERT INTO t2 VALUES (2,'abcde'); 60SELECT c1 FROM t1 WHERE EXISTS (SELECT 1); 61SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1); 62SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2); 63SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 = 64t2.c2); 65DROP TABLE t1; 66DROP TABLE t2; 67 68