Author: jstephens
Date: 2009-10-24 13:36:44 +0200 (Sat, 24 Oct 2009)
New Revision: 17307
Log:
Fixes Docs Bug #48054
Modified:
trunk/refman-5.1/partitioning.xml
trunk/refman-5.4/partitioning.xml
trunk/refman-5.5/partitioning.xml
trunk/refman-6.0.sav/partitioning.xml
Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml 2009-10-24 10:25:15 UTC (rev 17306)
+++ trunk/refman-5.1/partitioning.xml 2009-10-24 11:36:44 UTC (rev 17307)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 4; 947 bytes
@@ -4450,12 +4450,13 @@
the number of partitions. Consider this query:
<programlisting>
-SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 8;
+SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 12;
</programlisting>
- The range in the <literal>WHERE</literal> clause covers 5 values
- (4, 5, 6, 7, 8), but <literal>t4</literal> has only 4
- partitions. This means that the previous query cannot be pruned.
+ The range in the <literal>WHERE</literal> clause covers 9 values
+ (4, 5, 6, 7, 8, 9, 10, 11, 12), but <literal>t4</literal> has
+ only 8 partitions. This means that the previous query cannot be
+ pruned.
</para>
</important>
Modified: trunk/refman-5.4/partitioning.xml
===================================================================
--- trunk/refman-5.4/partitioning.xml 2009-10-24 10:25:15 UTC (rev 17306)
+++ trunk/refman-5.4/partitioning.xml 2009-10-24 11:36:44 UTC (rev 17307)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 4; 947 bytes
@@ -4294,12 +4294,13 @@
the number of partitions. Consider this query:
<programlisting>
-SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 8;
+SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 12;
</programlisting>
- The range in the <literal>WHERE</literal> clause covers 5 values
- (4, 5, 6, 7, 8), but <literal>t4</literal> has only 4
- partitions. This means that the previous query cannot be pruned.
+ The range in the <literal>WHERE</literal> clause covers 9 values
+ (4, 5, 6, 7, 8, 9, 10, 11, 12), but <literal>t4</literal> has
+ only 8 partitions. This means that the previous query cannot be
+ pruned.
</para>
</important>
Modified: trunk/refman-5.5/partitioning.xml
===================================================================
--- trunk/refman-5.5/partitioning.xml 2009-10-24 10:25:15 UTC (rev 17306)
+++ trunk/refman-5.5/partitioning.xml 2009-10-24 11:36:44 UTC (rev 17307)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 4; 947 bytes
@@ -4294,12 +4294,13 @@
the number of partitions. Consider this query:
<programlisting>
-SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 8;
+SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 12;
</programlisting>
- The range in the <literal>WHERE</literal> clause covers 5 values
- (4, 5, 6, 7, 8), but <literal>t4</literal> has only 4
- partitions. This means that the previous query cannot be pruned.
+ The range in the <literal>WHERE</literal> clause covers 9 values
+ (4, 5, 6, 7, 8, 9, 10, 11, 12), but <literal>t4</literal> has
+ only 8 partitions. This means that the previous query cannot be
+ pruned.
</para>
</important>
Modified: trunk/refman-6.0.sav/partitioning.xml
===================================================================
--- trunk/refman-6.0.sav/partitioning.xml 2009-10-24 10:25:15 UTC (rev 17306)
+++ trunk/refman-6.0.sav/partitioning.xml 2009-10-24 11:36:44 UTC (rev 17307)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 4; 959 bytes
@@ -4271,12 +4271,13 @@
the number of partitions. Consider this query:
<programlisting>
-SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 8;
+SELECT * FROM t4 WHERE region_code BETWEEN 4 AND 12;
</programlisting>
- The range in the <literal>WHERE</literal> clause covers 5 values
- (4, 5, 6, 7, 8), but <literal>t4</literal> has only 4
- partitions. This means that the previous query cannot be pruned.
+ The range in the <literal>WHERE</literal> clause covers 9 values
+ (4, 5, 6, 7, 8, 9, 10, 11, 12), but <literal>t4</literal> has
+ only 8 partitions. This means that the previous query cannot be
+ pruned.
</para>
</important>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r17307 - in trunk: refman-5.1 refman-5.4 refman-5.5 refman-6.0.sav | jon.stephens | 24 Oct |