MySQL Forums
Forum List  »  Partitioning

MySQL 5.1.9-beta: Partitioning specific items
Posted by: Edwin DeSouza
Date: April 26, 2006 06:14PM

MySQL 5.1.9-beta, a new version of the popular Open Source Database
Management System, has been released.

Complete Announcement:,85672,85672#msg-85672

Functionality added or changed:
* For partitioned tables, the output of SHOW TABLE STATUS now
shows in the Engine column the name of the storage engine used
by all partitions for the table; in the Create_options column,
the output now shows "partitioned" for a partitioned table. This
change also affects the values shown in the corresponding
columns of the INFORMATION_SCHEMA.TABLES table.

Bugs fixed:
* NDB Cluster: BLOB columns did not work correctly with
user-partitioned NDB tables.
* Partition pruning did not work properly for some kinds of
partitioning and subpartitioning, with certain WHERE clauses.
(Partitions and subpartitions that should have been marked as
used were not so marked.) The error could manifest as
incorrect content in EXPLAIN PARTITIONS output as well as
missing rows in the results of affected queries.
* A query against a partitioned table using WHERE col IS NULL
could produce incorrect results given the following
+ The table had partitions and subpartitions
+ The partitioning function depended on a single column col
of one of the MySQL integer types
+ The partitioning function was not monotonically
The same issue could cause the server to crash when run in
debug mode. (Bug#18659:
* MEDIUMINT columns were not handled in the same way as other
column types by partition pruning. Partition pruning would sometimes use inappropriate columns in preforming queries. Both of these issues were rectified as part of the same bugfix.
* Quoted values could not be used for partition option values.
* Delimited identifiers could not be used in defining
partitions. (Bug#13433:
* Queries using WHERE ... IS NULL returned incorrect results
from partitioned tables.
* Partition pruning did not perform correctly with partitions on
NULL, and could potentially crash the server.

Edited 1 time(s). Last edit at 07/07/2006 02:20PM by Edwin DeSouza.

Options: ReplyQuote

Written By
MySQL 5.1.9-beta: Partitioning specific items
April 26, 2006 06:14PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.