Description:
Test case fails if InnoDB is not compiled into the binary
*** r/group_min_max.result Sat Apr 1 02:29:15 2006
--- r/group_min_max.reject Mon Apr 3 14:14:53 2006
***************
*** 2012,2017 ****
--- 2012,2019 ----
NULL 1
drop table t1;
create table t1 (f1 int, f2 char(1), primary key(f1,f2)) engine=innodb;
+ Warnings:
+ Warning 1266 Using storage engine MyISAM for table 't1'
insert into t1 values ( 1,"e"),(2,"a"),( 3,"c"),(4,"d");
alter table t1 drop primary key, add primary key (f2, f1);
explain select distinct f1 a, f1 b from t1;
***************
*** 2019,2025 ****
1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary
explain select distinct f1, f2 from t1;
id select_type table type possible_keys key key_len ref rows Extra
! 1 SIMPLE t1 range NULL PRIMARY 5 NULL 3 Using index for group-by; Using temporary
drop table t1;
create table t1 (c1 int not null,c2 int not null, primary key(c1,c2));
insert into t1 (c1,c2) values
--- 2021,2027 ----
1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary
explain select distinct f1, f2 from t1;
id select_type table type possible_keys key key_len ref rows Extra
! 1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary
drop table t1;
create table t1 (c1 int not null,c2 int not null, primary key(c1,c2));
insert into t1 (c1,c2) values
How to repeat:
Configure, build and test with
./configure --without-innodb --without-berkeley-db --without-ndbcluster
make
cd mysql-test
./mysql-test-run.pl --force
Description: Test case fails if InnoDB is not compiled into the binary *** r/group_min_max.result Sat Apr 1 02:29:15 2006 --- r/group_min_max.reject Mon Apr 3 14:14:53 2006 *************** *** 2012,2017 **** --- 2012,2019 ---- NULL 1 drop table t1; create table t1 (f1 int, f2 char(1), primary key(f1,f2)) engine=innodb; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' insert into t1 values ( 1,"e"),(2,"a"),( 3,"c"),(4,"d"); alter table t1 drop primary key, add primary key (f2, f1); explain select distinct f1 a, f1 b from t1; *************** *** 2019,2025 **** 1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary explain select distinct f1, f2 from t1; id select_type table type possible_keys key key_len ref rows Extra ! 1 SIMPLE t1 range NULL PRIMARY 5 NULL 3 Using index for group-by; Using temporary drop table t1; create table t1 (c1 int not null,c2 int not null, primary key(c1,c2)); insert into t1 (c1,c2) values --- 2021,2027 ---- 1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary explain select distinct f1, f2 from t1; id select_type table type possible_keys key key_len ref rows Extra ! 1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary drop table t1; create table t1 (c1 int not null,c2 int not null, primary key(c1,c2)); insert into t1 (c1,c2) values How to repeat: Configure, build and test with ./configure --without-innodb --without-berkeley-db --without-ndbcluster make cd mysql-test ./mysql-test-run.pl --force