Debian Codegraph @

mysql-test/suite/innodb/r/temptable_write_row.result

raw
1 SET DEBUG='d';
2 CREATE TABLE t1 (a INT(10) UNSIGNED NOT NULL PRIMARY KEY,b INT(10) UNSIGNED);
3 Warnings:
4 Warning 1681 Integer display width is deprecated and will be removed in a future release.
5 Warning 1681 Integer display width is deprecated and will be removed in a future release.
6 INSERT INTO t1 VALUES (1,1),(2,1),(3,1),(4,1);
7 CREATE TABLE t2 (a INT(10) UNSIGNED, KEY(A), b text);
8 Warnings:
9 Warning 1681 Integer display width is deprecated and will be removed in a future release.
10 INSERT INTO t2 VALUES (1,'1'),(2,'2');
11 INSERT INTO t2 VALUES (1,'1'),(2,'2'),(1,'1'),(2,'2');
12 SELECT DISTINCT 1 FROM t1,t2 WHERE t1.a=t2.a;
13 1
14 1
15 DROP TABLE t1;
16 DROP TABLE t2;