1--source include/have_rocksdb.inc
2
3create table t1 (
4  id int,
5  value int,
6  primary key (id)
7) engine=rocksdb;
8
9insert into t1 values(1,1),(2,2);
10set autocommit=0;
11
12begin;
13insert into t1 values (50,50);
14select * from t1;
15
16update t1 set id=id+100;
17
18select * from t1;
19
20rollback;
21set autocommit=1;
22
23drop table t1;
24