You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2018/09/24 15:30:03 UTC

[jira] [Commented] (PHOENIX-4647) Column header doesn't handle optional arguments correctly

    [ https://issues.apache.org/jira/browse/PHOENIX-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16626004#comment-16626004 ] 

Hudson commented on PHOENIX-4647:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-omid2 #89 (See [https://builds.apache.org/job/Phoenix-omid2/89/])
PHOENIX-4647 Column header doesn't handle optional arguments correctly (tdsilva: rev 913a85576aa9d0d7903b584d46c41af16dcee3af)
* (edit) phoenix-core/src/test/java/org/apache/phoenix/util/TestUtil.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/function/SubstrFunction.java
* (edit) phoenix-core/src/test/java/org/apache/phoenix/compile/WhereOptimizerTest.java


> 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
>             Fix For: 4.15.0, 5.1.0
>
>         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)