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)