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');