oceanbase

1
drop database if exists jx_db;
2
create database jx_db;
3
use jx_db;
4
drop table if exists t1, t2,t3;
5
create table t1 (c1 int primary key, c2 int);
6
set  autocommit=0;
7
insert into t1 values(1,1);
8
create table t2 (c1 int primary key, c2 int);
9
rollback;
10
select * from t1;
11
c1	c2
12
1	1
13
desc t2;
14
Field	Type	Null	Key	Default	Extra
15
c1	int(11)	NO	PRI	NULL	
16
c2	int(11)	YES		NULL	
17
set  autocommit=1;
18
begin;
19
insert into t1 values(2,2);
20
create table t3 (c1 int primary key, c2 int);
21
rollback;
22
select * from t1;
23
c1	c2
24
1	1
25
2	2
26
desc t3;
27
Field	Type	Null	Key	Default	Extra
28
c1	int(11)	NO	PRI	NULL	
29
c2	int(11)	YES		NULL	
30
create table ddl_t(c int);
31
set autocommit = off;
32
insert into ddl_t values(3);
33
alter table ddl_t add column c2 int;
34
select * from ddl_t;
35
c	c2
36
3	NULL
37
rollback;
38
select * from ddl_t;
39
c	c2
40
3	NULL
41
create table jx_t1(c int);
42
set autocommit = off;
43
insert into jx_t1 values(4);
44
create table jx_t1(c int);
45
ERROR 42S01: Table 'jx_t1' already exists
46
select * from jx_t1;
47
c
48
4
49
rollback;
50
select * from jx_t1;
51
c
52
4
53
create table jx_t2(c int);
54
set autocommit = off;
55
insert into jx_t2 values(5);
56
create user if not exists jx_user;
57
select * from jx_t2;
58
c
59
5
60
rollback;
61
select * from jx_t2;
62
c
63
5
64
create table jx_t3(c int);
65
set autocommit = off;
66
insert into jx_t3 values(6);
67
create user jx_user;
68
ERROR HY000: Operation CREATE USER failed for 'jx_user'@'%'
69
select * from jx_t3;
70
c
71
6
72
rollback;
73
select * from jx_t3;
74
c
75
6
76
set autocommit = on;
77
drop user jx_user;
78
drop database jx_db;
79