[
https://issues.apache.org/jira/browse/ASTERIXDB-3525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17897289#comment-17897289
]
ASF subversion and git services commented on ASTERIXDB-3525:
------------------------------------------------------------
Commit 32bec9d79ad370430519bc98a2c56f216e95f5a2 in asterixdb's branch
refs/heads/master from ayush.tripathi
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=32bec9d79a ]
[ASTERIXDB-3525][COMP] Rewrite Like operator with % suffix as AND Operator
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
When a pattern ends with %, we can utilize secondary indexes by transforming
the LIKE into an AND expression.
Ext-ref: MB-56789
Change-Id: I22a4a5b94c89ae8f7132b52848cfe300f09b1645
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19045
Integration-Tests: Jenkins <[email protected]>
Tested-by: Murtadha Hubail <[email protected]>
Reviewed-by: Murtadha Hubail <[email protected]>
> Utilize secondary indexes with LIKE operator
> --------------------------------------------
>
> Key: ASTERIXDB-3525
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3525
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler
> Affects Versions: 0.9.10
> Reporter: Murtadha Makki Al Hubail
> Priority: Major
> Labels: triaged
> Fix For: 0.9.10
>
>
> We should utilize secondary indexes when LIKE operator is used at least for
> the prefix cases (e.g., WHERE some_field LIKE "prefix%")
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
