[ https://issues.apache.org/jira/browse/PHOENIX-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xu Cang updated PHOENIX-4647: ----------------------------- Attachment: PHOENIX-4647.4.x-HBase-1.3.002.patch > 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 > Assignee: Xu Cang > Priority: Major > Attachments: PHOENIX-4647.4.x-HBase-1.3.002.patch, > PHOENIX-4647.master.001.patch > > > SUBSTR(NAME, 1) > being rendered as > SUBSTR(NAME, 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)