[PHOENIX-6365] Bogus AmbiguousTableException in query with aliases on local indexed tables

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.1.0, 4.16.0
• Component/s: core

Release Note

Phoenix now follows the SQL standard when handling table aliases (correlation names). The aliased tables can no longer be referenced by their unaliased name.
I.e. queries like "select t.c from t as a" will no longer be accepted, and have to be rewritten as "select a.c from t as a"

• Assignee: Istvan Toth
• Reporter: Istvan Toth
• Created: 05/Feb/21 14:11
• Updated: 24/Oct/22 08:09

Description

Certain queries with aliases on tbales with local indexes throw AmbiguousTableException

Issue Links

• is caused by: PHOENIX-5109 Allow local indexes to work for queries with uncovered columns.
• links to: GitHub Pull Request #1133
• links to: GitHub Pull Request #1292