27 lines
686 B
Plaintext
27 lines
686 B
Plaintext
--disable_query_log
|
|
set @@session.explicit_defaults_for_timestamp=off;
|
|
--enable_query_log
|
|
# owner : dachuan.sdc
|
|
# owner group: SQL2
|
|
# description:
|
|
#
|
|
use test;
|
|
--disable_warnings
|
|
drop table if exists tc1;
|
|
--enable_warnings
|
|
create table tc1(c1 int not null primary key, c2 varchar(11));
|
|
insert into tc1 values (1, 'aaa');
|
|
insert into tc1 values (2, 'bbbb');
|
|
insert into tc1 values (3, 'ccccc');
|
|
create index idxc2 on tc1(c2);
|
|
alter table tc1 add index idxc3(c1,c2);
|
|
select * from tc1;
|
|
--source mysql_test/include/check_all_idx_ok.inc
|
|
show index from tc1;
|
|
truncate table tc1;
|
|
let $is_truncate_table = 1;
|
|
let $is_truncate_table = 0;
|
|
select * from tc1;
|
|
show index from tc1;
|
|
drop table tc1;
|