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

[paul]

Author: paul
Date: 2007-04-10 18:45:01 +0200 (Tue, 10 Apr 2007)
New Revision: 5803

Log:
 r23076@polar:  paul | 2007-04-10 10:47:22 -0500
 Point out more explicitly that index prefix lengths depend on storage engine.


Modified:
   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
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:23056
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:18854
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:23076
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:18854
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/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2007-04-10 16:27:55 UTC (rev 5802)
+++ trunk/refman-4.1/sql-syntax.xml	2007-04-10 16:45:01 UTC (rev 5803)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 742 bytes

@@ -1245,7 +1245,9 @@
       </para>
 
       <para>
-        Prefixes can be up to 1000 bytes long (767 bytes for
+        Prefix lengths are storage engine-dependent (for example, a
+        prefix can be up to 1000 bytes long for
+        <literal>MyISAM</literal> tables, 767 bytes for
         <literal>InnoDB</literal> tables). (Before MySQL 4.1.2, the
         limit is 255 bytes for all tables.) Note that prefix limits are
         measured in bytes, whereas the prefix length in <literal>CREATE


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2007-04-10 16:27:55 UTC (rev 5802)
+++ trunk/refman-5.0/sql-syntax.xml	2007-04-10 16:45:01 UTC (rev 5803)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 736 bytes

@@ -1279,7 +1279,9 @@
       </para>
 
       <para>
-        Prefixes can be up to 1000 bytes long (767 bytes for
+        Prefix lengths are storage engine-dependent (for example, a
+        prefix can be up to 1000 bytes long for
+        <literal>MyISAM</literal> tables, 767 bytes for
         <literal>InnoDB</literal> tables). Note that prefix limits are
         measured in bytes, whereas the prefix length in <literal>CREATE
         INDEX</literal> statements is interpreted as number of


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-04-10 16:27:55 UTC (rev 5802)
+++ trunk/refman-5.1/sql-syntax.xml	2007-04-10 16:45:01 UTC (rev 5803)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 736 bytes

@@ -1844,7 +1844,9 @@
       </para>
 
       <para>
-        Prefixes can be up to 1000 bytes long (767 bytes for
+        Prefix lengths are storage engine-dependent (for example, a
+        prefix can be up to 1000 bytes long for
+        <literal>MyISAM</literal> tables, 767 bytes for
         <literal>InnoDB</literal> tables). Note that prefix limits are
         measured in bytes, whereas the prefix length in <literal>CREATE
         INDEX</literal> statements is interpreted as number of