[
https://issues.apache.org/jira/browse/ASTERIXDB-3162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767259#comment-17767259
]
ASF subversion and git services commented on ASTERIXDB-3162:
------------------------------------------------------------
Commit 1c054ee6c478ae1986eac0294321572839bf8d18 in asterixdb's branch
refs/heads/master from murali4104
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=1c054ee6c4 ]
[ASTERIXDB-3162][COMP] Limit Costing
Change-Id: Iff86329748a020ef8626d84e619c71463425c37f
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17786
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Vijay Sarathy <[email protected]>
> Use index hint not honored for AND predicates when CBO is on
> ------------------------------------------------------------
>
> Key: ASTERIXDB-3162
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3162
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.6
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
>
> This is a fragment of CH2 query 6. This issue is reproducible with similar
> queries on non-CH2 tables also and happens with both array and non-array
> indexes.
> {code:java}
> SELECT count(*) as revenue
> FROM orders o, o.o_orderline ol
> WHERE ol.ol_delivery_d /*+ use-index (orderline_delivery_d) */ >=
> '2016-01-01 00:00:00.000000'
> AND ol.ol_delivery_d /*+ use-index (orderline_delivery_d) */ < '2017-01-01
> 00:00:00.000000';
> {code}
> The hint is honored when there is only a single predicate with no ANDs. The
> problem happens because the hint is not placed on the condition (as it is
> done for single predicates), but the condition has an "arguments" field which
> has the annotation. To fix this, we need to check the "arguments" field of
> the condition for the annotation.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
