[ASTERIXDB-2707] B+ tree indexes not used for LIKE queries!

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.9.4.1
• Fix Version/s: 0.9.8
• Component/s: *DB - AsterixDB, COMP - Compiler
• Assignee: Dmitry Lychagin
• Reporter: Michael J. Carey
• Created: 09/Mar/20 23:02
• Updated: 17/Feb/22 01:52

Description

Try any LIKE prefix query, e.g., name LIKE 'Carey' or name LIKE 'Carey%', that should use an index on customer.name and you'll see - index not used!