You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Shehzaad Nakhoda (JIRA)" <ji...@apache.org> on 2018/03/09 08:35:00 UTC
[jira] [Created] (PHOENIX-4647) Column header doesn't handle
optional arguments correctly
Shehzaad Nakhoda created PHOENIX-4647:
-----------------------------------------
Summary: Column header doesn't handle optional arguments correctly
Key: PHOENIX-4647
URL: https://issues.apache.org/jira/browse/PHOENIX-4647
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.14.0
Reporter: Shehzaad Nakhoda
SUBSTR(NAME, 1)
being rendered as
SUBSTR(NAME, 1, 1)
in things like column headings.
For example:
0: jdbc:phoenix:> create table hello_table (ID DECIMAL PRIMARY KEY, NAME VARCHAR);
No rows affected (1.252 seconds)
0: jdbc:phoenix:> upsert into hello_table values(1, 'abc');
1 row affected (0.025 seconds)
0: jdbc:phoenix:> select substr(name, 1) from hello_table;
+--------------------+
| SUBSTR(NAME, 1, ) |
+--------------------+
| abc |
+--------------------+
Looks to me like there's a bug -
SUBSTR(NAME, 1) should be represented as SUBSTR(NAME, 1) not as SUBSTR(NAME, 1, )
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)