Details
Major Description
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) |
+-----------------------------------------------------------------------------+
The create statement double quotes the expression, and cannot be executed directly.