Bug #4980 union statement with () union () order by produces wrong explain
Submitted: 10 Aug 2004 19:17 Modified: 3 Sep 2004 17:00
Reporter: Matthew Lord Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.x OS:Any (all)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[10 Aug 2004 19:17] Matthew Lord 
Description:
I was able to repeat this problem on 4.0.20 and 4.0.18 on x86 linux and windows 2000.
The explain output has 9 rows, an extra 3 rows are added to the explain output by the final
order by clause.

How to repeat:
Run the query posted in the developer notes.  You can also see the full thread in the customer 
support center, #3206.

Suggested fix:
See 4.1.3 explain.
[24 Aug 2004 12:15] Ramil Kalimullin 
ChangeSet
  1.1981 04/08/24 15:10:51 ram@gw.mysql.r18.ru
[3 Sep 2004 17:00] Ramil Kalimullin 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html