MySQL Bugs: #13390: group_min_max fails if the test suite is run with --skip-innodb

Bug #13390	group_min_max fails if the test suite is run with --skip-innodb
Submitted:	21 Sep 2005 22:16	Modified:	25 Sep 2005 19:17
Reporter:	Konstantin Osipov (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	5.0 BK source	OS:	Linux (Linux)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
Test group_min_max fails if the test suite is run with option --skip-innodb

group_min_max                  [ fail ]

Errors are (from /home/kostja/work/mysql-5.0-release/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 0: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/group_min_max.result      2005-09-21 15:24:39.000000000 +0300
--- r/group_min_max.reject      2005-09-22 01:13:12.000000000 +0300
***************
*** 1975,1980 ****
--- 1975,1982 ----
  create table bug12672 (
  pk_col int auto_increment primary key, a1 char(64), a2 char(64), b char(16), c char(16) not null, d char(16), dummy char(64) default ' '
  ) engine=innodb;
+ Warnings:
+ Warning       1266    Using storage engine MyISAM for table 'bug12672'
  insert into bug12672 (a1, a2, b, c, d, dummy) select * from t1;
  create index idx12672_0 on bug12672 (a1);
  create index idx12672_1 on bug12672 (a1,a2,b,c);
***************
*** 1984,1990 ****
  test.t1       analyze status  Table is already up to date
  explain select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  id    select_type     table   type    possible_keys   key     key_len ref    rows     Extra
! 1     SIMPLE  bug12672        range   PRIMARY PRIMARY 4       NULL    #      Using where; Using temporary
  select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  a1
  a
--- 1986,1992 ----
  test.t1       analyze status  Table is already up to date
  explain select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  id    select_type     table   type    possible_keys   key     key_len ref    rows     Extra

How to repeat:
Run the test suite ./mysql-test-run --skip-innodb --skip-ndbcluster --force and see.

Suggested fix:
Move InnoDB specific parts to a tests that is run only if have_innodb.

group_min_max                  [ fail ]

Errors are (from /home/miguel/dbs/mysql-5.0/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 0: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/group_min_max.result      2005-09-03 21:53:24.000000000 +0300
--- r/group_min_max.reject      2005-09-22 04:14:06.000000000 +0300
***************
*** 1975,1980 ****
--- 1975,1982 ----
  create table bug12672 (
  pk_col int auto_increment primary key, a1 char(64), a2 char(64), b char(16), c char(16) not null, d char(16), dummy char(64) default ' '
  ) engine=innodb;
+ Warnings:
+ Warning       1266    Using storage engine MyISAM for table 'bug12672'
  insert into bug12672 (a1, a2, b, c, d, dummy) select * from t1;
  create index idx12672_0 on bug12672 (a1);
  create index idx12672_1 on bug12672 (a1,a2,b,c);
***************
*** 1984,1990 ****
  test.t1       analyze status  Table is already up to date
  explain select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  bug12672        range   PRIMARY PRIMARY 4       NULL    #       Using where; Using temporary
  select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  a1
  a
--- 1986,1992 ----
  test.t1       analyze status  Table is already up to date
  explain select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  bug12672        ALL     PRIMARY NULL    NULL    NULL    #       Using where; Using temporary
  select distinct a1 from bug12672 where pk_col not in (1,2,3,4);
  a1
  a
-------------------------------------------------------

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html