oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: yuchen.wyc
5
# owner group: SQL1
6
# description: OUR GOAL: Make all this simple and effective!
7
#####bug:事务中范围更新超时时间未生效
8
--disable_warnings
9
drop table if exists t1;
10
--enable_warnings
11
create table t1(pk int primary key, i1 int, v1 varchar(20)); 
12
set autocommit=0;                    
13
set session ob_trx_timeout=10000000;                                                            
14
#because start from 4.0 empty delete won't cause session into txn,
15
#we do some really modifies here
16
--disable_query_log
17
insert into t1 values(1,1,'1');
18
--enable_query_log
19
delete from t1 where pk<4;          
20
sleep 12;
21
--error 6002
22
commit;
23

24