List:Commits« Previous MessageNext Message »
From:jon.stephens Date:January 26 2011 3:11pm
Subject:svn commit - mysqldoc@docsrva: r24889 - in trunk: dynamic-docs/changelog refman-5.1 refman-5.5 refman-5.6
View as plain text  
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.6jon.stephens26 Jan