[
https://issues.apache.org/jira/browse/ASTERIXDB-3175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wail Y. Alkowaileet updated ASTERIXDB-3175:
-------------------------------------------
Labels: triaged (was: )
> What's not to LIKE about secondary indexes?
> -------------------------------------------
>
> Key: ASTERIXDB-3175
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3175
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler, HYR - Hyracks, SQL - Translator SQL++
> Affects Versions: 0.9.8.1
> Reporter: Michael J. Carey
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
> Attachments: doncdata-noschema.sqlpp, doncdata-schema.sqlpp
>
>
> Currently the SQL++ compiler doesn't use secondary indexes for LIKE
> predicates, not even in the "standard" prefix case (... LIKE 'Q%') or the
> exact match case (... LIKE 'Q').
> For example, you can use either of the two attached setups to create an
> instance of the Don Chamberlin example database and then do:
> USE DonCDataSchema;
> CREATE INDEX name_index ON customers(name);
> or:
> USE DonCDataNoSchema;
> CREATE INDEX name_index ON customers(name:String);
> followed by:
> SELECT * FROM customers WHERE name LIKE 'T. Cruise';
> vs:
> SELECT * FROM customers WHERE name = 'T. Cruise';
> The index is used for the latter but not the former. That shouldn't be the
> case! Also, the index should be used for:
> SELECT * FROM customers WHERE name LIKE 'T%';
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
