[
https://issues.apache.org/jira/browse/PHOENIX-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16392580#comment-16392580
]
Shehzaad Nakhoda commented on PHOENIX-4647:
-------------------------------------------
[~jamestaylor] - the jira you requested.
> 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
> Priority: Major
>
> 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)
