MySQL Bugs: #41228: The test partition_innodb

Bug #41228	The test partition_innodb_stmt fails
Submitted:	4 Dec 2008 14:04	Modified:	10 Dec 2008 19:07
Reporter:	Vasil Dimov	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1-bzr r2699 (latest)	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	partition_innodb_stmt

Description:
$ ./mysql-test-run partition_innodb_stmt
Logging: ./mysql-test-run partition_innodb_stmt
MySQL Version 5.1.31
Using dynamic switching of binlog format
Skipping ndbcluster, mysqld not compiled with ndbcluster
Skipping SSL, mysqld not compiled with SSL
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using IM_PORT               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

main.partition_innodb_stmt     [ fail ]

mysqltest: At line 7: query 'CREATE TABLE t1
(
id SMALLINT NOT NULL,
PRIMARY KEY (id)
) ENGINE=innodb
PARTITION BY RANGE (id)
(
PARTITION p1 VALUES LESS THAN (2),
PARTITION p2 VALUES LESS THAN (4),
PARTITION p3 VALUES LESS THAN (10)
)' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

The result from queries just before the failure was:
# connection default
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
CREATE TABLE t1
(
id SMALLINT NOT NULL,
PRIMARY KEY (id)
) ENGINE=innodb
PARTITION BY RANGE (id)
(
PARTITION p1 VALUES LESS THAN (2),
PARTITION p2 VALUES LESS THAN (4),
PARTITION p3 VALUES LESS THAN (10)
);

More results from queries before failure can be found in /tmp/mysql-5.1/mysql-test/var/log/partition_innodb_stmt.log

Aborting: main.partition_innodb_stmt failed in default mode. 
To continue, re-run with '--force'.
Stopping All Servers

$

How to repeat:
Fetch the latest MySQL 5.1 source from bzr, configure with

./configure --with-plugins=innobase

and run the test.

Suggested fix:
This test should be disabled if partitioning is not enabled, like other tests, I observe the failure since Nov 12

This is the fix:

=== modified file 'mysql-test/t/partition_innodb_stmt.test'
--- mysql-test/t/partition_innodb_stmt.test	2008-10-29 20:20:04 +0000
+++ mysql-test/t/partition_innodb_stmt.test	2008-12-04 14:13:38 +0000
@@ -1,5 +1,6 @@
 --source include/have_binlog_format_statement.inc
 --source include/have_innodb.inc
+--source include/have_partition.inc
 
 --echo # connection default
 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;

Verified on Ubuntu 8.10.
miguel@hegel:~/bzr/mysql-5.1-build/mysql-test$ ./mysql-test-run partition_innodb_stmt
Logging: ./mysql-test-run partition_innodb_stmt
MySQL Version 5.1.31
Using dynamic switching of binlog format
Skipping ndbcluster, mysqld not compiled with ndbcluster
Skipping SSL, mysqld not compiled with SSL
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using IM_PORT               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

main.partition_innodb_stmt     [ fail ]

mysqltest: At line 7: query 'CREATE TABLE t1
(
id SMALLINT NOT NULL,
PRIMARY KEY (id)
) ENGINE=innodb
PARTITION BY RANGE (id)
(
PARTITION p1 VALUES LESS THAN (2),
PARTITION p2 VALUES LESS THAN (4),
PARTITION p3 VALUES LESS THAN (10)
)' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

The result from queries just before the failure was:
# connection default
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
CREATE TABLE t1
(
id SMALLINT NOT NULL,
PRIMARY KEY (id)
) ENGINE=innodb
PARTITION BY RANGE (id)
(
PARTITION p1 VALUES LESS THAN (2),
PARTITION p2 VALUES LESS THAN (4),
PARTITION p3 VALUES LESS THAN (10)
);

the proposed change are correct, I will push this as a post push fix for bug#39084.

Closing as duplicate of bug#39084. Pushed the fix into mysql-5.1-bugteam.