summaryrefslogtreecommitdiff
path: root/mysql-test/r/flush_read_lock_kill.result
blob: f69656806da24fd3b0b13da849758e7c596252c1 (plain)
1
2
3
4
5
6
7
8
9
10
set @@global.concurrent_insert= 0;
drop table if exists t1;
create table t1 (kill_id int);
insert into t1 values(connection_id());
flush tables with read lock;
select ((@id := kill_id) - kill_id) from t1;
((@id := kill_id) - kill_id)
0
kill connection @id;
drop table t1;