[
https://issues.apache.org/jira/browse/IGNITE-10306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17202056#comment-17202056
]
Ignite TC Bot commented on IGNITE-10306:
----------------------------------------
{panel:title=Branch: [pull/8255/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/8255/head] Base: [master] : New Tests
(42)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests
42|https://ci.ignite.apache.org/viewLog.html?buildId=5623611]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testSelectExpression3 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testSelectExpression4 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testSelectExpression5 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testSelectExpressionCompoundPk - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testExistsClauseMultiple - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testInClauseCompoundPk - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testInClauseMultiple - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testTableListMultiple - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testExistsClauseCompoundPk - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testTableList10 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testSelectExpression1 - PASSED{color}
... and 31 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci.ignite.apache.org/viewLog.html?buildId=5622144&buildTypeId=IgniteTests24Java8_RunAll]
> SQL: Transform subqueries to JOINs when possible
> ------------------------------------------------
>
> Key: IGNITE-10306
> URL: https://issues.apache.org/jira/browse/IGNITE-10306
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Vladimir Ozerov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: iep-24
> Time Spent: 3.5h
> Remaining Estimate: 0h
>
> Currently subqueries are mostly not analyzed in any way. This makes our
> distributed execution plan more complex to analyze and execute. Moreover, we
> cannot extract partition information from such queries efficiently. We need
> to apply the simplest "JOIN conversion" optimization on early query analysis
> phase and try to transform our AST from subquery to join.
> This should be done before partition extraction, pushdowns and splitter. See
> [1] for more information.
> Postgres implementation of subquery rewrites could be found here [2].
> [1]
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-24%3A+SQL+Partition+Pruning
> [2]
> https://github.com/postgres/postgres/blob/master/src/backend/optimizer/prep/prepjointree.c
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
