1--source include/have_tokudb.inc 2SET DEFAULT_STORAGE_ENGINE='tokudb'; 3# 4# Bug #22169: Crash with count(distinct) 5# 6--echo *** Bug #22169 *** 7 8--disable_warnings 9DROP TABLE IF EXISTS t1; 10--enable_warnings 11 12CREATE TABLE t1 (a int, b bigint, c char(10), d date, e int, primary key (a)); 13 14INSERT into t1 values (1,54,"zardosht", '1986-08-30', 3287); 15INSERT into t1 values (2,8709,"Alaadin", '1789-01-31', 8327); 16INSERT into t1 values (3,234,"Gilbert", '1325-05-21', 871233); 17INSERT into t1 values (4,563,"Lois", '1981-11-06', 654); 18INSERT into t1 values (5,587,"Lexington", '1844-03-01', 75); 19INSERT into t1 values (6,934764,"Goliath", '1161-11-01', 453); 20INSERT into t1 values (7,109234,"Peter", '2005-11-01', 5); 21INSERT into t1 values (8,9438,"Bart", '1472-11-01', 234); 22INSERT into t1 values (9,111111111,"Superman", '1776-07-04', 65); 23INSERT into t1 values (10,50000004,"Batman", '1981-11-01', 87423); 24 25SELECT * from t1; 26 27alter table t1 drop primary key; 28SELECT * from t1; 29alter table t1 add primary key (c(3)); 30SELECT * from t1; 31 32alter table t1 drop primary key; 33SELECT * from t1; 34alter table t1 add primary key (a,c(3)); 35SELECT * from t1; 36 37alter table t1 drop primary key; 38SELECT * from t1; 39alter table t1 add primary key (c(3),a); 40SELECT * from t1; 41 42alter table t1 drop primary key; 43SELECT * from t1; 44alter table t1 add primary key (c(3),e); 45SELECT * from t1; 46 47alter table t1 drop primary key; 48SELECT * from t1; 49alter table t1 add primary key (e,c(3)); 50SELECT * from t1; 51 52DROP TABLE t1; 53