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

[Ignite TC Bot (Jira)]

    [ 
https://issues.apache.org/jira/browse/IGNITE-19814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17739467#comment-17739467
 ] 

Ignite TC Bot commented on IGNITE-19814:
----------------------------------------

{panel:title=Branch: [pull/10819/head] Base: [master] : No blockers 
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/10819/head] Base: [master] : New Tests 
(1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests 
1|https://ci2.ignite.apache.org/viewLog.html?buildId=7237570]]
* {color:#013220}IgniteCalciteTestSuite: 
TableDdlIntegrationTest.testPrimaryKeyInlineSize - PASSED{color}

{panel}
[TeamCity *--> Run :: All* 
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=7237651&buildTypeId=IgniteTests24Java8_RunAll]

> 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
>         Attachments: 
> 0001-IGNITE-19814-Add-calcite-test-for-integer-column-ind.patch
>
>          Time Spent: 20m
>  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)