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