[
https://issues.apache.org/jira/browse/IGNITE-16103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522142#comment-17522142
]
Ignite TC Bot commented on IGNITE-16103:
----------------------------------------
{panel:title=Branch: [pull/9973/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9973/head] Base: [master] : New Tests
(2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=6390385]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
H2DynamicTableSelfTest.testCreateTableWithKeywordName - PASSED{color}
{color:#00008b}Queries 1 (lazy=true){color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=6390386]]
* {color:#013220}IgniteBinaryCacheQueryLazyTestSuite:
H2DynamicTableSelfTest.testCreateTableWithKeywordName - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=6390417&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: 1.5h
> 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)
