Author: jstephens
Date: 2011-01-26 16:11:31 +0100 (Wed, 26 Jan 2011)
New Revision: 24889
Log:
Partitioning BUG#54483
Add changelog entry
Update list of allowed/not allowed partitioning functions
Modified:
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/refman-5.1/partitioning.xml
trunk/refman-5.5/partitioning.xml
trunk/refman-5.6/partitioning.xml
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2011-01-26 11:38:07 UTC (rev 24888)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2011-01-26 15:11:31 UTC (rev 24889)
Changed blocks: 1, Lines Added: 42, Lines Deleted: 0; 1592 bytes
@@ -9,6 +9,48 @@
<logentry entrytype="bug">
<tags>
+ <highlight type="partitioning"/>
+ <highlight type="importantchange"/>
+ <manual type="DATETIME"/>
+ <manual type="TIMESTAMP"/>
+ <manual type="EXTRACT()"/>
+ <manual type="WEEK"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="54483"/>
+ <seealsobug bugid="57071"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.55"/>
+ <version ver="5.5.9"/>
+ <version ver="5.6.2"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Date and time functions used as partitioning functions now have
+ the types of their operands checked; use of a value of the wrong
+ type is now disallowed in such cases. In addition,
+ <literal role="func">EXTRACT(WEEK FROM col)</literal>, where
+ <replaceable>col</replaceable> is a
+ <literal role="type">DATE</literal> or
+ <literal role="type">DATETIME</literal> column, is now
+ disallowed altogether because its return value depends on the
+ value of the
+ <literal role="sysvar">default_week_format</literal> system
+ variable.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
<highlight type="diskdata"/>
<manual type="DROP LOGFILE GROUP"/>
<manual type="file I/O"/>
Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml 2011-01-26 11:38:07 UTC (rev 24888)
+++ trunk/refman-5.1/partitioning.xml 2011-01-26 15:11:31 UTC (rev 24889)
Changed blocks: 2, Lines Added: 22, Lines Deleted: 1; 1846 bytes
@@ -6140,7 +6140,8 @@
</row>
<row>
<entry><literal role="func">DATEDIFF()</literal></entry>
- <entry><literal role="func">EXTRACT()</literal></entry>
+ <entry><literal role="func">EXTRACT()</literal> (see
+ <xref linkend="partitioning-limitations-extract"/>)</entry>
<entry><literal role="func">FLOOR()</literal> (see
<xref linkend="partitioning-limitations-ceiling-floor"/>)</entry>
</row>
@@ -6206,6 +6207,26 @@
<errortext>ERROR 1490 (HY000): The PARTITION function returns the wrong type</errortext>
</programlisting>
+ <formalpara id="partitioning-limitations-extract">
+
+ <title><literal role="func">EXTRACT()</literal> function with
+ <literal>WEEK</literal> specifier</title>
+
+ <para>
+ The value returned by the
+ <literal role="func">EXTRACT()</literal> function, when used
+ as <literal role="func">EXTRACT(WEEK FROM
+ <replaceable>col</replaceable>)</literal>, depends on the
+ value of the
+ <literal role="sysvar">default_week_format</literal> system
+ variable. For this reason, beginning with MySQL 5.1.55,
+ <literal role="func">EXTRACT()</literal> is longer permitted
+ as a partitioning function when it specifies the unit as
+ <literal>WEEK</literal>. (Bug#54483)
+ </para>
+
+ </formalpara>
+
<para>
See <xref linkend="mathematical-functions"/>, for more
information about the return types of these functions, as well
Modified: trunk/refman-5.5/partitioning.xml
===================================================================
--- trunk/refman-5.5/partitioning.xml 2011-01-26 11:38:07 UTC (rev 24888)
+++ trunk/refman-5.5/partitioning.xml 2011-01-26 15:11:31 UTC (rev 24889)
Changed blocks: 2, Lines Added: 22, Lines Deleted: 1; 1845 bytes
@@ -6875,7 +6875,8 @@
</row>
<row>
<entry><literal role="func">DATEDIFF()</literal></entry>
- <entry><literal role="func">EXTRACT()</literal></entry>
+ <entry><literal role="func">EXTRACT()</literal> (see
+ <xref linkend="partitioning-limitations-extract"/>)</entry>
<entry><literal role="func">FLOOR()</literal> (see
<xref linkend="partitioning-limitations-ceiling-floor"/>)</entry>
</row>
@@ -6942,6 +6943,26 @@
<errortext>ERROR 1490 (HY000): The PARTITION function returns the wrong type</errortext>
</programlisting>
+ <formalpara id="partitioning-limitations-extract">
+
+ <title><literal role="func">EXTRACT()</literal> function with
+ <literal>WEEK</literal> specifier</title>
+
+ <para>
+ The value returned by the
+ <literal role="func">EXTRACT()</literal> function, when used
+ as <literal role="func">EXTRACT(WEEK FROM
+ <replaceable>col</replaceable>)</literal>, depends on the
+ value of the
+ <literal role="sysvar">default_week_format</literal> system
+ variable. For this reason, beginning with MySQL 5.5.9,
+ <literal role="func">EXTRACT()</literal> is longer permitted
+ as a partitioning function when it specifies the unit as
+ <literal>WEEK</literal>. (Bug#54483)
+ </para>
+
+ </formalpara>
+
<para>
See <xref linkend="mathematical-functions"/>, for more
information about the return types of these functions, as well
Modified: trunk/refman-5.6/partitioning.xml
===================================================================
--- trunk/refman-5.6/partitioning.xml 2011-01-26 11:38:07 UTC (rev 24888)
+++ trunk/refman-5.6/partitioning.xml 2011-01-26 15:11:31 UTC (rev 24889)
Changed blocks: 2, Lines Added: 22, Lines Deleted: 1; 1845 bytes
@@ -7324,7 +7324,8 @@
</row>
<row>
<entry><literal role="func">DATEDIFF()</literal></entry>
- <entry><literal role="func">EXTRACT()</literal></entry>
+ <entry><literal role="func">EXTRACT()</literal> (see
+ <xref linkend="partitioning-limitations-extract"/>)</entry>
<entry><literal role="func">FLOOR()</literal> (see
<xref linkend="partitioning-limitations-ceiling-floor"/>)</entry>
</row>
@@ -7391,6 +7392,26 @@
<errortext>ERROR 1490 (HY000): The PARTITION function returns the wrong type</errortext>
</programlisting>
+ <formalpara id="partitioning-limitations-extract">
+
+ <title><literal role="func">EXTRACT()</literal> function with
+ <literal>WEEK</literal> specifier</title>
+
+ <para>
+ The value returned by the
+ <literal role="func">EXTRACT()</literal> function, when used
+ as <literal role="func">EXTRACT(WEEK FROM
+ <replaceable>col</replaceable>)</literal>, depends on the
+ value of the
+ <literal role="sysvar">default_week_format</literal> system
+ variable. For this reason, beginning with MySQL 5.6.2,
+ <literal role="func">EXTRACT()</literal> is longer permitted
+ as a partitioning function when it specifies the unit as
+ <literal>WEEK</literal>. (Bug#54483)
+ </para>
+
+ </formalpara>
+
<para>
See <xref linkend="mathematical-functions"/>, for more
information about the return types of these functions, as well
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r24889 - in trunk: dynamic-docs/changelog refman-5.1 refman-5.5 refman-5.6 | jon.stephens | 26 Jan |
