[
https://issues.apache.org/jira/browse/IGNITE-16103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luchnikov Alexander reassigned IGNITE-16103:
--------------------------------------------
Assignee: Luchnikov Alexander
> 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
>
> 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)
