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>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7072 - in trunk: . mysqlqb refman-5.2 | paul | 10 Jul |
