Bug #54237 Confusing server advice about --with-partition

• Submitted: 4 Jun 2010 15:09
• Modified: 7 Jun 2010 7:34
• Reporter: Paul DuBois
• Status: Duplicate
• Category: MySQL Server: Compiling
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• CPU Architecture: Any

[4 Jun 2010 15:09] Paul DuBois

Description:
I tried to create a partitioned table and got this:

ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

But when I added --with-partition to my configure options, I got this:

configure: WARNING: unrecognized options: --with-partition

However: SHOW PLUGINS with the rebuilt server does show that partitioning is enabled, despite the warning.

How to repeat:
Test script:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (dt datetime)
PARTITION BY RANGE(YEAR(dt)) (
    PARTITION p0 VALUES LESS THAN MAXVALUE
);

Result:

mysql> DROP TABLE IF EXISTS t1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE t1 (dt datetime)
    -> PARTITION BY RANGE(YEAR(dt)) (
    ->     PARTITION p0 VALUES LESS THAN MAXVALUE
    -> );
ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

Add --with-partition to configure options, the warning will occur at the end of the output.

Suggested fix:
The advice should be to add "partition" to the --with-plugins option instead? (No configure warning occurs that way.)

[7 Jun 2010 7:34] Sveta Smirnova

This is duplicate of bug #42872