MySQL Bugs: #47583: Test main.lock fails if server is compiled without support for partition

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:	None
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

Description:
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

it is not failing with 5.1 bzr tree.

Thank you for the report.

Verified as described.

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

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

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

Included in mysql-5.6.2-m5