~linuxjedi/drizzle/trunk-bug-667053

« back to all changes in this revision

Viewing changes to mysql-test/r/flush_read_lock_kill.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
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;