1--echo #
2--echo # Bug#28039829: SELECT QUERY WITH COMPLEX JOINS LEAKS FILE HANDLES
3--echo #
4
5CREATE DATABASE db_28039829;
6USE db_28039829;
7
8CREATE TABLE t1 (c1 CHAR(36) NOT NULL,
9                 c2 CHAR(36) DEFAULT NULL,
10                 c3 VARCHAR(100) DEFAULT NULL,
11                 c4 VARCHAR(100) DEFAULT NULL,
12                 PRIMARY KEY (c1),
13                 KEY idx_1 (c2),
14                 KEY idx_2 (c3, c4),
15                 KEY idx_3 (c4, c3))
16                ENGINE=InnoDB;
17
18CREATE TABLE t2 (c1 CHAR(36) DEFAULT NULL)
19                ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21LOAD DATA INFILE '../../std_data/bug28039829.dat' INTO TABLE t1;
22INSERT INTO t2 VALUES ('63dfcd94-143a-11e7-bec8-fa163e4dd901'),
23                      ('dcda6718-143a-11e7-82e5-fa163e4dd901');
24
25SET optimizer_switch="block_nested_loop=OFF";
26
27SELECT t1.c1 FROM t1 INNER JOIN t2 ON t1.c2 = t2.c1
28             WHERE (t1.c3 LIKE 'James' OR t1.c4 LIKE 'abc');
29
30#Cleanup
31DROP TABLE t1, t2;
32DROP DATABASE db_28039829;
33SET optimizer_switch=DEFAULT;
34