You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ian Maxon (Jira)" <ji...@apache.org> on 2023/04/14 17:09:00 UTC
[jira] [Updated] (ASTERIXDB-3157) Spurious warnings about inapplicable hints.
[ https://issues.apache.org/jira/browse/ASTERIXDB-3157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon updated ASTERIXDB-3157:
---------------------------------
Priority: Minor (was: Major)
> 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: Minor
>
> 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)