phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shehzaad Nakhoda (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-4647) Column header doesn't handle optional arguments correctly
Date Fri, 09 Mar 2018 10:47:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Shehzaad Nakhoda updated PHOENIX-4647:
--------------------------------------
    Description: 
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, )

  was:
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, )


> 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, )
> 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)

Mime
View raw message