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 — 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> <userinput>CREATE TABLE t (c FLOAT) PARTITION BY LIST( FLOOR(c) )(</userinput>
-> <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 — 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> <userinput>CREATE TABLE t (c FLOAT) PARTITION BY LIST( FLOOR(c) )(</userinput>
-> <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.0 | jon | 12 Dec |
