Author: paul
Date: 2007-03-19 15:25:35 +0100 (Mon, 19 Mar 2007)
New Revision: 5454
Log:
r17943@frost: paul | 2007-03-19 09:24:45 -0500
Update Bug#24532 changelog entry.
Modified:
trunk/refman-5.0/releasenotes-es-5.0.xml
trunk/refman-5.1/installing.xml
trunk/refman-5.1/news-5.1.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:21582
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:17940
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:21582
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:17943
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/refman-5.0/releasenotes-es-5.0.xml
===================================================================
--- trunk/refman-5.0/releasenotes-es-5.0.xml 2007-03-19 13:47:57 UTC (rev 5453)
+++ trunk/refman-5.0/releasenotes-es-5.0.xml 2007-03-19 14:25:35 UTC (rev 5454)
Changed blocks: 1, Lines Added: 22, Lines Deleted: 10; 2304 bytes
@@ -256,17 +256,29 @@
<listitem>
<para>
- Predicates of the form <literal>IS [NOT]
- {TRUE|FALSE}</literal> were evaluated to a result with a data
- type of <literal>INT(2)</literal>, not
- <literal>INT(1)</literal> as for other comparisons. This has
- been corrected, but for views there is an implication:
- Existing views that use the affected construct will continue
- to return <literal>INT(2)</literal> values. If this is an
- issue, drop the view and create it again from the original
- definition (do not create it again by using the output of
- <literal>SHOW CREATE VIEW</literal>). (Bug #24532)
+ IF(<replaceable>expr</replaceable>,
+ <replaceable>unsigned_expr</replaceable>,
+ <replaceable>unsigned_expr</replaceable>) was evaluated to a
+ signed result, not unsigned. This has been corrected. The fix
+ also affects constructs of the form <literal>IS [NOT]
+ {TRUE|FALSE}</literal>, which were transformed internally into
+ <literal>IF()</literal> expressions that evaluated to a signed
+ result. (Bug #24532)
</para>
+
+ <para>
+ For existing views that were defined using <literal>IS [NOT]
+ {TRUE|FALSE}</literal> constructs, there is a related
+ implication. The definitions of such views were stored using
+ the <literal>IF()</literal> expression, not the original
+ construct. This is manifest in that <literal>SHOW CREATE
+ VIEW</literal> shows the transformed <literal>IF()</literal>
+ expression, not the original one. Existing views will evaluate
+ correctly after the fix, but if you want <literal>SHOW CREATE
+ VIEW</literal> to display the original construct, you must
+ drop the view and re-create it using its original definition.
+ New views will retain the construct in their definition.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/installing.xml
===================================================================
--- trunk/refman-5.1/installing.xml 2007-03-19 13:47:57 UTC (rev 5453)
+++ trunk/refman-5.1/installing.xml 2007-03-19 14:25:35 UTC (rev 5454)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 704 bytes
@@ -12169,7 +12169,7 @@
As of MySQL 5.1.9, the <command>mysqld-max</command> server is
included in binary distributions. There is no separate
MySQL-Max distribution. As of MySQL 5.1.12, binary
- distributions include a server that includes the features
+ distributions contain a server that includes the features
previously included in <command>mysqld-max</command>.
</para>
</listitem>
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2007-03-19 13:47:57 UTC (rev 5453)
+++ trunk/refman-5.1/news-5.1.xml 2007-03-19 14:25:35 UTC (rev 5454)
Changed blocks: 1, Lines Added: 22, Lines Deleted: 10; 2271 bytes
@@ -343,17 +343,29 @@
<listitem>
<para>
- Predicates of the form <literal>IS [NOT]
- {TRUE|FALSE}</literal> were evaluated to a result with a data
- type of <literal>INT(2)</literal>, not
- <literal>INT(1)</literal> as for other comparisons. This has
- been corrected, but for views there is an implication:
- Existing views that use the affected construct will continue
- to return <literal>INT(2)</literal> values. If this is an
- issue, drop the view and create it again from the original
- definition (do not create it again by using the output of
- <literal>SHOW CREATE VIEW</literal>). (Bug #24532)
+ IF(<replaceable>expr</replaceable>,
+ <replaceable>unsigned_expr</replaceable>,
+ <replaceable>unsigned_expr</replaceable>) was evaluated to a
+ signed result, not unsigned. This has been corrected. The fix
+ also affects constructs of the form <literal>IS [NOT]
+ {TRUE|FALSE}</literal>, which were transformed internally into
+ <literal>IF()</literal> expressions that evaluated to a signed
+ result. (Bug #24532)
</para>
+
+ <para>
+ For existing views that were defined using <literal>IS [NOT]
+ {TRUE|FALSE}</literal> constructs, there is a related
+ implication. The definitions of such views were stored using
+ the <literal>IF()</literal> expression, not the original
+ construct. This is manifest in that <literal>SHOW CREATE
+ VIEW</literal> shows the transformed <literal>IF()</literal>
+ expression, not the original one. Existing views will evaluate
+ correctly after the fix, but if you want <literal>SHOW CREATE
+ VIEW</literal> to display the original construct, you must
+ drop the view and re-create it using its original definition.
+ New views will retain the construct in their definition.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5454 - in trunk: . refman-5.0 refman-5.1 | paul | 19 Mar |
