1--source include/have_debug.inc 2--source include/have_debug_sync.inc 3--source include/count_sessions.inc 4 5--disable_warnings 6drop table if exists t0,t1,t2; 7--enable_warnings 8 9create table t0(a int primary key); 10insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 11 12create table t1(a int primary key); 13insert into t1 select A.a + B.a* 10 + C.a * 100 from t0 A, t0 B, t0 C; 14 15create table t2 ( 16 kp1 int, 17 kp2 int, 18 col char(100), 19 key(kp1, kp2) 20); 21insert into t2 select a, a, a from t1; 22 23select engine from information_schema.tables 24where table_schema=database() and table_name='t2'; 25 26explain 27select * from t2 where kp1 between 10 and 20 and kp2 +1 >100; 28 29let $target_id= `select connection_id()`; 30 31set debug_sync='handler_index_cond_check SIGNAL at_icp_check WAIT_FOR go'; 32send 33select * from t2 where kp1 between 10 and 20 and kp2 +1 >100; 34 35connect (con1, localhost, root,,); 36connection con1; 37set debug_sync='now WAIT_FOR at_icp_check'; 38evalp kill query $target_id; 39set debug_sync='now SIGNAL go'; 40 41connection default; 42 43--error ER_QUERY_INTERRUPTED 44reap; 45set debug_sync='RESET'; 46 47disconnect con1; 48drop table t0,t1,t2; 49--source include/wait_until_count_sessions.inc 50 51