Author: paul
Date: 2006-02-07 18:49:39 +0100 (Tue, 07 Feb 2006)
New Revision: 1225
Log:
r2880@kite-hub: paul | 2006-02-06 14:08:36 -0600
ORDER BY within parens for individual SELECTs in UNION is not supported.
(Bug#11877)
Modified:
trunk/
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7186
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2879
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7186
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2880
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2006-02-07 17:49:23 UTC (rev 1224)
+++ trunk/refman-4.1/sql-syntax.xml 2006-02-07 17:49:39 UTC (rev 1225)
@@ -7433,25 +7433,11 @@
</programlisting>
<para>
- To apply <literal>ORDER BY</literal> or
- <literal>LIMIT</literal> to an individual
- <literal>SELECT</literal>, place the clause inside the
- parentheses that enclose the <literal>SELECT</literal>:
+ Applying <literal>ORDER BY</literal> inside parentheses to an
+ individual <literal>SELECT</literal> is not supported because
+ it is not standard SQL.
</para>
-<programlisting>
-(SELECT a FROM <replaceable>tbl_name</replaceable> WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
-UNION
-(SELECT a FROM <replaceable>tbl_name</replaceable> WHERE a=11 AND B=2 ORDER BY a LIMIT 10);
-</programlisting>
-
- <para>
- <literal>ORDER BY</literal> for individual
- <literal>SELECT</literal> statements within parentheses has an
- effect only when combined with <literal>LIMIT</literal>.
- Otherwise, the <literal>ORDER BY</literal> is optimized away.
- </para>
-
<remark>
this is also written in the "known bugs" section
</remark>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-02-07 17:49:23 UTC (rev 1224)
+++ trunk/refman-5.0/sql-syntax.xml 2006-02-07 17:49:39 UTC (rev 1225)
@@ -7824,25 +7824,11 @@
</programlisting>
<para>
- To apply <literal>ORDER BY</literal> or
- <literal>LIMIT</literal> to an individual
- <literal>SELECT</literal>, place the clause inside the
- parentheses that enclose the <literal>SELECT</literal>:
+ Applying <literal>ORDER BY</literal> inside parentheses to an
+ individual <literal>SELECT</literal> is not supported because
+ it is not standard SQL.
</para>
-<programlisting>
-(SELECT a FROM <replaceable>tbl_name</replaceable> WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
-UNION
-(SELECT a FROM <replaceable>tbl_name</replaceable> WHERE a=11 AND B=2 ORDER BY a LIMIT 10);
-</programlisting>
-
- <para>
- <literal>ORDER BY</literal> for individual
- <literal>SELECT</literal> statements within parentheses has an
- effect only when combined with <literal>LIMIT</literal>.
- Otherwise, the <literal>ORDER BY</literal> is optimized away.
- </para>
-
<remark>
this is also written in the "known bugs" section
</remark>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-02-07 17:49:23 UTC (rev 1224)
+++ trunk/refman-5.1/sql-syntax.xml 2006-02-07 17:49:39 UTC (rev 1225)
@@ -8405,25 +8405,11 @@
</programlisting>
<para>
- To apply <literal>ORDER BY</literal> or
- <literal>LIMIT</literal> to an individual
- <literal>SELECT</literal>, place the clause inside the
- parentheses that enclose the <literal>SELECT</literal>:
+ Applying <literal>ORDER BY</literal> inside parentheses to an
+ individual <literal>SELECT</literal> is not supported because
+ it is not standard SQL.
</para>
-<programlisting>
-(SELECT a FROM <replaceable>tbl_name</replaceable> WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
-UNION
-(SELECT a FROM <replaceable>tbl_name</replaceable> WHERE a=11 AND B=2 ORDER BY a LIMIT 10);
-</programlisting>
-
- <para>
- <literal>ORDER BY</literal> for individual
- <literal>SELECT</literal> statements within parentheses has an
- effect only when combined with <literal>LIMIT</literal>.
- Otherwise, the <literal>ORDER BY</literal> is optimized away.
- </para>
-
<remark>
this is also written in the "known bugs" section
</remark>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1225 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 7 Feb |
