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
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1
• OS: Any (all)
• 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