[
https://issues.apache.org/jira/browse/CALCITE-3519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shuo Cheng updated CALCITE-3519:
--------------------------------
Description:
Taking the following SQL with hint for example: (Copying from
`org.apache.calcite.test.SqlHintsConverterTest.testQueryHint `)
{code:java}
select /*+ properties(k1='v1', k2='v2'), index(ename), no_hash_join */
from emp e1
inner join dept d1 on e1.deptno = d1.deptno
inner join emp e2 on e1.ename = e2.job{code}
rel plan with hints should be something like the following according to the
hint design doc:
{code:java}
LogicalProject(EMPNO=[$0],...）([PROPERTIES inheritPath:[] options:{K1=v1,
K2=v2}],[INDEX inheritPath:[] options:[ENAME]],[NO_HASH_JOIN inheritPath:[]])
LogicalJoin(condition=[=($1, $20)], joinType=[inner]) ([NO_HASH_JOIN
inheritPath:[0]])
LogicalJoin(condition=[=($7, $9)], joinType=[inner]) (NO_HASH_JOIN
inheritPath:[0, 0]])
LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ([PROPERTIES
inheritPath:[0, 0, 0] options:{K1=v1, K2=v2}], [INDEX inheritPath:[0, 0, 0]
options:[ENAME]])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]]) ([PROPERTIES
inheritPath:[0, 0, 1] options:{K1=v1, K2=v2}], [INDEX inheritPath:[1, 0, 0]
options:[ENAME]])
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],...)
LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ([PROPERTIES
inheritPath:[0, 1, 0] options:{K1=v1, K2=v2}], [INDEX inheritPath:[0, 1, 0]
options:[ENAME]]){code}
But the expected result of `SqlHintsConverterTest.testQueryHint` violates the
intention of Hint design doc.
was:
Taking the following SQL with hint for example: (Copying from
`org.apache.calcite.test.SqlHintsConverterTest.testQueryHint `)
{code:java}
select /*+ properties(k1='v1', k2='v2'), index(ename), no_hash_join */
from emp e1
inner join dept d1 on e1.deptno = d1.deptno
inner join emp e2 on e1.ename = e2.job{code}
rel plan with hints should be following according to the hint design doc:
{code:java}
LogicalProject(EMPNO=[$0],...）([PROPERTIES inheritPath:[] options:{K1=v1,
K2=v2}],[INDEX inheritPath:[] options:[ENAME]],[NO_HASH_JOIN inheritPath:[]])
LogicalJoin(condition=[=($1, $20)], joinType=[inner]) ([NO_HASH_JOIN
inheritPath:[0]])
LogicalJoin(condition=[=($7, $9)], joinType=[inner]) (NO_HASH_JOIN
inheritPath:[0, 0]])
LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ([PROPERTIES
inheritPath:[0, 0, 0] options:{K1=v1, K2=v2}], [INDEX inheritPath:[0, 0, 0]
options:[ENAME]])
LogicalTableScan(table=[[CATALOG, SALES, DEPT]]) ([PROPERTIES
inheritPath:[0, 0, 1] options:{K1=v1, K2=v2}], [INDEX inheritPath:[1, 0, 0]
options:[ENAME]])
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],...)
LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ([PROPERTIES
inheritPath:[0, 1, 0] options:{K1=v1, K2=v2}], [INDEX inheritPath:[0, 1, 0]
options:[ENAME]]){code}
But the expected result of `SqlHintsConverterTest.testQueryHint` violates the
intention of Hint design doc.
> `inheritPath` of `RelHint` represented by `ImmutableBitSet` may be incomplete.
> ------------------------------------------------------------------------------
>
> Key: CALCITE-3519
> URL: https://issues.apache.org/jira/browse/CALCITE-3519
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.21.0
> Reporter: Shuo Cheng
> Priority: Major
> Labels: patch, pull-request-available
> Fix For: 1.22.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Taking the following SQL with hint for example: (Copying from
> `org.apache.calcite.test.SqlHintsConverterTest.testQueryHint `)
>
> {code:java}
> select /*+ properties(k1='v1', k2='v2'), index(ename), no_hash_join */
> from emp e1
> inner join dept d1 on e1.deptno = d1.deptno
> inner join emp e2 on e1.ename = e2.job{code}
>
> rel plan with hints should be something like the following according to the
> hint design doc:
> {code:java}
> LogicalProject(EMPNO=[$0],...）([PROPERTIES inheritPath:[] options:{K1=v1,
> K2=v2}],[INDEX inheritPath:[] options:[ENAME]],[NO_HASH_JOIN inheritPath:[]])
> LogicalJoin(condition=[=($1, $20)], joinType=[inner]) ([NO_HASH_JOIN
> inheritPath:[0]])
> LogicalJoin(condition=[=($7, $9)], joinType=[inner]) (NO_HASH_JOIN
> inheritPath:[0, 0]])
> LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ([PROPERTIES
> inheritPath:[0, 0, 0] options:{K1=v1, K2=v2}], [INDEX inheritPath:[0, 0, 0]
> options:[ENAME]])
> LogicalTableScan(table=[[CATALOG, SALES, DEPT]]) ([PROPERTIES
> inheritPath:[0, 0, 1] options:{K1=v1, K2=v2}], [INDEX inheritPath:[1, 0, 0]
> options:[ENAME]])
> LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],...)
> LogicalTableScan(table=[[CATALOG, SALES, EMP]]) ([PROPERTIES
> inheritPath:[0, 1, 0] options:{K1=v1, K2=v2}], [INDEX inheritPath:[0, 1, 0]
> options:[ENAME]]){code}
>
> But the expected result of `SqlHintsConverterTest.testQueryHint` violates
> the intention of Hint design doc.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
