[
https://issues.apache.org/jira/browse/ASTERIXDB-3157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay Sarathy updated ASTERIXDB-3157:
-------------------------------------
Description:
With CBO on, during join enumeration, the same hint may be applicable during
one join order, and may be inapplicable during a different join order. Since we
generate the warning as soon as we encounter it, if it becomes applicable in a
different join order, the warning should be suppressed.
{code:java}
select 017, count(1) from S join T on S.u1K /*+ hashjoin build (T) */ =
T.u1K join U on T.u4K = U.u4K;
select 017, count(1) from S join T on S.u1K /*+ hashjoin build (T) */ =
T.u1K join U on T.u4K /*+ hashjoin build (S) */ = U.u4K;
{code}
was:
With CBO on, during join enumeration, the same hint may be applicable during
one join order, and may be inapplicable during a different join order. Since we
generate the warning as soon as we encounter it, if it becomes applicable in a
different join order, the warning should be suppressed.
select 017, count(1) from S join T on S.u1K /*+ hashjoin build (T) */ =
T.u1K join U on T.u4K = U.u4K;
select 017, count(1) from S join T on S.u1K /*+ hashjoin build (T) */ =
T.u1K join U on T.u4K /*+ hashjoin build (S) */ = U.u4K;
> Spurious warnings about inapplicable hints.
> -------------------------------------------
>
> Key: ASTERIXDB-3157
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3157
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Priority: Major
>
> With CBO on, during join enumeration, the same hint may be applicable during
> one join order, and may be inapplicable during a different join order. Since
> we generate the warning as soon as we encounter it, if it becomes applicable
> in a different join order, the warning should be suppressed.
> {code:java}
> select 017, count(1) from S join T on S.u1K /*+ hashjoin build (T) */ =
> T.u1K join U on T.u4K = U.u4K;
>
> select 017, count(1) from S join T on S.u1K /*+ hashjoin build (T) */ =
> T.u1K join U on T.u4K /*+ hashjoin build (S) */ = U.u4K;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
