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
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1
• OS: Any (any)
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[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 [e-mail] +3 -0