2
DROP TABLE IF EXISTS t1;
5
DROP TABLE IF EXISTS t2;
7
CREATE TABLE t1 (c1 INT, c2 CHAR(100));
8
INSERT INTO t1 VALUES (null,null);
9
INSERT INTO t1 VALUES (1,'');
10
INSERT INTO t1 VALUES (2,'abcde');
11
INSERT INTO t1 VALUES (100,'abcdefghij');
12
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
13
INSERT INTO t2 VALUES (1,'abcde');
14
INSERT INTO t2 VALUES (2,'abcde');
15
SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
16
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
17
SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
18
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
22
CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
23
INSERT INTO t1 VALUES (null,null);
24
INSERT INTO t1 VALUES (1,'');
25
INSERT INTO t1 VALUES (2,'abcde');
26
INSERT INTO t1 VALUES (100,'abcdefghij');
27
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
28
INSERT INTO t2 VALUES (1,'abcde');
29
INSERT INTO t2 VALUES (2,'abcde');
30
SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
31
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
32
SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
33
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
37
CREATE TABLE t1 (c1 INT, c2 BINARY(100));
38
INSERT INTO t1 VALUES (null,null);
39
INSERT INTO t1 VALUES (1,'');
40
INSERT INTO t1 VALUES (2,'abcde');
41
INSERT INTO t1 VALUES (100,'abcdefghij');
42
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
43
INSERT INTO t2 VALUES (1,'abcde');
44
INSERT INTO t2 VALUES (2,'abcde');
45
SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
46
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
47
SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
48
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
52
CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
53
INSERT INTO t1 VALUES (null,null);
54
INSERT INTO t1 VALUES (1,'');
55
INSERT INTO t1 VALUES (2,'abcde');
56
INSERT INTO t1 VALUES (100,'abcdefghij');
57
CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
58
INSERT INTO t2 VALUES (1,'abcde');
59
INSERT INTO t2 VALUES (2,'abcde');
60
SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
61
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
62
SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
63
SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =