[PHOENIX-6917] Column alias not working properly in Python

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: python-phoenixdb-1.2.1
• Fix Version/s: python-phoenixdb-1.2.2
• Component/s: python, queryserver
• Release Note: If the JDBC column label is set, phoenixdb now uses it as the python DB2 API column description name field, and uses it as the key for DictCursor.
• Assignee: Satya Kommula
• Reporter: Satya Kommula
• Created: 30/Mar/23 17:38
• Updated: 02/May/24 07:20
• Resolved: 13/Apr/23 07:57

Description

Get the columnLabel (the “as name”) rather than the columnName with a cursor.

calcite 💎:sql> select c1 as hello, c2 as world from int_tbl;
+-------------+-------------+
| c1          | c2          |
|-------------+-------------|
| 5           | 0           |
| -123        | 123         |
| 1           | 123456      |
| -123456     | -123456     |
| 10          | 50          |
| -2147483648 | 1           |
| 2147483647  | -2147483648 |
| <null>      | 10          |
| <null>      | <null>      |
| 1           | 1           |
+-------------+-------------+

 

Issue Links

• relates to: PHOENIX-6920 PhoenixResultSetMetaData doesn't distinguish between label and column_name
• links to: GitHub Pull Request #124