[
https://issues.apache.org/jira/browse/IGNITE-19814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Petr Ivanov reassigned IGNITE-19814:
------------------------------------
Assignee: Aleksey Plekhanov (was: Petr Ivanov)
> 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
> Assignee: Aleksey Plekhanov
> Priority: Minor
> Labels: calcite, ise
> Fix For: 2.16
>
> Attachments:
> 0001-IGNITE-19814-Add-calcite-test-for-integer-column-ind.patch
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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)