Author: paul
Date: 2008-08-01 22:32:03 +0200 (Fri, 01 Aug 2008)
New Revision: 11474
Log:
r33184@frost: paul | 2008-08-01 15:33:02 -0500
Document bugfix:
Bug#37761: IN handles NULL differently for table-subquery and value-list
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:33157
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:32656
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:33184
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:32656
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-08-01 19:04:12 UTC (rev 11473)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-08-01 20:32:03 UTC (rev 11474)
Changed blocks: 1, Lines Added: 34, Lines Deleted: 0; 1065 bytes
@@ -23557,4 +23557,38 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="optimizer"/>
+ <manual type="NOT IN"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="37761"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.28"/>
+ <version ver="6.0.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The server returned unexpected results if a right side of the
+ <literal>NOT IN</literal> clause consisted of the
+ <literal>NULL</literal> value and some constants of the same
+ type. For example, this query might return 3, 4, 5, and so forth
+ if a table contained those values:
+ </para>
+
+<programlisting>
+SELECT * FROM t WHERE NOT t.id IN (NULL, 1, 2);
+</programlisting>
+
+ </message>
+
+ </logentry>
+
</changelog>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r11474 - in trunk: . dynamic-docs/changelog | paul.dubois | 1 Aug |
