Debian Codegraph @

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