[PHOENIX-6920] PhoenixResultSetMetaData doesn't distinguish between label and column_name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.2.0, 5.1.4
• Component/s: core
• Release Note: Phoenix now correctly returns the unialiased column name in ResultSetMetadata.getColumnName().
• Assignee: Aron Attila Meszaros
• Reporter: Istvan Toth
• Created: 05/Apr/23 12:09
• Updated: 12/Dec/23 18:44
• Resolved: 14/Sep/23 06:34

Description

While debugging PHOENIX-6917, I found that we receive the aliased column name in both the column_name and label fields of the column metadata in protobuf.

This happened with PQS head and Phoenix 5.2.0-SNAPSHOT.
Apparently, some older version used to work correctly (and returned the unaliased name in column_name)

We need to check if this is a Phoenix or Avatica regression first, then fix it in the appropriate project.

Issue Links

• causes: PHOENIX-7147 conn.getMetaData().getCatalogs() returns incorrect column name
• is related to: PHOENIX-6917 Column alias not working properly in Python
• relates to: PHOENIX-7030 Proper handling of isCaseSensitive in ResultSetMetaData
• relates to: PHOENIX-7148 Use getColumnLabel Instead of getColumnName in QueryServerBasicsIT
• links to: GitHub Pull Request #1665