blob: 1b624cf38c0548dbec585f1283a0f8f11d8d4d36 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
--source include/have_rocksdb.inc
--disable_warnings
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
--enable_warnings
create table t1 (a int, primary key(a) comment 'lock_into_cf1') engine=rocksdb;
insert into t1 values (1);
insert into t1 values (2);
create table t2 (a int, primary key(a) comment 'lock_info_cf2') engine=rocksdb;
insert into t2 values (1);
insert into t2 values (2);
set autocommit=0;
select * from t1 for update;
select * from t2 for update;
use information_schema;
--replace_column 2 _txn_id_ 3 _key_
select rocksdb_ddl.cf, rocksdb_locks.transaction_id, rocksdb_locks.key
from rocksdb_locks
left join rocksdb_ddl
on rocksdb_locks.column_family_id=rocksdb_ddl.column_family
order by rocksdb_ddl.cf;
use test;
DROP TABLE t1;
DROP TABLE t2;
|