Bug #47583 Test main.lock fails if server is compiled without support for partition
Submitted: 24 Sep 2009 7:15 Modified: 9 Mar 2011 16:34
Reporter: Olav Sandstå Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.5.99, 6.0.14, 6.0-codebase OS:Any
Assigned to: Mattias Jonsson CPU Architecture:Any
Tags: regression

[24 Sep 2009 7:15] Olav Sandstå
The test main.lock fails if mysqld is compiled without support for partition. The following error message is printed:

main.lock                                [ fail ]
        Test ended at 2009-09-23 16:31:57

CURRENT_TEST: main.lock
mysqltest: At line 410: query 'create table t1 (i int) partition by list (i)
(partition p0 values in (1),
partition p1 values in (2,3),
partition p2 values in (4,5))' failed: 1289: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

How to repeat:
1. Use 6.0 code base
2. Configure without support for partition
3. make
4. Run the test:

     ./mysql-test-run.pl lock

Suggested fix:
Include the following in the lock.test file:

--source include/have_partition.inc
[24 Sep 2009 8:20] Susanne Ebrecht
it is not failing with 5.1 bzr tree.
[24 Sep 2009 9:23] Sveta Smirnova
Thank you for the report.

Verified as described.
[7 Oct 2009 8:49] Bjørn Munch
I was also bitten by this. The partition dependent part that's been added to the test should probably be split off into a separete test that does

--source include/have_partition.inc
[26 Jan 2011 22:08] Bugs System
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:


3280 Mattias Jonsson	2011-01-26
      Bug#47583: Test main.lock fails if server is compiled without support for partition
      Problem was lock.test used partitioning, but did not
      require partitioning to run.
      Solution was to move the specific test which used
      partitioning into partition.test instead.
     @ mysql-test/r/lock.result
        Updated result
     @ mysql-test/r/partition.result
        Updated result
     @ mysql-test/t/lock.test
        Moved partition test to partition.test
     @ mysql-test/t/partition-master.opt
        Old leftover file, no tests in partition.test
        requires symbolic-links (i.e. DATA/INDEX DIRECTORY)
     @ mysql-test/t/partition.test
        Moved test from lock.test
[9 Mar 2011 16:34] Mattias Jonsson
Included in mysql-5.6.2-m5