Bug #68056 PARTITION BY RANGE COLUMNS

• Submitted: 9 Jan 2013 11:00
• Modified: 9 Jan 2013 11:13
• Reporter: Michael Gorelik
• Status: Unsupported
• Category: MySQL Server: Partitions
• Severity: S1 (Critical)
• Version: 6.0.11
• OS: Microsoft Windows
• CPU Architecture: Any
• Tags: partition by range columns

[9 Jan 2013 11:00] Michael Gorelik

Description:
The following command do not work on mysql 6.0.11  (combined with create or alter statements):

"PARTITION BY RANGE COLUMNS"

All those statement works on my MySQL Community Server 5.5.25 but not for the 6.0.11-alpha-community MySQL Community Server

How to repeat:
test-case 1:

CREATE TABLE x (
  a INT,
  b DATE
)

PARTITION BY RANGE COLUMNS (a) (PARTITION p0 VALUES LESS THAN (10));

test-case 2 (the table is non partitioned initially):

ALTER TABLE x PARTITION BY RANGE COLUMNS (a) (PARTITION p0 VALUES LESS THAN (10))

test-case 3:

CREATE TABLE x (
  a INT,
  b DATE
)

PARTITION BY RANGE COLUMNS (b) (PARTITION p0 VALUES LESS THAN ("2013-01-01"));

test-case 4 (the table is non partitioned initially):

ALTER TABLE x PARTITION BY RANGE COLUMNS (b) (PARTITION p0 VALUES LESS THAN ("2013-01-01"))

[9 Jan 2013 11:13] MySQL Verification Team

6.0.11 is not a supported version anymore. please try 5.6.9.

mysql> CREATE TABLE x (
    ->   a INT,
    ->   b DATE
    -> )
    ->
    -> PARTITION BY RANGE COLUMNS (a) (PARTITION p0 VALUES LESS THAN (10));
Query OK, 0 rows affected (0.20 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.6.9-rc  |
+-----------+
1 row in set (0.00 sec)

[9 Jan 2013 11:14] MySQL Verification Team

http://dev.mysql.com/downloads/mysql/5.6.html