[
https://issues.apache.org/jira/browse/PHOENIX-6917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17708226#comment-17708226
]
ASF GitHub Bot commented on PHOENIX-6917:
-----------------------------------------
stoty commented on code in PR #124:
URL:
https://github.com/apache/phoenix-queryserver/pull/124#discussion_r1156746971
##########
python-phoenixdb/phoenixdb/tests/dbapi20.py:
##########
@@ -832,3 +832,18 @@ def test_ROWID(self):
self.assertTrue(hasattr(self.driver,'ROWID'),
'module.ROWID must be defined.'
)
+
+ # https://issues.apache.org/jira/browse/PHOENIX-6917
+ def test_alias(self):
+ con = self._connect()
+ try:
+ cur = con.cursor()
+ self.executeDDL2(cur)
+ cur.execute("CREATE TABLE IF NOT EXISTS STOCK_SYMBOL (SYMBOL
VARCHAR NOT NULL PRIMARY KEY, COMPANY VARCHAR)")
+ cur.execute("UPSERT INTO STOCK_SYMBOL VALUES ('CRM','SALESFORCE')")
+ cur.execute("UPSERT INTO STOCK_SYMBOL VALUES ('AAPL','APPLE Inc')")
+ cur.execute("SELECT symbol as symb, company as comp FROM
STOCK_SYMBOL")
+ self.assertEqual(cur.description[0][0], 'SYMB')
Review Comment:
Confirm that you can get the results via cur['SYMB'] and cur['COMP']
> Column alias not working properly
> ---------------------------------
>
> Key: PHOENIX-6917
> URL: https://issues.apache.org/jira/browse/PHOENIX-6917
> Project: Phoenix
> Issue Type: Bug
> Components: python, queryserver
> Affects Versions: python-phoenixdb-1.2.1
> Reporter: Satya Kommula
> Assignee: Satya Kommula
> Priority: Major
> Fix For: python-phoenixdb-1.2.2
>
>
> Get the columnLabel (the “as name”) rather than the columnName with a cursor.
> {code:java}
> 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 |
> +-------------+-------------+{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
