[jira] [Created] (IGNITE-10602) Failure parsing INLINE_SIZE if CREATE INDEX is one of multiple statements

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-10602) Failure parsing INLINE_SIZE if CREATE INDEX is one of multiple statements

Anton Vinogradov (Jira)
Ilya Kasnacheev created IGNITE-10602:
----------------------------------------

             Summary: Failure parsing INLINE_SIZE if CREATE INDEX is one of multiple statements
                 Key: IGNITE-10602
                 URL: https://issues.apache.org/jira/browse/IGNITE-10602
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.7
            Reporter: Ilya Kasnacheev


On an empty cluster issue the following statements (shown using sqlline):
{code}
0: jdbc:ignite:thin://localhost> CREATE TABLE public.transactions (pk INT, id INT, k
. . . . . . . . . . . . . . . .> VARCHAR, v VARCHAR, PRIMARY KEY (pk, id)); CREATE INDEX transactions_id_k_v ON public.transactions (id, k, v) INLINE_SIZE 150; CREATE INDEX transactions_k_v_id ON
. . . . . . . . . . . . . . . .> public.transactions (k, v, id) INLINE_SIZE 150; CREATE INDEX transactions_pk_id ON public.transactions
. . . . . . . . . . . . . . . .> (pk, id) INLINE_SIZE 20;
{code}
Expected: Table is created, three indexes are created.
Actual: table is created, indexes are NOT created, error is printed:
{{Error: Failed to parse query. Синтаксическая ошибка в выражении SQL "CREATE INDEX TRANSACTIONS_ID_K_V ON PUBLIC.TRANSACTIONS (ID, K, V) INLINE_SIZE[*] 150; CREATE INDEX TRANSACTIONS_K_V_ID ON}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)