Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_corr.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 * FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2 WHERE t2.c2 =
12 t1.c2);
13 c1 c2
14 2 abcde
15 DROP TABLE t1;
16 DROP TABLE t2;
17 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100));
18 INSERT INTO t1 VALUES (null,null);
19 INSERT INTO t1 VALUES (1,'');
20 INSERT INTO t1 VALUES (2,'abcde');
21 INSERT INTO t1 VALUES (100,'abcdefghij');
22 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
23 INSERT INTO t2 VALUES (1,'abcde');
24 INSERT INTO t2 VALUES (2,'abcde');
25 SELECT * FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2 WHERE t2.c2 =
26 t1.c2);
27 c1 c2
28 2 abcde
29 DROP TABLE t1;
30 DROP TABLE t2;
31 CREATE TABLE t1 (c1 INT, c2 BINARY(100));
32 INSERT INTO t1 VALUES (null,null);
33 INSERT INTO t1 VALUES (1,'');
34 INSERT INTO t1 VALUES (2,'abcde');
35 INSERT INTO t1 VALUES (100,'abcdefghij');
36 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
37 INSERT INTO t2 VALUES (1,'abcde');
38 INSERT INTO t2 VALUES (2,'abcde');
39 SELECT * FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2 WHERE t2.c2 =
40 t1.c2);
41 c1 c2
42 DROP TABLE t1;
43 DROP TABLE t2;
44 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100));
45 INSERT INTO t1 VALUES (null,null);
46 INSERT INTO t1 VALUES (1,'');
47 INSERT INTO t1 VALUES (2,'abcde');
48 INSERT INTO t1 VALUES (100,'abcdefghij');
49 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
50 INSERT INTO t2 VALUES (1,'abcde');
51 INSERT INTO t2 VALUES (2,'abcde');
52 SELECT * FROM t1 WHERE c1 = ANY (SELECT c1 FROM t2 WHERE t2.c2 =
53 t1.c2);
54 c1 c2
55 2 abcde
56 DROP TABLE t1;
57 DROP TABLE t2;