blob: c96c3403b36a87567c075bb41d934ecc4e4aa20e (
plain)
1
2
3
4
5
6
7
8
9
|
-- source include/have_innodb.inc
-- source include/have_log_bin.inc
create table bug53674(a int)engine=innodb;
insert into bug53674 values (1),(2);
start transaction;
select * from bug53674 for update;
select * from bug53674 where a=(select a from bug53674 where a > 1);
drop table bug53674;
|