Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_exists.result

raw
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, c2 VARCHAR(100));
9 INSERT INTO t2 VALUES (1,'abcde');
10 INSERT INTO t2 VALUES (2,'abcde');
11 SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
12 c1
13 NULL
14 1
15 2
16 100
17 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
18 c1
19 SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
20 c1
21 2
22 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
23 t2.c2);
24 c1
25 NULL
26 1
27 100
28 DROP TABLE t1;
29 DROP TABLE t2;
30 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
31 INSERT INTO t1 VALUES (null,null);
32 INSERT INTO t1 VALUES (1,'');
33 INSERT INTO t1 VALUES (2,'abcde');
34 INSERT INTO t1 VALUES (100,'abcdefghij');
35 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
36 INSERT INTO t2 VALUES (1,'abcde');
37 INSERT INTO t2 VALUES (2,'abcde');
38 SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
39 c1
40 NULL
41 1
42 2
43 100
44 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
45 c1
46 SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
47 c1
48 2
49 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
50 t2.c2);
51 c1
52 NULL
53 1
54 100
55 DROP TABLE t1;
56 DROP TABLE t2;
57 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
58 INSERT INTO t1 VALUES (null,null);
59 INSERT INTO t1 VALUES (1,'');
60 INSERT INTO t1 VALUES (2,'abcde');
61 INSERT INTO t1 VALUES (100,'abcdefghij');
62 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
63 INSERT INTO t2 VALUES (1,'abcde');
64 INSERT INTO t2 VALUES (2,'abcde');
65 SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
66 c1
67 NULL
68 1
69 2
70 100
71 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
72 c1
73 SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
74 c1
75 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
76 t2.c2);
77 c1
78 NULL
79 1
80 2
81 100
82 DROP TABLE t1;
83 DROP TABLE t2;
84 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
85 INSERT INTO t1 VALUES (null,null);
86 INSERT INTO t1 VALUES (1,'');
87 INSERT INTO t1 VALUES (2,'abcde');
88 INSERT INTO t1 VALUES (100,'abcdefghij');
89 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
90 INSERT INTO t2 VALUES (1,'abcde');
91 INSERT INTO t2 VALUES (2,'abcde');
92 SELECT c1 FROM t1 WHERE EXISTS (SELECT 1);
93 c1
94 NULL
95 1
96 2
97 100
98 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT 1);
99 c1
100 SELECT c1 FROM t1 WHERE EXISTS (SELECT * FROM t2 WHERE t1.c2 = t2.c2);
101 c1
102 2
103 SELECT c1 FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.c2 =
104 t2.c2);
105 c1
106 NULL
107 1
108 100
109 DROP TABLE t1;
110 DROP TABLE t2;