[ https://issues.apache.org/jira/browse/IGNITE-17597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17599312#comment-17599312 ]
Ignite TC Bot commented on IGNITE-17597: ---------------------------------------- {panel:title=Branch: [pull/10233/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel} {panel:title=Branch: [pull/10233/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=6589049]] * {color:#013220}IgniteCalciteTestSuite: TableDdlIntegrationTest.alterTableChangeColumnAndUseIndex - PASSED{color} {panel} [TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=6589128&buildTypeId=IgniteTests24Java8_RunAll] > Calcite engine. Indexes for table can't be used after columns added or dropped > ------------------------------------------------------------------------------ > > Key: IGNITE-17597 > URL: https://issues.apache.org/jira/browse/IGNITE-17597 > Project: Ignite > Issue Type: Bug > Reporter: Aleksey Plekhanov > Assignee: Aleksey Plekhanov > Priority: Blocker > Labels: calcite, calcite2-required, calcite3-required > Fix For: 2.14 > > Time Spent: 10m > Remaining Estimate: 0h > > We recreate tables, but not copy indexes in schema change listener > (\{{SchemaHolderImpl#onColumnsAdded}}, \{{SchemaHolderImpl#onColumnsDropped}}) > Reproducer: > > {code:java} > public void testIndexAfterColumnsChange() { > sql("create table t(id int)"); > sql("create index t_idx on t(id)"); > for (int i = 0; i < 100; i++) > sql("insert into t values (?)", i); > assertQuery("select * from t where id = 0") > .matches(QueryChecker.containsIndexScan("PUBLIC", "T", "T_IDX")) > .check(); > sql("alter table t add column new_col int"); > assertQuery("select * from t where id = 0") > .matches(QueryChecker.containsIndexScan("PUBLIC", "T", "T_IDX")) > .check(); > } {code} > > -- This message was sent by Atlassian Jira (v8.20.10#820010)