Debian Codegraph @

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

raw
1 CREATE TABLE t1 (
2 t1_int INT,
3 t1_time TIME
4 ) ENGINE=innodb;
5 CREATE TABLE t2 (
6 t2_int int PRIMARY KEY,
7 t2_int2 INT
8 ) ENGINE=INNODB;
9 INSERT IGNORE INTO t2 VALUES ();
10 Warnings:
11 Warning 1364 Field 't2_int' doesn't have a default value
12 INSERT INTO t1 VALUES ();
13 SELECT *
14 FROM t1 AS t1a
15 WHERE NOT EXISTS
16 (SELECT *
17 FROM t1 AS t1b
18 WHERE t1b.t1_int NOT IN
19 (SELECT t2.t2_int
20 FROM t2
21 WHERE t1b.t1_time LIKE t1b.t1_int
22 OR t1b.t1_time <> t2.t2_int2
23 AND 6=7
24 )
25 )
26 ;
27 t1_int t1_time
28 DROP TABLE t1,t2;