Bug #745 incorect outer field resolving in reduced subselect with union
Submitted: 28 Jun 2003 1:22 Modified: 29 Jun 2003 4:47
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (any)
Assigned to: Oleksandr Byelkin

[28 Jun 2003 1:22] Oleksandr Byelkin
Description:
incorect outer field resolving in reduced subselect with union 
(SELECT 1 as a) UNION (SELECT 1) ORDER BY (SELECT a+0)' failed: 1105: Unknown 
error 

How to repeat:
(SELECT 1 as a) UNION (SELECT 1) ORDER BY (SELECT a+0) 

Suggested fix:
fake_select in union should have same item_list which passed to mysql_select
[28 Jun 2003 7:06] Oleksandr Byelkin
ChangeSet 
  1.1544 03/06/28 17:04:26 bell@sanja.is.com.ua +3 -0