Bug #20161 Information Schema for Partitions don't display LINEAR keyword for subpartition
Submitted: 31 May 2006 7:00 Modified: 2 Jun 2006 5:31
Reporter: Mikael Ronström Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.9-beta OS:Linux (Red Hat RHAS4 x86)
Assigned to: Mikael Ronström CPU Architecture:Any

[31 May 2006 7:00] Mikael Ronström
Description:
CREATE TABLE t1 (a int)
PARTITION BY RANGE (a)
SUBPARTITION BY LINEAR HASH (a)
(PARTITION p0 VALUES LESS THAN (10));

SELECT * FROM information_schema.partitions WHERE table_schema = "test"
AND table_name = t1;

Output from Subpartition Method only shows HASH and not LINEAR HASH as expected.

How to repeat:
CREATE TABLE t1 (a int)
PARTITION BY RANGE (a)
SUBPARTITION BY LINEAR HASH (a)
(PARTITION p0 VALUES LESS THAN (10));

SELECT * FROM information_schema.partitions WHERE table_schema = "test"
AND table_name = t1;

Output from Subpartition Method only shows HASH and not LINEAR HASH as expected.

Suggested fix:
Ensure LINEAR keyword is added when present
[1 Jun 2006 12:14] Mikael Ronström
Reviewed by gluh
Will appear in 5.1.12
[2 Jun 2006 5:31] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented in 5.1.12 changelog. Closed.