Author: jstephens
Date: 2007-05-30 17:27:32 +0200 (Wed, 30 May 2007)
New Revision: 6607
Log:
Documented change in I_S.*_STATUS|VARIABLES table definitions
See Bug#26994 and WL#3823
Modified:
trunk/refman-5.1/information-schema.xml
trunk/refman-5.1/news-5.1.xml
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2007-05-30 15:19:01 UTC (rev 6606)
+++ trunk/refman-5.1/information-schema.xml 2007-05-30 15:27:32 UTC (rev 6607)
Changed blocks: 2, Lines Added: 22, Lines Deleted: 4; 1729 bytes
@@ -5530,10 +5530,13 @@
<listitem>
<para>
- The <literal>VARIABLE_VALUE</literal> column has the
- <literal>BIGINT</literal> type. The few status variables that
- have non-integer values are coerced to
- <literal>BIGINT</literal> values.
+ Beginning with MySQL 5.1.19, the
+ <literal>VARIABLE_VALUE</literal> column for each of these
+ tables is defined as <literal>VARCHAR(20480)</literal>.
+ Previously, this column had the data type
+ <literal>DECIMAL(22,7)</literal>, but was changed to avoid
+ loss of data when working with status variables whose values
+ were strings (Bug #26994).
</para>
</listitem>
@@ -5604,6 +5607,21 @@
MySQL 5.1.12.
</para>
</listitem>
+
+ <listitem>
+ <para>
+ Beginning with MySQL 5.1.19, the
+ <literal>VARIABLE_VALUE</literal> column for each of these
+ tables is defined as <literal>VARCHAR(20480)</literal>.
+ Previously, this column had the data type
+ <literal>LONGTEXT</literal>; this was changed in order to
+ make these tables consistent with the
+ <literal>GLOBAL_STATUS</literal> and
+ <literal>SESSION_STATUS</literal> tables, whose definitions
+ had been changed in that version (see
+ <xref linkend="status-table"/>).
+ </para>
+ </listitem>
</itemizedlist>
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2007-05-30 15:19:01 UTC (rev 6606)
+++ trunk/refman-5.1/news-5.1.xml 2007-05-30 15:27:32 UTC (rev 6607)
Changed blocks: 1, Lines Added: 34, Lines Deleted: 0; 1384 bytes
@@ -84,6 +84,40 @@
TABLES</literal>. (Bug #26241)
</para>
</listitem>
+
+ <listitem>
+ <para>
+ The data type used for the <literal>VARIABLE_VALUE</literal>
+ column of the following INFORMATION_SCHEMA tables has been
+ changed to <literal>VARCHAR</literal>:
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ <literal>GLOBAL_STATUS</literal>
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>SESSION_STATUS</literal>
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>GLOBAL_VARIABLES</literal>
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>SESSION_VARIABLES</literal>
+ </para>
+ </listitem>
+ </itemizedlist>
+
+ For more information, see <xref linkend="status-table"/>,
+ <xref linkend="variables-table"/>, and Bug #26994
+ </para>
+ </listitem>
</itemizedlist>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6607 - trunk/refman-5.1 | jon | 30 May |
