From: Date: July 10 2007 9:46pm
Subject: svn commit - mysqldoc@docsrva: r7072 - in trunk: . mysqlqb refman-5.2
List-Archive: http://lists.mysql.com/commits/30632
Message-Id: <200707101946.l6AJkVbi017177@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: paul
Date: 2007-07-10 21:46:29 +0200 (Tue, 10 Jul 2007)
New Revision: 7072

Log:
 r27506@polar:  paul | 2007-07-10 14:44:40 -0500
 Table/column comments now can be up to 2048/1024 characters.
 Indexes now can have comments of up to 1024 characters.
 (WL#3736)
 
 Started 5.2.4 changelog section.
 Added "fake" section for 5.2.1 - 5.2.3 to point reader to Falcon
 changelogs for those version numbers.
 Removed 5.2.0 changelog section. It was empty.


Modified:
   trunk/mysqlqb/Makefile.depends
   trunk/refman-5.2/Makefile.depends
   trunk/refman-5.2/news-5.2.xml
   trunk/refman-5.2/sql-syntax.xml

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


Modified: trunk/mysqlqb/Makefile.depends
===================================================================
--- trunk/mysqlqb/Makefile.depends	2007-07-10 19:45:42 UTC (rev 7071)
+++ trunk/mysqlqb/Makefile.depends	2007-07-10 19:46:29 UTC (rev 7072)
Changed blocks: 4, Lines Added: 8, Lines Deleted: 4; 2584 bytes

@@ -37,13 +37,15 @@
 	../refman-5.0/metadata/se-merge.idmap \
 	../refman-5.0/metadata/se-myisam.idmap \
 	../refman-5.0/metadata/spatial-extensions.idmap \
+	../refman-5.0/metadata/sql-syntax.idmap \
 	../refman-5.0/metadata/storage-engines.idmap \
 	../refman-5.0/metadata/stored-procedures.idmap \
 	../refman-5.0/metadata/triggers.idmap \
 	../refman-5.0/metadata/tutorial.idmap \
 	../refman-5.0/metadata/views.idmap \
 	../refman-common/metadata/bug-reports.idmap \
-	../refman-common/metadata/credits.idmap
+	../refman-common/metadata/credits.idmap \
+	../refman-common/metadata/regexp.idmap
 mysqlqb.validpure: $(mysqlqb_SOURCES)
 mysqlqb.titles: $(mysqlqb_SOURCES)
 mysqlqb.useless: $(mysqlqb_SOURCES)

@@ -73,10 +75,11 @@
 	../refman-5.0/metadata/language-structure.idmap \
 	../refman-5.0/metadata/optimization.idmap \
 	../refman-5.0/metadata/precision-math.idmap \
+	../refman-5.0/metadata/sql-syntax.idmap \
 	../refman-5.0/metadata/stored-procedures.idmap \
 	../refman-5.0/metadata/tutorial.idmap \
 	../refman-common/metadata/credits.idmap \
-	metadata/mysqlqb_statements.idmap
+	../refman-common/metadata/regexp.idmap
 mysqlqb_functions.validpure: $(mysqlqb_functions_SOURCES)
 mysqlqb_functions.titles: $(mysqlqb_functions_SOURCES)
 mysqlqb_functions.useless: $(mysqlqb_functions_SOURCES)

@@ -103,6 +106,7 @@
 	../refman-5.0/metadata/dba-core.idmap \
 	../refman-5.0/metadata/errors-problems.idmap \
 	../refman-5.0/metadata/extending-mysql.idmap \
+	../refman-5.0/metadata/functions-core.idmap \
 	../refman-5.0/metadata/information-schema.idmap \
 	../refman-5.0/metadata/installing-cs.idmap \
 	../refman-5.0/metadata/introduction.idmap \

@@ -121,13 +125,13 @@
 	../refman-5.0/metadata/se-merge.idmap \
 	../refman-5.0/metadata/se-myisam.idmap \
 	../refman-5.0/metadata/spatial-extensions.idmap \
+	../refman-5.0/metadata/sql-syntax.idmap \
 	../refman-5.0/metadata/storage-engines.idmap \
 	../refman-5.0/metadata/stored-procedures.idmap \
 	../refman-5.0/metadata/triggers.idmap \
 	../refman-5.0/metadata/tutorial.idmap \
 	../refman-5.0/metadata/views.idmap \
-	../refman-common/metadata/bug-reports.idmap \
-	metadata/mysqlqb_functions.idmap
+	../refman-common/metadata/bug-reports.idmap
 mysqlqb_statements.validpure: $(mysqlqb_statements_SOURCES)
 mysqlqb_statements.titles: $(mysqlqb_statements_SOURCES)
 mysqlqb_statements.useless: $(mysqlqb_statements_SOURCES)


Modified: trunk/refman-5.2/Makefile.depends
===================================================================
--- trunk/refman-5.2/Makefile.depends	2007-07-10 19:45:42 UTC (rev 7071)
+++ trunk/refman-5.2/Makefile.depends	2007-07-10 19:46:29 UTC (rev 7072)
Changed blocks: 3, Lines Added: 2, Lines Deleted: 2; 1436 bytes

@@ -465,7 +465,6 @@
 dynxml_generated_dba_IMAGES =
 dynxml_generated_dba_SOURCES = dynxml-generated-dba.xml $(dynxml_generated_dba_INCLUDES)
 dynxml_generated_dba_IDMAPS = \
-	../refman-5.0/metadata/replication.idmap \
 	../refman-common/metadata/bug-reports.idmap \
 	../refman-common/metadata/information-sources.idmap \
 	metadata/apis-c.idmap \

@@ -1093,13 +1092,13 @@
 	images/rolling-restarts.png
 manual_SOURCES = manual.xml $(manual_INCLUDES)
 manual_IDMAPS = \
+	../falcon/metadata/news-falcon.idmap \
 	../falcon/metadata/se-falcon.idmap \
 	../ndbapi/metadata/errors.idmap \
 	../ndbapi/metadata/ndb-internals.idmap \
 	../refman-4.1/metadata/introduction.idmap \
 	../refman-4.1/metadata/mysql-cluster.idmap \
 	../refman-4.1/metadata/sql-syntax.idmap \
-	../refman-5.0/metadata/replication.idmap \
 	../refman-5.1/metadata/introduction.idmap \
 	../refman-5.1/metadata/news-5.1.idmap \
 	../refman-common/metadata/gpl-license.idmap \

@@ -1180,6 +1179,7 @@
 news_5_2_IMAGES =
 news_5_2_SOURCES = news-5.2.xml $(news_5_2_INCLUDES)
 news_5_2_IDMAPS = \
+	../falcon/metadata/news-falcon.idmap \
 	metadata/introduction.idmap
 news-5.2.validpure: $(news_5_2_SOURCES)
 news-5.2.titles: $(news_5_2_SOURCES)


Modified: trunk/refman-5.2/news-5.2.xml
===================================================================
--- trunk/refman-5.2/news-5.2.xml	2007-07-10 19:45:42 UTC (rev 7071)
+++ trunk/refman-5.2/news-5.2.xml	2007-07-10 19:46:29 UTC (rev 7072)
Changed blocks: 3, Lines Added: 25, Lines Deleted: 6; 1985 bytes

@@ -30,17 +30,17 @@
     <filename>refman-common</filename> directory.
   </remark>
 
-  <section id="news-5-2-0">
+  <section id="news-5-2-4">
 
-    <title>Changes in release 5.2.0 (Not yet released)</title>
+    <title>Changes in release 5.2.4 (Not yet released: Alpha)</title>
 
     <para role="release-level">
-      This is a new Beta development release, fixing recently discovered
-      bugs.
+      This is a new Alpha development release, fixing recently
+      discovered bugs.
     </para>
 
     <para role="release-non-production">
-      <emphasis role="bold">NOTE:</emphasis> This Beta release, as any
+      <emphasis role="bold">NOTE:</emphasis> This Alpha release, as any
       other pre-production release, should not be installed on
       <emphasis>production</emphasis> level systems or systems with
       critical data. It is good practice to back up your data before

@@ -62,16 +62,24 @@
       <ulink url="http://www.mysql.com/network/advisors.html"/>.
     </para>
 
-<!--
     <para>
       Functionality added or changed:
     </para>
 
     <itemizedlist>
 
+      <listitem>
+        <para>
+          The maximum length of table comments was extended from 60 to
+          2048 characters. The maximum length of column comments was
+          extended from 255 to 1024 characters. Index definitions now
+          can include a comment of up to 1024 characters.
+        </para>
+      </listitem>
 
     </itemizedlist>
 
+<!--
     <para>
       Bugs fixed:
     </para>

@@ -83,4 +91,15 @@
 
   </section>
 
+  <section id="news-5-2-1">
+
+    <title>Changes in releases 5.2.1 to 5.2.3</title>
+
+    <para>
+      Version numbers 5.2.1 through 5.2.3 were used for Falcon releases.
+      See <xref linkend="news-falcon-5-2"/>.
+    </para>
+
+  </section>
+
 </section>


Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml	2007-07-10 19:45:42 UTC (rev 7071)
+++ trunk/refman-5.2/sql-syntax.xml	2007-07-10 19:46:29 UTC (rev 7072)
Changed blocks: 7, Lines Added: 23, Lines Deleted: 6; 2876 bytes

@@ -1748,7 +1748,7 @@
       <remark role="help-topic" condition="CREATE INDEX"/>
 
       <remark role="help-keywords">
-        BTREE RTREE INDEX CREATE FULLTEXT SPATIAL WITH PARSER
+        BTREE RTREE INDEX CREATE FULLTEXT SPATIAL WITH PARSER COMMENT
       </remark>
 
       <remark role="help-syntax"/>

@@ -1769,6 +1769,7 @@
     KEY_BLOCK_SIZE <replaceable>value</replaceable>
   | <replaceable>index_type</replaceable>
   | WITH PARSER <replaceable>parser_name</replaceable>
+  | COMMENT '<replaceable>string</replaceable>'
 </programlisting>
 
       <remark role="help-description-begin"/>

@@ -2161,6 +2162,13 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            As of MySQL 5.2.4, index definitions can include an optional
+            comment of up to 1024 characters.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
     </section>

@@ -2497,6 +2505,7 @@
     KEY_BLOCK_SIZE <replaceable>value</replaceable>
   | <replaceable>index_type</replaceable>
   | WITH PARSER <replaceable>parser_name</replaceable>
+  | COMMENT '<replaceable>string</replaceable>'
 
 <replaceable>reference_definition</replaceable>:
     REFERENCES <replaceable>tbl_name</replaceable> [(<replaceable>index_col_name</replaceable>,...)]

@@ -2883,10 +2892,10 @@
             </indexterm>
 
             A comment for a column can be specified with the
-            <literal>COMMENT</literal> option, up to 255 characters
-            long. The comment is displayed by the <literal>SHOW CREATE
-            TABLE</literal> and <literal>SHOW FULL COLUMNS</literal>
-            statements.
+            <literal>COMMENT</literal> option, up to 1024 characters
+            long (255 characters before MySQL 5.2.4). The comment is
+            displayed by the <literal>SHOW CREATE TABLE</literal> and
+            <literal>SHOW FULL COLUMNS</literal> statements.
           </para>
         </listitem>
 

@@ -3177,6 +3186,13 @@
 
         <listitem>
           <para>
+            As of MySQL 5.2.4, index definitions can include an optional
+            comment of up to 1024 characters.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             <literal>InnoDB</literal> tables support checking of foreign
             key constraints. See <xref linkend="innodb"/>. Note that the
             <literal>FOREIGN KEY</literal> syntax in

@@ -3477,7 +3493,8 @@
           </para>
 
           <para>
-            A comment for the table, up to 60 characters long.
+            A comment for the table, up to 2048 characters long. (Before
+            5.2.4, the limit is 60 characters.)
           </para>
         </listitem>