svn commit - mysqldoc@docsrva: r5152 - in trunk: . refman-4.1 refman-5.0 refman-5.1

[paul]

Author: paul
Date: 2007-03-02 20:18:55 +0100 (Fri, 02 Mar 2007)
New Revision: 5152

Log:
 r20851@polar:  paul | 2007-03-02 13:16:15 -0600
 Some of SergeyP's recent work lifts a subquery limitation.


Modified:
   trunk/refman-4.1/restrictions.xml
   trunk/refman-5.0/restrictions.xml
   trunk/refman-5.1/restrictions.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:20850
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16997
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:20851
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16997
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593


Modified: trunk/refman-4.1/restrictions.xml
===================================================================
--- trunk/refman-4.1/restrictions.xml	2007-03-02 19:18:17 UTC (rev 5151)
+++ trunk/refman-4.1/restrictions.xml	2007-03-02 19:18:55 UTC (rev 5152)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 5; 1083 bytes

@@ -35,14 +35,13 @@
 
       <listitem>
         <para>
-          Known bug to be fixed later: If you compare a
-          <literal>NULL</literal> value to a subquery using
-          <literal>ALL</literal>, <literal>ANY</literal>, or
-          <literal>SOME</literal>, and the subquery returns an empty
+          Known bug: If you compare a <literal>NULL</literal> value to a
+          subquery using <literal>ALL</literal>,
<literal>ANY</literal>,
+          or <literal>SOME</literal>, and the subquery returns an empty
           result, the comparison might evaluate to the non-standard
           result of <literal>NULL</literal> rather than to
           <literal>TRUE</literal> or <literal>FALSE</literal>.
This is
-          to be fixed in MySQL 5.1.
+          fixed in MySQL 5.0.36 and 5.1.16.
         </para>
       </listitem>
 


Modified: trunk/refman-5.0/restrictions.xml
===================================================================
--- trunk/refman-5.0/restrictions.xml	2007-03-02 19:18:17 UTC (rev 5151)
+++ trunk/refman-5.0/restrictions.xml	2007-03-02 19:18:55 UTC (rev 5152)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 620 bytes

@@ -391,7 +391,7 @@
 
       <listitem>
         <para>
-          Known bug to be fixed later: If you compare a
+          In MySQL &current-series; before 5.0.36, if you compare a
           <literal>NULL</literal> value to a subquery using
           <literal>ALL</literal>, <literal>ANY</literal>, or
           <literal>SOME</literal>, and the subquery returns an empty


Modified: trunk/refman-5.1/restrictions.xml
===================================================================
--- trunk/refman-5.1/restrictions.xml	2007-03-02 19:18:17 UTC (rev 5151)
+++ trunk/refman-5.1/restrictions.xml	2007-03-02 19:18:55 UTC (rev 5152)
Changed blocks: 4, Lines Added: 29, Lines Deleted: 29; 2617 bytes

@@ -279,10 +279,9 @@
     </itemizedlist>
 
     <formalpara>
+
       <title>Stored routines and triggers in MySQL Cluster</title>
 
-
-
       <para>
         Stored functions, stored procedures, and triggers are all
         supported by tables using the <literal>NDB</literal> storage

@@ -337,6 +336,7 @@
           </para>
         </warning>
       </para>
+
     </formalpara>
 
   </section>

@@ -434,7 +434,7 @@
 
       <listitem>
         <para>
-          Known bug to be fixed later: If you compare a
+          In MySQL &current-series; before 5.1.16, if you compare a
           <literal>NULL</literal> value to a subquery using
           <literal>ALL</literal>, <literal>ANY</literal>, or
           <literal>SOME</literal>, and the subquery returns an empty

@@ -1112,41 +1112,41 @@
 
   </section>
 
-<section id="limits">
+  <section id="limits">
 
-  <title>Limits in MySQL</title>
+    <title>Limits in MySQL</title>
 
-  <indexterm>
-    <primary>limitations</primary>
-    <secondary>MySQL Limitations</secondary>
-  </indexterm>
+    <indexterm>
+      <primary>limitations</primary>
+      <secondary>MySQL Limitations</secondary>
+    </indexterm>
 
-  <indexterm>
-    <primary>limits</primary>
-    <secondary>MySQL Limits, limits in MySQL</secondary>
-  </indexterm>
-
-  <para>
-    This section lists current limits in MySQL &current-series;.
-  </para>
-
-  <section id="joins-limits">
-
-    <title>Limits of Joins</title>
-
     <indexterm>
-      <primary>maximums</primary>
-      <secondary>maximum tables per join</secondary>
+      <primary>limits</primary>
+      <secondary>MySQL Limits, limits in MySQL</secondary>
     </indexterm>
 
     <para>
-      The maximum number of tables that can be referenced in a single
-      join is 61. This also applies to the number of tables that can be
-      referenced in the definition of a view.
+      This section lists current limits in MySQL &current-series;.
     </para>
 
+    <section id="joins-limits">
+
+      <title>Limits of Joins</title>
+
+      <indexterm>
+        <primary>maximums</primary>
+        <secondary>maximum tables per join</secondary>
+      </indexterm>
+
+      <para>
+        The maximum number of tables that can be referenced in a single
+        join is 61. This also applies to the number of tables that can
+        be referenced in the definition of a view.
+      </para>
+
+    </section>
+
   </section>
 
-</section>
-
 </appendix>