1-- source include/have_innodb.inc
2# Bug #59307 uninitialized value in rw_lock_set_writer_id_and_recursion_flag()
3# when Valgrind instrumentation (UNIV_DEBUG_VALGRIND) is not enabled
4
5CREATE TABLE t1 (
6  t1_int INT,
7  t1_time TIME
8) ENGINE=innodb;
9
10CREATE TABLE t2 (
11  t2_int int PRIMARY KEY,
12  t2_int2 INT
13) ENGINE=INNODB;
14
15INSERT IGNORE INTO t2 VALUES ();
16INSERT INTO t1 VALUES ();
17
18SELECT *
19FROM t1 AS t1a
20WHERE NOT EXISTS
21  (SELECT *
22   FROM t1 AS t1b
23   WHERE t1b.t1_int NOT IN
24     (SELECT t2.t2_int
25      FROM t2
26      WHERE t1b.t1_time LIKE t1b.t1_int
27      OR t1b.t1_time <> t2.t2_int2
28      AND 6=7
29 )
30)
31;
32DROP TABLE t1,t2;
33