summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/innodb_bug53674.result
blob: c4021c2e7cdfcd78468bfc61b95e9d9205bf53bd (plain)
1
2
3
4
5
6
7
8
9
10
11
create table bug53674(a int)engine=innodb;
insert into bug53674 values (1),(2);
start transaction;
select * from bug53674 for update;
a
1
2
select * from bug53674 where a=(select a from bug53674 where a > 1);
a
2
drop table bug53674;