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