You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Kuznetsov (JIRA)" <ji...@apache.org> on 2019/02/07 20:24:00 UTC
[jira] [Comment Edited] (IGNITE-10602) Failure parsing INLINE_SIZE
if CREATE INDEX is one of multiple statements
[ https://issues.apache.org/jira/browse/IGNITE-10602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16763054#comment-16763054 ]
Pavel Kuznetsov edited comment on IGNITE-10602 at 2/7/19 8:23 PM:
------------------------------------------------------------------
[~vozerov] Now parser has method for the last parsed statement. It returns sql text corresponding to the sql cmd {{nextCommand}} has returned.
Also, our native parser is currently just skips empty statements, but h2 sends empty results. But now we are always using h2 for the empty statements (due to "^" in the check regex).
Native parser returns "CMD" as lastSqlStatement and never "CMD;"
Scheduled the tests, could you please take a look at the patch?
was (Author: pkouznet):
[~vozerov] Now parser has method for the last parsed statement. It returns sql text corresponding to the sql cmd {{nextCommand}} has returned.
Also, our native parser is currently just skips empty statements, but h2 sends empty results. But now we are always using h2 for the empty statements (due to "^" in the check regex).
Native parser returns "CMD" as lastSqlStatement and never "CMD;"
> 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
> Assignee: Pavel Kuznetsov
> Priority: Minor
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)