oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: dachuan.sdc
5
#owner group: sql1
6
#tags: create_table, insert
7
#description:
8

9
--disable_warnings
10
drop table if exists t1;
11
--enable_warnings
12

13
create table t1(c1 int primary key, c2 int);
14
insert into t1 values(1,1),(2,2),(3,3);
15

16
let $cnt=30;
17
while($cnt) 
18
{
19
select * from t1 as t2 where c1=1;
20
dec $cnt;
21
}
22

23
drop table t1;
24