oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: link.zt
5
#owner group: sql1
6

7
--disable_warnings
8
drop table if exists t1;
9
--enable_warnings
10

11
--disable_query_log
12
--error 1049
13
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,database_not_exist,$OBMYSQL_PORT);
14
--enable_query_log
15

16
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
17
connect (conn2,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
18
connect (conn3,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
19

20
connection conn1;
21
create table t1(a int primary key,b int);
22
let $a=1;
23
--disable_query_log
24
while($a<1000)
25
{
26

27
  eval insert into t1(a) values($a);
28
  inc $a;
29
}
30
--enable_query_log
31
disconnect conn1;
32

33
connection conn2;
34
select * from t1;
35
drop table t1;
36
disconnect conn2;
37

38
connection conn3;
39
create table t1(a int primary key,b int);
40
drop table t1;
41
disconnect conn3;
42