Bug #68056 PARTITION BY RANGE COLUMNS
Submitted: 9 Jan 2013 11:00 Modified: 9 Jan 2013 11:13
Reporter: Michael Gorelik Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Partitions Severity:S1 (Critical)
Version:6.0.11 OS:Windows
Assigned to: 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