MySQL Bugs: #26669: Two tests on partition fail while blackhole engine is missing

Bug #26669	Two tests on partition fail while blackhole engine is missing
Submitted:	27 Feb 2007 8:37	Modified:	1 Nov 2007 12:47
Reporter:	Geert Vanderkelen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1.15-ndb-6.1.3	OS:	Linux (Linux)
Assigned to:	Matthias Leich	CPU Architecture:	Any
Tags:	partition, test

Description:
Two tests fails when running ./mysql-test-run.pl giving a warning saying the BLACKHOLE engine is missing. It's probably better to skip the tests when this engine is not available or use another one like MyISAM?

How to repeat:
$ /mysql-test-run.pl --force

Gives following errors:

partition                      [ fail ]

Errors are (from
/********/mysqlcom-5.1.15-ndb-6.1.3-telco/mysql-test/var/log/mysqltest-
time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/partition.result  2007-02-25 17:26:33.000000000 +0300
--- r/partition.reject  2007-02-26 17:28:13.000000000 +0300
***************
*** 322,333 ****
--- 322,337 ----
  CREATE TABLE `t1` (
  `id` int(11) default NULL
  ) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1 PARTITION BY HASH (id) ;
+ Warnings:
+ Error 1286    Unknown table engine 'BLACKHOLE'
  SELECT * FROM t1;
  id
  drop table t1;
  CREATE TABLE `t1` (
  `id` int(11) default NULL
  ) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1 PARTITION BY HASH (id) ;
+ Warnings:
+ Error 1286    Unknown table engine 'BLACKHOLE'
  SELECT * FROM t1;
  id
  drop table t1;
-------------------------------------------------------

partition_hash                 [ fail ]

Errors are (from
/*********/mysqlcom-5.1.15-ndb-6.1.3-telco/mysql-test/var/log/mysqltest-
time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/partition_hash.result     2007-02-25 17:26:33.000000000 +0300
--- r/partition_hash.reject     2007-02-26 17:28:18.000000000 +0300
***************
*** 169,174 ****
--- 169,176 ----
  -1    #######
  drop table t1;
  CREATE TABLE t1 (s1 int) ENGINE=BLACKHOLE PARTITION BY HASH (s1);
+ Warnings:
+ Error 1286    Unknown table engine 'BLACKHOLE'
  INSERT INTO t1 VALUES (0);
  DROP TABLE t1;
  create table t1 (c1 int DEFAULT NULL,
-------------------------------------------------------

Thank you for the report.

Verified as described using usual BK sources compiled with configure string:

./configure --prefix=/users/ssmirnova/build/mysql-5.1 --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-debug=full --with-ssl --with-embedded-server --with-error-inject --enable-local-infile --with-plugin-partition

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/35925

ChangeSet@1.2580, 2007-10-19 16:19:54+02:00, mleich@four.local.lan +8 -0
  This changeset contains the following stuff:
  - Fix for
    Bug#28827 Partition test needs archive engine
    Bug#26669 Two tests on partition fail while blackhole engine is missing
    Solution: Move ARCHIVE and BLACKHOLE sub test cases to their own main test.
  - The two bugs above + the fact that CSV could be also sometimes not
    available --> Move also CSV sub tests out.
  - Minor cleanups
    - Replace error numbers with error names
    - fix typos, wrong comments
    - remove redundant sub test cases
    - add missing drop database
    - SET GLOBAL general_log = default is wrong, = 1 is correct

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/36067

ChangeSet@1.2588, 2007-10-22 20:10:51+02:00, mleich@four.local.lan +8 -0
  This changeset contains the following stuff:
  - Fix for
      Bug#28827 Partition test needs archive engine
      Bug#26669 Two tests on partition fail while blackhole engine is missing
    Solution: Move ARCHIVE and BLACKHOLE sub test cases to their own main test.
  - The two bugs above + the fact that CSV could be also sometimes not
    available --> Move also CSV sub tests out.
  - Minor cleanups
    - Replace error numbers with error names
    - fix typos, wrong comments
    - remove redundant sub test cases
    - add missing drop database
    - SET GLOBAL general_log = default is wrong, = 1 is correct

Pushed into 6.0.4-alpha

Pushed into 5.1.23-rc

Test case change. No changelog entry needed.