[PHOENIX-3749] ERROR 502 (42702): Column reference ambiguous when order by duplicate names

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.8.0
• Fix Version/s: 4.9.0

Environment

CentOS6 JDK1.7.0_79
x86_64

• Assignee: Unassigned
• Reporter: chen weihua
• Created: 22/Mar/17 05:58
• Updated: 04/Apr/17 07:44
• Resolved: 04/Apr/17 07:44

Description

Tableau generates queries that alias a fully-qualified column name to its shortened name.
Similar to:
select room_id, sum(error_code403) as error_code403
from dla_node_main
group by room_id
order by error_code403

Phoenix reports:
Error: ERROR 502 (42702): Column reference ambiguous or duplicate names. columnName=ERROR_CODE403
SQLState: 42702
ErrorCode: 502