oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: jim.wjh
5
# owner group: SQL3
6
# description: foobar
7
--echo case 1: commit
8
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
9
connection conn1;
10
show variables like 'autocommit';
11
--disable_warnings
12
drop table if exists t1;
13
--enable_warnings
14
create table t1 (c1 int primary key, c2 varchar(1024));
15
set autocommit=0;
16
insert into t1 values (1, '中国');
17
select * from t1 where c1 = 1 for update;
18
commit;
19
set autocommit=1;
20
select * from t1;
21
disconnect conn1;
22

23

24