List:Commits« Previous MessageNext Message »
From:jon.stephens Date:May 17 2011 3:54pm
Subject:svn commit - mysqldoc@oter02: r26252 - trunk/refman-5.1
View as plain text  
Author: js221926
Date: 2011-05-17 17:54:08 +0200 (Tue, 17 May 2011)
New Revision: 26252

Log:

Improve ndb_join_pushdown description (Thanks, Jonas!)





Modified:
   trunk/refman-5.1/mysql-cluster-configuration-core.xml


Modified: trunk/refman-5.1/mysql-cluster-configuration-core.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-configuration-core.xml	2011-05-17 13:22:52 UTC (rev 26251)
+++ trunk/refman-5.1/mysql-cluster-configuration-core.xml	2011-05-17 15:54:08 UTC (rev 26252)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 13; 1883 bytes

@@ -10909,27 +10909,26 @@
 
             <listitem>
               <para>
-                Only fully or partially qualified primary keys or
-                indexes are supported for access to child tables.
+                In order for a join to be pushed down, child tables in
+                the join must be accessed using one of the
+                <literal role="jointype">ref</literal>,
+                <literal role="jointype">eq_ref</literal>, or 
+                <literal role="jointype">const</literal> access methods,
+                or some combination of these methods. This means that
+                every column referenced in the join must be a primary
+                key or other index, or part of one.
               </para>
             </listitem>
 
             <listitem>
               <para>
-                Queries making up the join may use only the
-                <literal role="jointype">eq_ref</literal> or 
-                <literal role="jointype">const</literal> access method
-                (or both methods).
+                Joins referencing tables explicitly partitioned by
+                <literal>[LINEAR] HASH</literal>,
+                <literal>LIST</literal>, or <literal>RANGE</literal>
+                currently cannot be pushed down.
               </para>
             </listitem>
 
-            <listitem>
-              <para>
-                Joins referencing user-partitioned tables currently
-                cannot be pushed down.
-              </para>
-            </listitem>
-
           </itemizedlist>
 
           <para>


Thread
svn commit - mysqldoc@oter02: r26252 - trunk/refman-5.1jon.stephens17 May