Author: paul
Date: 2006-05-31 21:43:53 +0200 (Wed, 31 May 2006)
New Revision: 2242
Log:
r10871@frost: paul | 2006-05-31 14:27:54 -0500
Point out the SHOW STATUS incompatibility (5.0.2 and up) in:
- 5.0.2 change log
- Upgrading-to-5.0 section
- SHOW STATUS section
(Bug#19093)
Modified:
trunk/
trunk/refman-5.0/installing.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-common/news-5.0.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:10169
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10834
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:7663
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:10169
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10871
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:7663
Modified: trunk/refman-5.0/installing.xml
===================================================================
--- trunk/refman-5.0/installing.xml 2006-05-31 15:07:15 UTC (rev 2241)
+++ trunk/refman-5.0/installing.xml 2006-05-31 19:43:53 UTC (rev 2242)
@@ -12665,6 +12665,22 @@
<listitem>
<para>
+ <emphasis role="bold">Incompatible change:</emphasis> Before
+ MySQL 5.0.2, <literal>SHOW STATUS</literal> returned global
+ status values. The default as of 5.0.2 is to return session
+ values, which is incompatible with previous versions. To
+ issue a <literal>SHOW STATUS</literal> statement that will
+ retrieve global status values for all versions of MySQL,
+ write it like this:
+ </para>
+
+<programlisting>
+SHOW /*!50002 GLOBAL */ STATUS;
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
Some keywords are reserved in MySQL ¤t-series; that
were not reserved in MySQL &previous-series;. See
<xref linkend="reserved-words"/>.
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-05-31 15:07:15 UTC (rev 2241)
+++ trunk/refman-5.0/sql-syntax.xml 2006-05-31 19:43:53 UTC (rev 2242)
@@ -17592,6 +17592,20 @@
<literal>SESSION</literal>.
</para>
+ <para>
+ <emphasis role="bold">Note</emphasis>: Before MySQL 5.0.2,
+ <literal>SHOW STATUS</literal> returned global status values.
+ Because the default as of 5.0.2 is to return session values,
+ this is incompatible with previous versions. To issue a
+ <literal>SHOW STATUS</literal> statement that will retrieve
+ global status values for all versions of MySQL, write it like
+ this:
+ </para>
+
+<programlisting>
+SHOW /*!50002 GLOBAL */ STATUS;
+</programlisting>
+
<remark role="help-description-end"/>
</section>
Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml 2006-05-31 15:07:15 UTC (rev 2241)
+++ trunk/refman-common/news-5.0.xml 2006-05-31 19:43:53 UTC (rev 2242)
@@ -14027,10 +14027,25 @@
<listitem>
<para>
- <literal>SHOW STATUS</literal> now shows the thread specific
- status variables and <literal>SHOW GLOBAL STATUS</literal>
- shows the status variables for the whole server.
+ <emphasis role="bold">Warning: Incompatible change!</emphasis>
+ <literal>SHOW STATUS</literal> now shows the session
+ (thread-specific) status variables and <literal>SHOW GLOBAL
+ STATUS</literal> shows the status variables for the whole
+ server.
</para>
+
+ <para>
+ Before MySQL 5.0.2, <literal>SHOW STATUS</literal> returned
+ global status values. Because the default as of 5.0.2 is to
+ return session values, this is incompatible with previous
+ versions. To issue a <literal>SHOW STATUS</literal> statement
+ that will retrieve global status values for all versions of
+ MySQL, write it like this:
+ </para>
+
+<programlisting>
+SHOW /*!50002 GLOBAL */ STATUS;
+</programlisting>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2242 - in trunk: . refman-5.0 refman-common | paul | 31 May |
