[jira] [Commented] (PHOENIX-6596) Schema extraction double quotes expressions, resulting in un-executabe create statements

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

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

ASF GitHub Bot commented on PHOENIX-6596:
-----------------------------------------

richardantal merged pull request #1364:
URL: https://github.com/apache/phoenix/pull/1364


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@phoenix.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Schema extraction double quotes expressions, resulting in un-executabe create statements
> ----------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-6596
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6596
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.17.0, 5.2.0, 4.16.2, 5.1.3
>            Reporter: Istvan Toth
>            Assignee: Richárd Antal
>            Priority: Major
>
> {noformat}
> create table data (id varchar primary key, number integer,currency decimal(6,2),
> lista varchar[]);
> create index data_index on data (currency*number) INCLUDE (LISTA);
> show create table data_index;
> +-----------------------------------------------------------------------------+
> |                              CREATE STATEMENT                               |
> +-----------------------------------------------------------------------------+
> | CREATE INDEX DATA_INDEX ON DATA("(CURRENCY * NUMBER)", ID) INCLUDE (LISTA)  |
> +-----------------------------------------------------------------------------+
> {noformat}
> The create statement double quotes the expression, and cannot be executed directly.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)