Vijay Sarathy created ASTERIXDB-3162:
----------------------------------------
Summary: 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
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)
