1CREATE TABLE t1 ( 2event_date date DEFAULT '0000-00-00' NOT NULL, 3type int(11) DEFAULT '0' NOT NULL, 4event_id int(11) DEFAULT '0' NOT NULL, 5PRIMARY KEY (event_date,type,event_id) 6); 7INSERT INTO t1 VALUES ('1999-07-10',100100,24), ('1999-07-11',100100,25), 8('1999-07-13',100600,0), ('1999-07-13',100600,4), ('1999-07-13',100600,26), 9('1999-07-14',100600,10), ('1999-07-15',100600,16), ('1999-07-15',100800,45), 10('1999-07-15',101000,47), ('1999-07-16',100800,46), ('1999-07-20',100600,5), 11('1999-07-20',100600,27), ('1999-07-21',100600,11), ('1999-07-22',100600,17), 12('1999-07-23',100100,39), ('1999-07-24',100100,39), ('1999-07-24',100500,40), 13('1999-07-25',100100,39), ('1999-07-27',100600,1), ('1999-07-27',100600,6), 14('1999-07-27',100600,28), ('1999-07-28',100600,12), ('1999-07-29',100500,41), 15('1999-07-29',100600,18), ('1999-07-30',100500,41), ('1999-07-31',100500,41), 16('1999-08-01',100700,34), ('1999-08-03',100600,7), ('1999-08-03',100600,29), 17('1999-08-04',100600,13), ('1999-08-05',100500,42), ('1999-08-05',100600,19), 18('1999-08-06',100500,42), ('1999-08-07',100500,42), ('1999-08-08',100500,42), 19('1999-08-10',100600,2), ('1999-08-10',100600,9), ('1999-08-10',100600,30), 20('1999-08-11',100600,14), ('1999-08-12',100600,20), ('1999-08-17',100500,8), 21('1999-08-17',100600,31), ('1999-08-18',100600,15), ('1999-08-19',100600,22), 22('1999-08-24',100600,3), ('1999-08-24',100600,32), ('1999-08-27',100500,43), 23('1999-08-31',100600,33), ('1999-09-17',100100,37), ('1999-09-18',100100,37), 24('1999-09-19',100100,37), ('2000-12-18',100700,38); 25connect killee, localhost, root; 26set debug_sync='inside_make_join_statistics signal killme wait_for done'; 27select event_date,type,event_id from t1 WHERE event_date >= "1999-07-01" AND event_date < "1999-07-15" AND (type=100600 OR type=100100) ORDER BY event_date; 28connection default; 29set debug_sync='now wait_for killme'; 30kill %connection%; 31set debug_sync='now signal done'; 32connection killee; 33Got one of the listed errors 34connection default; 35disconnect killee; 36drop table t1; 37set debug_sync='reset'; 38