[
https://issues.apache.org/jira/browse/IGNITE-28899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18137001#comment-18137001
]
Ignite TC Bot commented on IGNITE-28899:
----------------------------------------
{panel:title=Branch: [pull/13389/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13389/head] Base: [master] : New Tests
(12)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
2|https://ci2.ignite.apache.org/viewLog.html?buildId=9464820]]
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.LitmusCheckIntegrationTest.LitmusCheckIntegrationTest
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.LitmusCheckIntegrationTest.testLitmusLowerCost
- PASSED{color}
{color:#00008b}Calcite SQL 2{color} [[tests
10|https://ci2.ignite.apache.org/viewLog.html?buildId=9464819]]
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByPrimaryKeysLeft
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByPrimaryKeysFull
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByForeignKeyLeft
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByForeignKeyFull
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.JoinRowCountEstimationTest
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinSameTableSimpleAffMergeJoin
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByPrimaryKeysRight
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByForeignKeyRight
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.correlatedNestedLoopJoinRowCount
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.JoinRowCountEstimationTest.joinByForeignKey
- PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9464855&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9464855
rerunBuildIds=9466340{color}
> Calcite. Fix litmus error during join
> -------------------------------------
>
> Key: IGNITE-28899
> URL: https://issues.apache.org/jira/browse/IGNITE-28899
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.18
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-2, ise
> Time Spent: 12h
> Remaining Estimate: 0h
>
> Need to fix calcite litmus errors raised during query like :
> {noformat}
> create table t11 (c1 int, c2 int, c3 int)
> create table t22 (c1 int, c2 int, c3 int)
> create index t11_idx on t11 (c3, c2, c1)
> create index t22_idx on t22 (c3, c2, c1)
> SELECT distinct p.c1 FROM t11 cd left join t22 p ON p.c2 = cd.c2 WHERE cd.c2
> = 1;
> {noformat}
> throws :
> {noformat}
> input=RelSubset#2393,distribution=hash[2])] has lower cost IgniteCost
> [rowCount=6.15, cpu=15.15, memory=10.0, io=2.0, network=15.799999999999999]
> than best cost IgniteCost
> {noformat}
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
