This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions.
Beginning with MySQL 5.1.12, only the following MySQL functions are supported in partitioning expressions:
CEILING()
and
FLOOR()
.
Each of these functions returns an integer only if it is
passed an integer argument. This means, for example, that
the following CREATE TABLE
statement fails with an error, as shown here:
mysql>CREATE TABLE t (c FLOAT) PARTITION BY LIST( FLOOR(c) )(
->PARTITION p0 VALUES IN (1,3,5),
->PARTITION p1 VALUES IN (2,4,6)
->);
ERROR 1490 (HY000): The PARTITION function returns the wrong type
See Section 11.5.2, “Mathematical Functions”, for more information about the return types of these functions.
User Comments
Add your own comment.