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);
14 SELECT * FROM t1 WHERE ROW(1,2) = (SELECT c1, c2 FROM t2 WHERE c1=2);
16 SELECT * FROM t1 WHERE (c1,c2) = (2,'abcde');
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);
32 SELECT * FROM t1 WHERE ROW(1,2) = (SELECT c1, c2 FROM t2 WHERE c1=2);
34 SELECT * FROM t1 WHERE (c1,c2) = (2,'abcde');
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);
49 SELECT * FROM t1 WHERE ROW(1,2) = (SELECT c1, c2 FROM t2 WHERE c1=2);
51 SELECT * FROM t1 WHERE (c1,c2) = (2,'abcde');
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);
66 SELECT * FROM t1 WHERE ROW(1,2) = (SELECT c1, c2 FROM t2 WHERE c1=2);
68 SELECT * FROM t1 WHERE (c1,c2) = (2,'abcde');