Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_in.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);
9 INSERT INTO t2 VALUES (null);
10 INSERT INTO t2 VALUES (2);
11 INSERT INTO t2 VALUES (100);
12 SELECT c1 FROM t1 WHERE c1 IN (SELECT c1 FROM t2);
13 c1
14 2
15 100
16 SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2);
17 c1
18 DROP TABLE t1;
19 DROP TABLE t2;
20 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
21 INSERT INTO t1 VALUES (null,null);
22 INSERT INTO t1 VALUES (1,'');
23 INSERT INTO t1 VALUES (2,'abcde');
24 INSERT INTO t1 VALUES (100,'abcdefghij');
25 CREATE TABLE t2 (c1 INT);
26 INSERT INTO t2 VALUES (null);
27 INSERT INTO t2 VALUES (2);
28 INSERT INTO t2 VALUES (100);
29 SELECT c1 FROM t1 WHERE c1 IN (SELECT c1 FROM t2);
30 c1
31 2
32 100
33 SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2);
34 c1
35 DROP TABLE t1;
36 DROP TABLE t2;
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);
43 INSERT INTO t2 VALUES (null);
44 INSERT INTO t2 VALUES (2);
45 INSERT INTO t2 VALUES (100);
46 SELECT c1 FROM t1 WHERE c1 IN (SELECT c1 FROM t2);
47 c1
48 2
49 100
50 SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2);
51 c1
52 DROP TABLE t1;
53 DROP TABLE t2;
54 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
55 INSERT INTO t1 VALUES (null,null);
56 INSERT INTO t1 VALUES (1,'');
57 INSERT INTO t1 VALUES (2,'abcde');
58 INSERT INTO t1 VALUES (100,'abcdefghij');
59 CREATE TABLE t2 (c1 INT);
60 INSERT INTO t2 VALUES (null);
61 INSERT INTO t2 VALUES (2);
62 INSERT INTO t2 VALUES (100);
63 SELECT c1 FROM t1 WHERE c1 IN (SELECT c1 FROM t2);
64 c1
65 2
66 100
67 SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT c1 FROM t2);
68 c1
69 DROP TABLE t1;
70 DROP TABLE t2;