1--echo # 2--echo # mdev-539: fast build of unique/primary indexes for MyISAM/Aria 3--echo # 4 5--source include/default_charset.inc 6 7call mtr.add_suppression("Can't find record in '.*'"); 8 9--disable_warnings 10DROP DATABASE IF EXISTS dbt3_s001; 11--enable_warnings 12CREATE DATABASE dbt3_s001; 13 14use dbt3_s001; 15 16--disable_query_log 17--disable_result_log 18--disable_warnings 19--source include/dbt3_s001.inc 20--enable_warnings 21--enable_result_log 22--enable_query_log 23 24 25drop index `primary` on lineitem; 26show create table lineitem; 27alter table lineitem add primary key (l_orderkey, l_linenumber); 28show create table lineitem; 29drop index `primary` on lineitem; 30select * from lineitem where l_orderkey=1 and l_linenumber=2; 31insert into lineitem values 32(1,68,9,2,36,34850.16,0.07,0.06,'N','O','1996-04-12','1996-02-28','1996-04-20','TAKE BACK RETURN','MAIL','slyly bold pinto beans detect s'); 33select * from lineitem where l_orderkey=1 and l_linenumber=2; 34--error ER_DUP_ENTRY 35alter table lineitem add primary key (l_orderkey, l_linenumber); 36show create table lineitem; 37select * from lineitem where l_orderkey=1 and l_linenumber=2; 38delete from lineitem where l_orderkey=1 and l_linenumber=2 and l_discount=0.07; 39alter table lineitem add primary key (l_orderkey, l_linenumber); 40show create table lineitem; 41select * from lineitem where l_orderkey=1 and l_linenumber=2; 42 43create unique index i_c_name on customer(c_name); 44show create table customer; 45select * from customer where c_name='Customer#000000003'; 46drop index i_c_name on customer; 47insert into customer values 48(303,'Customer#000000003','MG9kdTD2WBHm',1,'11-719-748-3364',7498.12,'AUTOMOBILE','special packages wake. slyly reg'); 49select * from customer where c_name='Customer#000000003'; 50--error ER_DUP_ENTRY 51alter table customer add unique index i_c_name(c_name); 52show create table customer; 53select * from customer where c_name='Customer#000000003'; 54delete from customer where c_custkey=303; 55select * from customer where c_name='Customer#000000003'; 56alter table customer add unique index i_c_name(c_name); 57show create table customer; 58select * from customer where c_name='Customer#000000003'; 59 60drop index `primary` on customer; 61show create table customer; 62insert into customer values 63(3,'Customer#000000303','MG9kdTD2WBHm',1,'11-719-748-3364',7498.12,'AUTOMOBILE','special packages wake. slyly reg'); 64alter ignore table customer add primary key (c_custkey); 65show create table customer; 66select * from customer where c_custkey=3; 67--source include/restore_charset.inc 68DROP DATABASE dbt3_s001; 69 70