[jira] [Created] (IGNITE-19814) Calcite engine uses 0 as an inlineSize for index created by INT column

[Sergey Korotkov (Jira)]

Sergey Korotkov created IGNITE-19814:
----------------------------------------

             Summary: Calcite engine uses 0 as an inlineSize for index created 
by INT column
                 Key: IGNITE-19814
                 URL: https://issues.apache.org/jira/browse/IGNITE-19814
             Project: Ignite
          Issue Type: Bug
            Reporter: Sergey Korotkov


Using the Calcite query engine the following SQL statement 
{code:sql}
CREATE TABLE TEST (id INT, name VARCHAR, PRIMARY KEY(id))
{code}
creates index for INT id column with the inlineSize = 0.

If the _key_type_ is specified in the WITH clause index is created correctly 
with the inlineSize = 5:
{code:sql}
CREATE TABLE TEST (id INT, name VARCHAR, PRIMARY KEY(id))
WITH "key_type=Integer"
{code}


For H2 engine in both cases inlineSize is 5.

Reproducer is attached as a unit test.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)