Bug #442 Unknown error with UNION and ORDER BY with subquery
Submitted: 17 May 2003 11:07 Modified: 29 Jun 2003 4:49
Reporter: jocelyn fournier (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.1 OS:Linux (linux)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[17 May 2003 11:07] jocelyn fournier 
Description:
This following query fails :

How to repeat:
(SELECT 1 as a) UNION (SELECT 1) ORDER BY (SELECT a+0);
ERROR 1105: Unknown error
[19 May 2003 5:39] Oleksandr Byelkin 
hangeSet 
  1.1541 03/05/19 15:32:38 bell@sanja.is.com.ua +3 -0
[29 Jun 2003 4:49] Oleksandr Byelkin 
Thank you for bugreport. Bug is now fixed.