Maksim Timonin created IGNITE-16103:
---------------------------------------

             Summary: 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


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)

Reply via email to