tree 604b2d39ba9b03bceaf53423c17c2b637143cb79
parent a909b3ca07051f54ba8b64d32be0f690c1237695
author ayush.tripathi <ayush.tripathi@couchbase.com> 1730793972 +0530
committer Murtadha Hubail <mhubail@apache.org> 1731238179 +0000

[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 <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Murtadha Hubail <mhubail@apache.org>
Reviewed-by: Murtadha Hubail <mhubail@apache.org>