[PHOENIX-3332] Secondary Indexes being ignored even with hints when addressing dynamic columns

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.6.0
• Assignee: Unassigned
• Reporter: Eric Yang
• Created: 26/Sep/16 14:24
• Updated: 26/Sep/16 14:24

Description

I have the following index built

create local index “indexonCol1" on "table ("col1");

##index is used as expected
select * from "table" where "col1" = 'Value1';

##index is not used as expected

select * from "table"("dynamicColumn" varchar) where "col1" = 'Value1';

even using a hint

select /*+ index("table" "indexonCol1") */ * from "table"("dynamicColumn" varchar) where "col1"='Value1'

it still uses a full table scan rather than an index. I would have expected that the secondary Index would have been used in the secondary query as well given that the underlying table and conditions are the same