Bug #111 Crashing with UNION's and sub-select in ORDER BY
Submitted: 1 Mar 2003 9:42 Modified: 1 Mar 2003 9:42
Reporter: SINISA MILIVOJEVIC Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1 OS:Any (all)
Assigned to: CPU Architecture:Any

[1 Mar 2003 9:42] SINISA MILIVOJEVIC
Description:
Any UNION with braces and sub-select in ORDER BY would crash due  to two UNIT's 
present in the UNION.

How to repeat:
(select *  from table1) UNION (select * from table2) order by (select a from table3)

Suggested fix:
A longish patch