[ASTERIXDB-3157] Spurious warnings about inapplicable hints.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Vijay Sarathy
• Reporter: Vijay Sarathy
• Created: 28/Mar/23 03:13
• Updated: 05/May/23 15:03
• Resolved: 14/Apr/23 22:33

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.

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;