|
1
by brian
clean slate |
1 |
set @old_concurrent_insert= @@global.concurrent_insert;
|
2 |
set @@global.concurrent_insert= 0;
|
|
3 |
drop table if exists t1;
|
|
4 |
create table t1 (kill_id int);
|
|
5 |
insert into t1 values(connection_id());
|
|
6 |
flush tables with read lock;
|
|
7 |
select ((@id := kill_id) - kill_id) from t1;
|
|
8 |
((@id := kill_id) - kill_id)
|
|
9 |
0
|
|
10 |
kill connection @id;
|
|
11 |
drop table t1;
|
|
12 |
set @@global.concurrent_insert= @old_concurrent_insert;
|