storage/rocksdb/mysql-test/rocksdb/t/gap_lock_issue254.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- source include/have_binlog_format_row.inc
-- source include/have_rocksdb.inc

# For issue#254
create table t (id int primary key, value int);
begin;
update t set value=100 where id in (1, 2);
commit;
begin;
--error ER_UNKNOWN_ERROR
select * from t for update;
commit;
drop table t;