Bug #32051 UNION within EXISTS returns incorrect result
| Submitted: | 2 Nov 2007 11:36 | Modified: | 9 Jan 2008 14:24 |
|---|---|---|---|
| Reporter: | Chris Bacon | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.45, 5.1.22 | OS: | Windows (XP) |
| Assigned to: | Georgi Kodinov | CPU Architecture: | Any |
| Tags: | bad result, exists, UNION | ||
[2 Nov 2007 11:36]
Chris Bacon
[2 Nov 2007 14:10]
Hartmut Holzgraefe
mysqltest test case
Attachment: bug32051.tgz (application/x-gtar, text), 807 bytes.
[26 Nov 2007 14:09]
Georgi Kodinov
Fixed by the fix for bug #32036
[9 Jan 2008 14:24]
Paul DuBois
Noted in 5.0.54, 5.1.23, 6.0.5 changelogs. Within a subquery, UNION was handled differently than at the top level, which could result in incorrect results or a server crash.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.