List:Commits« Previous MessageNext Message »
From:jon Date:December 12 2007 5:28pm
Subject:svn commit - mysqldoc@docsrva: r9267 - in trunk: refman-5.1 refman-6.0
View as plain text  
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 @@
 
               <listitem>
                 <para>
+                  Nested function calls. For example, while
+                  <literal>MOD()</literal> and
+                  <literal>TO_DAYS()</literal> are both permitted in
+                  partitioning expressions, an expression such as
+                  <literal>MOD(TO_DAYS(<replaceable>datetime_column</replaceable>),
+                  7)</literal> is not allowed.
+                </para>
+              </listitem>
+
+              <listitem>
+                <para>
                   Declared variables or user variables.
                 </para>
               </listitem>
 
             </itemizedlist>
 
-            For SQL functions which are not permitted in partitioning
-            expressions, see
-            <xref linkend="partitioning-limitations-functions-disallowed"/>.
+            For a list of SQL functions which are permitted in
+            partitioning expressions, see
+            <xref linkend="partitioning-limitations-functions"/>.
           </para>
 
         </formalpara>

@@ -4396,6 +4407,8 @@
             <literal>[LINEAR] KEY</literal> partitioning, as discussed
             elswhere in this chapter &mdash; see
             <xref linkend="partitioning-types"/>, for more information).
+            The <literal>DIV</literal> operator is also supported. (Bug
+            #30188)
           </para>
 
         </formalpara>

@@ -5198,175 +5211,167 @@
       <para>
         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.
       </para>
 
-      <section id="partitioning-limitations-functions-supported">
+      <indexterm>
+        <primary>partitioning</primary>
+        <secondary>functions supported in partitioning expressions</secondary>
+      </indexterm>
 
-        <title>Functions Supported in Partitioning Expressions</title>
+      <para>
+        Beginning with MySQL 5.1.12, only the following MySQL functions
+        are supported in partitioning expressions:
+      </para>
 
-        <indexterm>
-          <primary>partitioning</primary>
-          <secondary>functions supported in partitioning expressions</secondary>
-        </indexterm>
+      <itemizedlist>
 
-        <para>
-          Beginning with MySQL 5.1.12, only the following MySQL
-          functions are specifically supported in partitioning
-          expressions:
-        </para>
+        <listitem>
+          <para>
+            <function role="sql">ABS()</function>
+          </para>
+        </listitem>
 
-        <itemizedlist>
+        <listitem>
+          <para>
+            <function role="sql">CEILING()</function> (see
+            <citetitle><function role="sql">CEILING()</function> and
+            <function role="sql">FLOOR()</function></citetitle>,
+            immediately following this list)
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">ABS()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAY()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">CEILING()</function> (<emphasis>see
-              the Note
-              <citetitle><function role="sql">CEILING()</function> and
-              <function role="sql">FLOOR()</function></citetitle>
-              immediately following this list</emphasis>)
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAYOFMONTH()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAY()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAYOFWEEK()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAYOFMONTH()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAYOFYEAR()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAYOFWEEK()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DATEDIFF()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAYOFYEAR()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">EXTRACT()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DATEDIFF()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">FLOOR()</function> (see
+            <citetitle><function role="sql">CEILING()</function> and
+            <function role="sql">FLOOR()</function></citetitle>,
+            immediately following this list)
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">EXTRACT()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">HOUR()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">FLOOR()</function> (<emphasis>see the
-              Note <citetitle><function role="sql">CEILING()</function>
-              and <function role="sql">FLOOR()</function></citetitle>
-              immediately following this list</emphasis>)
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MICROSECOND()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">HOUR()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MINUTE()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MICROSECOND()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MOD()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MINUTE()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MONTH()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MOD()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">QUARTER()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MONTH()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">SECOND()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">QUARTER()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <literal>TIME_TO_SEC()</literal>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">SECOND()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <literal>TO_DAYS()</literal>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <literal>TIME_TO_SEC()</literal>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">WEEKDAY()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <literal>TO_DAYS()</literal>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">YEAR()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">WEEKDAY()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">YEARWEEK()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">YEAR()</function>
-            </para>
-          </listitem>
+      </itemizedlist>
 
-          <listitem>
-            <para>
-              <function role="sql">YEARWEEK()</function>
-            </para>
-          </listitem>
+      <note>
+        <formalpara>
 
-        </itemizedlist>
+          <title><function role="sql">CEILING()</function> and
+            <function role="sql">FLOOR()</function></title>
 
-        <note>
-          <formalpara>
+          <para>
+            Each of these functions returns an integer only if it is
+            passed an integer argument. This means, for example, that
+            the following <literal>CREATE TABLE</literal> statement
+            fails with an error, as shown here:
 
-            <title><function role="sql">CEILING()</function> and
-              <function role="sql">FLOOR()</function></title>
-
-            <para>
-              Each of these functions returns an integer only if it is
-              passed an integer argument. This means, for example, that
-              the following <literal>CREATE TABLE</literal> statement
-              fails with an error, as shown here:
-
 <programlisting>
 mysql&gt; <userinput>CREATE TABLE t (c FLOAT) PARTITION BY LIST( FLOOR(c) )(</userinput>
     -&gt;     <userinput>PARTITION p0 VALUES IN (1,3,5),</userinput>

@@ -5375,221 +5380,13 @@
 <errortext>ERROR 1490 (HY000): The PARTITION function returns the wrong type</errortext> 
 </programlisting>
 
-              See <xref linkend="mathematical-functions"/>, for more
-              information about the return types of these functions.
-            </para>
+            See <xref linkend="mathematical-functions"/>, for more
+            information about the return types of these functions.
+          </para>
 
-          </formalpara>
-        </note>
+        </formalpara>
+      </note>
 
-      </section>
-
-      <section id="partitioning-limitations-functions-disallowed">
-
-        <title>Functions Not Permitted in Partitioning Expressions</title>
-
-        <indexterm>
-          <primary>partitioning</primary>
-          <secondary>functions disallowed in partitioning expressions</secondary>
-        </indexterm>
-
-        <para>
-          Beginning with MySQL 5.1.12, the following MySQL functions are
-          specifically not allowed in partitioning expressions:
-        </para>
-
-        <itemizedlist>
-
-          <listitem>
-            <para>
-              <function role="sql">ASCII()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">BIT_COUNT()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">BIT_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sqlop">CASE</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CAST()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CHAR_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CHARACTER_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CONVERT()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CRC32()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">FIND_IN_SET()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">GREATEST()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">IFNULL()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">INET_ATON()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">INSTR()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">ISNULL()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">LEAST()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">LOCATE()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">NULLIF()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">OCTET_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">ORD()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">PERIOD_ADD()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">PERIOD_DIFF()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">POSITION()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">ROUND()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">SIGN()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">STRCMP()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">TIMESTAMPDIFF()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">UNIX_TIMESTAMP()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">WEEK()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">WEEKOFYEAR()</function>
-            </para>
-          </listitem>
-
-        </itemizedlist>
-
-      </section>
-
     </section>
 
   </section>


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 @@
 
               <listitem>
                 <para>
+                  Nested function calls. For example, while
+                  <literal>MOD()</literal> and
+                  <literal>TO_DAYS()</literal> are both permitted in
+                  partitioning expressions, an expression such as
+                  <literal>MOD(TO_DAYS(<replaceable>datetime_column</replaceable>),
+                  7)</literal> is not allowed.
+                </para>
+              </listitem>
+
+              <listitem>
+                <para>
                   Declared variables or user variables.
                 </para>
               </listitem>
 
             </itemizedlist>
 
-            For SQL functions which are not permitted in partitioning
-            expressions, see
-            <xref linkend="partitioning-limitations-functions-disallowed"/>.
+            For a list of SQL functions which are permitted in
+            partitioning expressions, see
+            <xref linkend="partitioning-limitations-functions"/>.
           </para>
 
         </formalpara>

@@ -4296,6 +4307,8 @@
             <literal>[LINEAR] KEY</literal> partitioning, as discussed
             elswhere in this chapter &mdash; see
             <xref linkend="partitioning-types"/>, for more information).
+            The <literal>DIV</literal> operator is also supported. (Bug
+            #30188)
           </para>
 
         </formalpara>

@@ -5065,174 +5078,167 @@
       <para>
         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.
       </para>
 
-      <section id="partitioning-limitations-functions-supported">
+      <indexterm>
+        <primary>partitioning</primary>
+        <secondary>functions supported in partitioning expressions</secondary>
+      </indexterm>
 
-        <title>Functions Supported in Partitioning Expressions</title>
+      <para>
+        Only the following MySQL functions are supported in partitioning
+        expressions:
+      </para>
 
-        <indexterm>
-          <primary>partitioning</primary>
-          <secondary>functions supported in partitioning expressions</secondary>
-        </indexterm>
+      <itemizedlist>
 
-        <para>
-          Only the following MySQL functions are specifically supported
-          in partitioning expressions:
-        </para>
+        <listitem>
+          <para>
+            <function role="sql">ABS()</function>
+          </para>
+        </listitem>
 
-        <itemizedlist>
+        <listitem>
+          <para>
+            <function role="sql">CEILING()</function> (see
+            <citetitle><function role="sql">CEILING()</function> and
+            <function role="sql">FLOOR()</function></citetitle>,
+            immediately following this list)
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">ABS()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAY()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">CEILING()</function> (<emphasis>see
-              the Note
-              <citetitle><function role="sql">CEILING()</function> and
-              <function role="sql">FLOOR()</function></citetitle>
-              immediately following this list</emphasis>)
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAYOFMONTH()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAY()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAYOFWEEK()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAYOFMONTH()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DAYOFYEAR()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAYOFWEEK()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">DATEDIFF()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DAYOFYEAR()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">EXTRACT()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">DATEDIFF()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">FLOOR()</function> (see
+            <citetitle><function role="sql">CEILING()</function> and
+            <function role="sql">FLOOR()</function></citetitle>,
+            immediately following this list)
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">EXTRACT()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">HOUR()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">FLOOR()</function> (<emphasis>see the
-              Note <citetitle><function role="sql">CEILING()</function>
-              and <function role="sql">FLOOR()</function></citetitle>
-              immediately following this list</emphasis>)
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MICROSECOND()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">HOUR()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MINUTE()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MICROSECOND()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MOD()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MINUTE()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">MONTH()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MOD()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">QUARTER()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">MONTH()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">SECOND()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">QUARTER()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <literal>TIME_TO_SEC()</literal>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">SECOND()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <literal>TO_DAYS()</literal>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <literal>TIME_TO_SEC()</literal>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">WEEKDAY()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <literal>TO_DAYS()</literal>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">YEAR()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">WEEKDAY()</function>
-            </para>
-          </listitem>
+        <listitem>
+          <para>
+            <function role="sql">YEARWEEK()</function>
+          </para>
+        </listitem>
 
-          <listitem>
-            <para>
-              <function role="sql">YEAR()</function>
-            </para>
-          </listitem>
+      </itemizedlist>
 
-          <listitem>
-            <para>
-              <function role="sql">YEARWEEK()</function>
-            </para>
-          </listitem>
+      <note>
+        <formalpara>
 
-        </itemizedlist>
+          <title><function role="sql">CEILING()</function> and
+            <function role="sql">FLOOR()</function></title>
 
-        <note>
-          <formalpara>
+          <para>
+            Each of these functions returns an integer only if it is
+            passed an integer argument. This means, for example, that
+            the following <literal>CREATE TABLE</literal> statement
+            fails with an error, as shown here:
 
-            <title><function role="sql">CEILING()</function> and
-              <function role="sql">FLOOR()</function></title>
-
-            <para>
-              Each of these functions returns an integer only if it is
-              passed an integer argument. This means, for example, that
-              the following <literal>CREATE TABLE</literal> statement
-              fails with an error, as shown here:
-
 <programlisting>
 mysql&gt; <userinput>CREATE TABLE t (c FLOAT) PARTITION BY LIST( FLOOR(c) )(</userinput>
     -&gt;     <userinput>PARTITION p0 VALUES IN (1,3,5),</userinput>

@@ -5241,221 +5247,13 @@
 <errortext>ERROR 1490 (HY000): The PARTITION function returns the wrong type</errortext> 
 </programlisting>
 
-              See <xref linkend="mathematical-functions"/>, for more
-              information about the return types of these functions.
-            </para>
+            See <xref linkend="mathematical-functions"/>, for more
+            information about the return types of these functions.
+          </para>
 
-          </formalpara>
-        </note>
+        </formalpara>
+      </note>
 
-      </section>
-
-      <section id="partitioning-limitations-functions-disallowed">
-
-        <title>Functions Not Permitted in Partitioning Expressions</title>
-
-        <indexterm>
-          <primary>partitioning</primary>
-          <secondary>functions disallowed in partitioning expressions</secondary>
-        </indexterm>
-
-        <para>
-          The following MySQL functions are specifically not allowed in
-          partitioning expressions:
-        </para>
-
-        <itemizedlist>
-
-          <listitem>
-            <para>
-              <function role="sql">ASCII()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">BIT_COUNT()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">BIT_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sqlop">CASE</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CAST()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CHAR_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CHARACTER_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CONVERT()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">CRC32()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">FIND_IN_SET()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">GREATEST()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">IFNULL()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">INET_ATON()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">INSTR()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">ISNULL()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">LEAST()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">LOCATE()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">NULLIF()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">OCTET_LENGTH()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">ORD()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">PERIOD_ADD()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">PERIOD_DIFF()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">POSITION()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">ROUND()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">SIGN()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">STRCMP()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">TIMESTAMPDIFF()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">UNIX_TIMESTAMP()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">WEEK()</function>
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <function role="sql">WEEKOFYEAR()</function>
-            </para>
-          </listitem>
-
-        </itemizedlist>
-
-      </section>
-
     </section>
 
   </section>


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


Thread
svn commit - mysqldoc@docsrva: r9267 - in trunk: refman-5.1 refman-6.0jon12 Dec