From: Date: December 12 2007 6:28pm Subject: svn commit - mysqldoc@docsrva: r9267 - in trunk: refman-5.1 refman-6.0 List-Archive: http://lists.mysql.com/commits/39800 Message-Id: <200712121728.lBCHSgxq017940@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: jstephens Date: 2007-12-12 18:28:41 +0100 (Wed, 12 Dec 2007) New Revision: 9267 Log: Got rid of separate sections for functions permitted and prohibited in partitioning expressions - now we only have a list of those functions which are permitted (as suggested by Giuseppe Maxia) Noted that DIV operator is supported in partitioning expressions (fixes Docs Bug #30188) Modified: trunk/refman-5.1/partitioning.xml trunk/refman-5.1/renamed-nodes.txt trunk/refman-6.0/partitioning.xml trunk/refman-6.0/renamed-nodes.txt Modified: trunk/refman-5.1/partitioning.xml =================================================================== --- trunk/refman-5.1/partitioning.xml 2007-12-12 17:00:41 UTC (rev 9266) +++ trunk/refman-5.1/partitioning.xml 2007-12-12 17:28:41 UTC (rev 9267) Changed blocks: 4, Lines Added: 152, Lines Deleted: 355; 15798 bytes @@ -4358,15 +4358,26 @@ + Nested function calls. For example, while + MOD() and + TO_DAYS() are both permitted in + partitioning expressions, an expression such as + MOD(TO_DAYS(datetime_column), + 7) is not allowed. + + + + + Declared variables or user variables. - For SQL functions which are not permitted in partitioning - expressions, see - . + For a list of SQL functions which are permitted in + partitioning expressions, see + . @@ -4396,6 +4407,8 @@ [LINEAR] KEY partitioning, as discussed elswhere in this chapter — see , for more information). + The DIV operator is also supported. (Bug + #30188) @@ -5198,175 +5211,167 @@ This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning - expressions, including both those function which are - specifically supported for use in partitioning expressions, and - those which are specifically prohibited. + expressions. -
+ + partitioning + functions supported in partitioning expressions + - Functions Supported in Partitioning Expressions + + Beginning with MySQL 5.1.12, only the following MySQL functions + are supported in partitioning expressions: + - - partitioning - functions supported in partitioning expressions - + - - Beginning with MySQL 5.1.12, only the following MySQL - functions are specifically supported in partitioning - expressions: - + + + ABS() + + - + + + CEILING() (see + CEILING() and + FLOOR(), + immediately following this list) + + - - - ABS() - - + + + DAY() + + - - - CEILING() (see - the Note - CEILING() and - FLOOR() - immediately following this list) - - + + + DAYOFMONTH() + + - - - DAY() - - + + + DAYOFWEEK() + + - - - DAYOFMONTH() - - + + + DAYOFYEAR() + + - - - DAYOFWEEK() - - + + + DATEDIFF() + + - - - DAYOFYEAR() - - + + + EXTRACT() + + - - - DATEDIFF() - - + + + FLOOR() (see + CEILING() and + FLOOR(), + immediately following this list) + + - - - EXTRACT() - - + + + HOUR() + + - - - FLOOR() (see the - Note CEILING() - and FLOOR() - immediately following this list) - - + + + MICROSECOND() + + - - - HOUR() - - + + + MINUTE() + + - - - MICROSECOND() - - + + + MOD() + + - - - MINUTE() - - + + + MONTH() + + - - - MOD() - - + + + QUARTER() + + - - - MONTH() - - + + + SECOND() + + - - - QUARTER() - - + + + TIME_TO_SEC() + + - - - SECOND() - - + + + TO_DAYS() + + - - - TIME_TO_SEC() - - + + + WEEKDAY() + + - - - TO_DAYS() - - + + + YEAR() + + - - - WEEKDAY() - - + + + YEARWEEK() + + - - - YEAR() - - + - - - YEARWEEK() - - + + - + <function role="sql">CEILING()</function> and + <function role="sql">FLOOR()</function> - - + + 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: - <function role="sql">CEILING()</function> and - <function role="sql">FLOOR()</function> - - - 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), @@ -5375,221 +5380,13 @@ ERROR 1490 (HY000): The PARTITION function returns the wrong type - See , for more - information about the return types of these functions. - + See , for more + information about the return types of these functions. + - - + + -
- -
- - Functions Not Permitted in Partitioning Expressions - - - partitioning - functions disallowed in partitioning expressions - - - - Beginning with MySQL 5.1.12, the following MySQL functions are - specifically not allowed in partitioning expressions: - - - - - - - ASCII() - - - - - - BIT_COUNT() - - - - - - BIT_LENGTH() - - - - - - CASE - - - - - - CAST() - - - - - - CHAR_LENGTH() - - - - - - CHARACTER_LENGTH() - - - - - - CONVERT() - - - - - - CRC32() - - - - - - FIND_IN_SET() - - - - - - GREATEST() - - - - - - IFNULL() - - - - - - INET_ATON() - - - - - - INSTR() - - - - - - ISNULL() - - - - - - LEAST() - - - - - - LENGTH() - - - - - - LOCATE() - - - - - - NULLIF() - - - - - - OCTET_LENGTH() - - - - - - ORD() - - - - - - PERIOD_ADD() - - - - - - PERIOD_DIFF() - - - - - - POSITION() - - - - - - ROUND() - - - - - - SIGN() - - - - - - STRCMP() - - - - - - TIMESTAMPDIFF() - - - - - - UNIX_TIMESTAMP() - - - - - - WEEK() - - - - - - WEEKOFYEAR() - - - - - -
- Modified: trunk/refman-5.1/renamed-nodes.txt =================================================================== --- trunk/refman-5.1/renamed-nodes.txt 2007-12-12 17:00:41 UTC (rev 9266) +++ trunk/refman-5.1/renamed-nodes.txt 2007-12-12 17:28:41 UTC (rev 9267) Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 878 bytes @@ -317,7 +317,9 @@ os-2 ../../5.0/en/os-2 other-vendor-column-types other-vendor-data-types parentheses operator-precedence -partitioning-limitations-disallowed-functions partitioning-limitations-functions-disallowed +partitioning-limitations-disallowed-functions partitioning-limitations-functions-disallowed 2009-01-01 +partitioning-limitations-functions-supported partitioning-limitations-functions 2009-01-01 +partitioning-limitations-functions-disallowed partitioning-limitations-functions 2009-01-01 performance myodbc-usagenotes-functionality performance-figures mysql-cluster-performance-figures perl-dbi-class perl Modified: trunk/refman-6.0/partitioning.xml =================================================================== --- trunk/refman-6.0/partitioning.xml 2007-12-12 17:00:41 UTC (rev 9266) +++ trunk/refman-6.0/partitioning.xml 2007-12-12 17:28:41 UTC (rev 9267) Changed blocks: 4, Lines Added: 152, Lines Deleted: 354; 15701 bytes @@ -4258,15 +4258,26 @@ + Nested function calls. For example, while + MOD() and + TO_DAYS() are both permitted in + partitioning expressions, an expression such as + MOD(TO_DAYS(datetime_column), + 7) is not allowed. + + + + + Declared variables or user variables. - For SQL functions which are not permitted in partitioning - expressions, see - . + For a list of SQL functions which are permitted in + partitioning expressions, see + . @@ -4296,6 +4307,8 @@ [LINEAR] KEY partitioning, as discussed elswhere in this chapter — see , for more information). + The DIV operator is also supported. (Bug + #30188) @@ -5065,174 +5078,167 @@ This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning - expressions, including both those function which are - specifically supported for use in partitioning expressions, and - those which are specifically prohibited. + expressions. -
+ + partitioning + functions supported in partitioning expressions + - Functions Supported in Partitioning Expressions + + Only the following MySQL functions are supported in partitioning + expressions: + - - partitioning - functions supported in partitioning expressions - + - - Only the following MySQL functions are specifically supported - in partitioning expressions: - + + + ABS() + + - + + + CEILING() (see + CEILING() and + FLOOR(), + immediately following this list) + + - - - ABS() - - + + + DAY() + + - - - CEILING() (see - the Note - CEILING() and - FLOOR() - immediately following this list) - - + + + DAYOFMONTH() + + - - - DAY() - - + + + DAYOFWEEK() + + - - - DAYOFMONTH() - - + + + DAYOFYEAR() + + - - - DAYOFWEEK() - - + + + DATEDIFF() + + - - - DAYOFYEAR() - - + + + EXTRACT() + + - - - DATEDIFF() - - + + + FLOOR() (see + CEILING() and + FLOOR(), + immediately following this list) + + - - - EXTRACT() - - + + + HOUR() + + - - - FLOOR() (see the - Note CEILING() - and FLOOR() - immediately following this list) - - + + + MICROSECOND() + + - - - HOUR() - - + + + MINUTE() + + - - - MICROSECOND() - - + + + MOD() + + - - - MINUTE() - - + + + MONTH() + + - - - MOD() - - + + + QUARTER() + + - - - MONTH() - - + + + SECOND() + + - - - QUARTER() - - + + + TIME_TO_SEC() + + - - - SECOND() - - + + + TO_DAYS() + + - - - TIME_TO_SEC() - - + + + WEEKDAY() + + - - - TO_DAYS() - - + + + YEAR() + + - - - WEEKDAY() - - + + + YEARWEEK() + + - - - YEAR() - - + - - - YEARWEEK() - - + + - + <function role="sql">CEILING()</function> and + <function role="sql">FLOOR()</function> - - + + 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: - <function role="sql">CEILING()</function> and - <function role="sql">FLOOR()</function> - - - 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), @@ -5241,221 +5247,13 @@ ERROR 1490 (HY000): The PARTITION function returns the wrong type - See , for more - information about the return types of these functions. - + See , for more + information about the return types of these functions. + - - + + -
- -
- - Functions Not Permitted in Partitioning Expressions - - - partitioning - functions disallowed in partitioning expressions - - - - The following MySQL functions are specifically not allowed in - partitioning expressions: - - - - - - - ASCII() - - - - - - BIT_COUNT() - - - - - - BIT_LENGTH() - - - - - - CASE - - - - - - CAST() - - - - - - CHAR_LENGTH() - - - - - - CHARACTER_LENGTH() - - - - - - CONVERT() - - - - - - CRC32() - - - - - - FIND_IN_SET() - - - - - - GREATEST() - - - - - - IFNULL() - - - - - - INET_ATON() - - - - - - INSTR() - - - - - - ISNULL() - - - - - - LEAST() - - - - - - LENGTH() - - - - - - LOCATE() - - - - - - NULLIF() - - - - - - OCTET_LENGTH() - - - - - - ORD() - - - - - - PERIOD_ADD() - - - - - - PERIOD_DIFF() - - - - - - POSITION() - - - - - - ROUND() - - - - - - SIGN() - - - - - - STRCMP() - - - - - - TIMESTAMPDIFF() - - - - - - UNIX_TIMESTAMP() - - - - - - WEEK() - - - - - - WEEKOFYEAR() - - - - - -
- Modified: trunk/refman-6.0/renamed-nodes.txt =================================================================== --- trunk/refman-6.0/renamed-nodes.txt 2007-12-12 17:00:41 UTC (rev 9266) +++ trunk/refman-6.0/renamed-nodes.txt 2007-12-12 17:28:41 UTC (rev 9267) Changed blocks: 1, Lines Added: 2, Lines Deleted: 0; 764 bytes @@ -27,6 +27,8 @@ languages error-message-language 2009-01-01 libmysqld-overview libmysqld 2008-03-31 localization internationalization-localization 2009-01-01 +partitioning-limitations-functions-supported partitioning-limitations-functions 2009-01-01 +partitioning-limitations-functions-disallowed partitioning-limitations-functions 2009-01-01 programming-utilities programs-development 2009-01-01 program-overview programs-overview 2009-01-01 replication-features-diffcolumns replication-features 2009-01-01