You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2022/04/11 14:16:00 UTC
[jira] [Commented] (IGNITE-16103) Failed to create index for table "table" with some options
[ https://issues.apache.org/jira/browse/IGNITE-16103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17520602#comment-17520602 ]
Ignite TC Bot commented on IGNITE-16103:
----------------------------------------
{panel:title=Branch: [pull/9952/head] Base: [master] : Possible Blockers (3)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Platform .NET (Windows){color} [[tests 0 TIMEOUT , Exit Code |https://ci2.ignite.apache.org/viewLog.html?buildId=6387757]]
{color:#d04437}Platform .NET (Core Linux){color} [[tests 0 TIMEOUT , Exit Code |https://ci2.ignite.apache.org/viewLog.html?buildId=6387756]]
{color:#d04437}[Missing Tests]{color} [[tests 0 Exit Code |https://ci2.ignite.apache.org/viewLog.html?buildId=6387739]]
{panel}
{panel:title=Branch: [pull/9952/head] Base: [master] : No new tests found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}{panel}
[TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=6387791&buildTypeId=IgniteTests24Java8_RunAll]
> Failed to create index for table "table" with some options
> ----------------------------------------------------------
>
> Key: IGNITE-16103
> URL: https://issues.apache.org/jira/browse/IGNITE-16103
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Timonin
> Assignee: Luchnikov Alexander
> Priority: Minor
> Labels: good-first-issue, newbie
> Time Spent: 50m
> Remaining Estimate: 0h
>
> 1. How to reproduce - all options CACHE_NAME, VALUE_TYPE, INLINE_SIZE should be in the queries to reproduce failure:
> ```
> create table table(id int PRIMARY KEY, fld1 int, fld2 int) with "CACHE_NAME=TEST_CACHE_NAME,VALUE_TYPE=TEST_VALUE_TYPE";
> create index idx_0 on table(fld1, fld2) INLINE_SIZE 0;
> ```
> Creation of index fails with exception:
> Syntax error in SQL statement "CREATE INDEX IDX_0 ON TABLE(FLD1, FLD2) INLINE_SIZE[*] 0 "; SQL statement:
> create index IDX_0 on table(fld1, fld2) INLINE_SIZE 0 [42000-197]
> at
>
> 2. How to fix: need to debug why parameters matters, looks like appearance of this options triggers some checks that doesn't run while no options specified. Then this checks should be triggers independently on specified options or should be removed (depends on).
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)