You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2021/11/17 14:48:00 UTC

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

Istvan Toth created PHOENIX-6596:
------------------------------------

             Summary: 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
            Reporter: Istvan Toth


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