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

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

12
create table t1(pk varchar(16000) , t  timestamp(6) default "2012-01-01 12:00:00");
13

14

15
let $a=abcdefghij;
16
let $p=abcdefghij;
17
let $cnt=1000;
18
while($cnt)
19
{ 
20
   let $a=$a$p;
21
   dec $cnt;
22
}
23
eval insert into t1 values('$a',timestamp'2012-12-12 12:12:12.123456');
24

25
select length(pk) from t1;
26
select * from t1;
27
drop table t1;
28