Bug #112 UNION's with ORDER BY and a sub-select with a table in ORDER BY

• Submitted: 1 Mar 2003 9:47
• Modified: 10 Mar 2003 15:46
• Reporter: SINISA MILIVOJEVIC
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1
• OS: Any (all)
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[1 Mar 2003 9:47] SINISA MILIVOJEVIC

Description:
if ORDER BY has subselect with a table, and it is used with UNION with braces then  Mysql server will crash.

This is due to the fact that table in ORDER BY does not get linked in where it
is necessary in create_total_table_lsit

How to repeat:
(select * from ...) UNION (select * from ..) ORDER BY (select a from table)