ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ignite TC Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-10602) Failure parsing INLINE_SIZE if CREATE INDEX is one of multiple statements
Date Mon, 04 Feb 2019 22:31:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-10602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16760271#comment-16760271
] 

Ignite TC Bot commented on IGNITE-10602:
----------------------------------------

{panel:title=-&gt; Run :: SQL: Possible Blockers|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Queries 1{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=2999293]]
* IgniteBinaryCacheQueryTestSuite: IgniteCheckClusterStateBeforeExecuteQueryTest.testDynamicSchemaChangesPersistence
- 0,0% fails in last 410 master runs.

{color:#d04437}Platform C++ (Linux){color} [[tests 0 TIMEOUT , Failure on metric |https://ci.ignite.apache.org/viewLog.html?buildId=2999295]]

{panel}
[TeamCity *-&gt; Run :: SQL* Results|https://ci.ignite.apache.org/viewLog.html?buildId=2999298&amp;buildTypeId=IgniteTests24Java8_RunAllSql]

> 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
>          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)

Mime
View raw message