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)

Reply via email to