MySQL Bugs: #31169: Test case does not check whether configuration contains feature tested

Bug #31169	Test case does not check whether configuration contains feature tested
Submitted:	24 Sep 2007 8:24	Modified:	1 Nov 2007 12:48
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1.22-rc	OS:	Any
Assigned to:	Matthias Leich	CPU Architecture:	Any

Description:
Test case "rpl_innodb_bug30919" checks whether some setting of "innodb_autoinc_lock_mode" is compatible with partitioning.

In all configurations which do not contain partitioning, this is bound to fail - see this symptom:

=====
rpl.rpl_innodb_bug30919        [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE test.part_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
fkid MEDIUMINT, filler VARCHAR(255),
PRIMARY KEY(id)) ENGINE=$engine_type
PARTITION BY RANGE(id)
SUBPARTITION BY hash(id) subpartitions 2
(PARTITION pa3 values less than (42),
PARTITION pa6 values less than (60),
PARTITION pa7 values less than (70),
PARTITION pa8 values less than (80),
PARTITION pa9 values less than (90),
PARTITION pa10 values less than (100),
PARTITION pa11 values less than MAXVALUE)' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
(the last lines may be the most important ones)

Stopping All Servers
Restoring snapshot of databases
Resuming Tests
=====

How to repeat:
Run the test suite in a configuration that does not include partitioning, like "enterprise".

Suggested fix:
Add a check whether partitioning is configured.

Different test, same issue:

rpl.rpl_innodb_bug28430        [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'CREATE TABLE test.bykey_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
fkid MEDIUMINT, filler VARCHAR(255),
PRIMARY KEY(id)) ENGINE=$engine_type
PARTITION BY KEY(id) partitions 5' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
(the last lines may be the most important ones)

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

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/35573

ChangeSet@1.2579, 2007-10-15 17:04:43+02:00, mleich@four.local.lan +2 -0
  Fix for
  Bug#31169 Test case does not check whether configuration contains feature tested

Bug within test case, no documentation needed.

Pushed into 6.0.4-alpha

Pushed into 5.1.23-rc