|
SELECT .. FOR UPDATE is supposed to lock a row for the current connection, not from it as it happens now.
Besides, outside a transaction it should have no effect at all, but now it does.
The test case below shows both problems – UPDATE fails with ER_LOCK_WAIT_TIMEOUT.
create table t1 (pk int primary key, i int) engine=LevelDB;
|
set autocommit=1;
|
insert into t1 values (1,1);
|
select * from t1 where pk = 1 for update;
|
update t1 set i = 10 where pk = 1;
|
mysqltest: At line 8: query 'update t1 set i = 10 where pk = 1' failed: 1205: Lock wait timeout exceeded; try restarting transaction
|
revision-id: psergey@askmonty.org-20130114131529-qv3531bw9fdklwob
|
revno: 4483
|
branch-nick: mysql-5.6-leveldb
|
|
[MDEV-4039]