[
https://issues.apache.org/jira/browse/IGNITE-20323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17801201#comment-17801201
]
Ignite TC Bot commented on IGNITE-20323:
----------------------------------------
{panel:title=Branch: [pull/10918/head] Base: [master] : Possible Blockers
(1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Platform .NET (Windows){color} [[tests 0 TIMEOUT , Exit Code
|https://ci2.ignite.apache.org/viewLog.html?buildId=7682224]]
{panel}
{panel:title=Branch: [pull/10918/head] Base: [master] : New Tests
(13)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
13|https://ci2.ignite.apache.org/viewLog.html?buildId=7682181]]
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testDisableMergeJoin - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testDisableMergeJoinWith3Tables - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testDisableCNLJoin - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testSeveralDisables - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testMergeJoinEnabled - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testDisableNLJoin - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testDisableJoinTypeInSubquery - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testHintsErrors - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testNestedHintOverrides - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testNLJoinEnabled - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinTypeHintPlannerTest.testCNLJoinEnabled - PASSED{color}
... and 2 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=7682258&buildTypeId=IgniteTests24Java8_RunAll]
> SQL hint for join type.
> -----------------------
>
> Key: IGNITE-20323
> URL: https://issues.apache.org/jira/browse/IGNITE-20323
> Project: Ignite
> Issue Type: Task
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: ise
> Time Spent: 1h
> Remaining Estimate: 0h
>
> Additionally to the hint for locked join order, we might have a hint for
> choosing join type. Like 'USE_NL' or 'USE_MERGE' OracleDB hint. To implement,
> we might base all join rules on the same abstract join rule aware of known
> join types and join type hints. There, we could process join type hints
> enabling or disabling current join type converter rule.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
