CREATE TABLE `t2` (
  `a` int(11) NOT NULL auto_increment,
  `b` int(11) default NULL,
  PRIMARY KEY  (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

insert into t2 values(null, 0);

insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;
insert into t2 select null, b from t2;

#case 1: low
send update t2 set b=1;

sleep 1;

connect (addconroot, localhost, root,,);
connection addconroot;

send update low_priority t2 set b=2;

sleep 1;

connect (addconroot1, localhost, root,,);
connection addconroot1;
select * from t2 limit 3;

#case 2: high
connection addconroot1;
lock table t2 read;

connection addconroot;
send update t2 set b=3;

sleep 1;

connection default;
select high_priority * from t2 limit 3;

sleep 1;

show processlist;