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
# description:
7
#
8
use test;
9
--disable_warnings
10
drop table if exists tc1;
11
--enable_warnings
12
create table tc1(c1 int not null primary key, c2 varchar(11));
13
insert into tc1 values (1, 'aaa');
14
insert into tc1 values (2, 'bbbb');
15
insert into tc1 values (3, 'ccccc');
16
create index idxc2 on tc1(c2);
17
alter table tc1 add index idxc3(c1,c2);
18
select * from tc1;
19
--source mysql_test/include/check_all_idx_ok.inc 
20
show index from tc1;
21
truncate table tc1;
22
let $is_truncate_table = 1;
23
let $is_truncate_table = 0;
24
select * from tc1;
25
show index from tc1;
26
drop table tc1;
27