[ASTERIXDB-3524] Index hints ignored while not producing a warning

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: IDX - Indexes
• Labels: triaged
• Assignee: Vijay Sarathy
• Reporter: Pratyoy Das
• Created: 04/Nov/24 18:32
• Updated: 08/Nov/24 18:09

Description

When I run a query with a particular index hint, Asterix DB ignores the index on the hint and uses the default primary key index.

Below is an example query:

USE tpch;SELECT  Orders.o_custkey, Lineitem.l_extendedprice
FROM   Orders, Lineitem
WHERE Orders.o_orderkey /*+ indexnl(lineitem_fk_orders) */ = Lineitem.l_orderkey

I am attaching the json query plan where you will see the"Lineitem" index is used to join with Lineitem and not "lineitem_fk_orders".