oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: dachuan.sdc
5
# owner group: SQL2
6
# tags: ddl
7
# description:
8
#
9
####ddl要自动提交（之前未提交的数据也会一并提交）
10
--disable_warnings
11
drop database if exists jx_db;
12
--enable_warnings
13
create database jx_db;
14
use jx_db;
15

16
--disable_warnings
17
drop table if exists t1, t2,t3;
18
--enable_warnings
19
create table t1 (c1 int primary key, c2 int);
20
set  autocommit=0;
21
insert into t1 values(1,1);
22
create table t2 (c1 int primary key, c2 int);
23
rollback;
24
select * from t1;
25
desc t2;
26
set  autocommit=1;
27
begin;
28
insert into t1 values(2,2);
29
create table t3 (c1 int primary key, c2 int);
30
rollback;
31
select * from t1;
32
desc t3;
33

34
create table ddl_t(c int);
35
set autocommit = off;
36
insert into ddl_t values(3);
37
alter table ddl_t add column c2 int;
38
select * from ddl_t;
39
rollback;
40
select * from ddl_t;
41

42
# ddl执行失败
43
create table jx_t1(c int);
44
set autocommit = off;
45
insert into jx_t1 values(4);
46
--error 1050
47
create table jx_t1(c int);
48
select * from jx_t1;
49
rollback;
50
select * from jx_t1;
51

52
create table jx_t2(c int);
53
set autocommit = off;
54
insert into jx_t2 values(5);
55
--disable_warnings
56
create user if not exists jx_user;
57
--enable_warnings
58
select * from jx_t2;
59
rollback;
60
select * from jx_t2;
61

62
# dcl执行失败
63
create table jx_t3(c int);
64
set autocommit = off;
65
insert into jx_t3 values(6);
66
--error 1396
67
create user jx_user;
68
select * from jx_t3;
69
rollback;
70
select * from jx_t3;
71

72
set autocommit = on;
73
drop user jx_user;
74

75
drop database jx_db;
76