>From Shahrzad Shirazi <[email protected]>: Shahrzad Shirazi has submitted this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20764?usp=email )
Change subject: [ASTERIXDB-3690][COMP] Fixing Index-Only Query Plan when using LIKE in UDF or with SET ...................................................................... [ASTERIXDB-3690][COMP] Fixing Index-Only Query Plan when using LIKE in UDF or with SET - user model changes: no - storage format changes: no - interface changes: no Details: This change ensures that an index-only query plan is used when applicable for LIKE predicates in a UDF or with a SET variable. Ext-ref: MB-69660 Change-Id: I8387141bc0edf36195934ae4452ad530c63bb4bf Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20764 Integration-Tests: Jenkins <[email protected]> Reviewed-by: Peeyush Gupta <[email protected]> Tested-by: Jenkins <[email protected]> --- M asterixdb/asterix-app/src/test/resources/optimizerts/results/ASTERIXDB-2402.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/ASTERIXDB-3682-field-access-in-join.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/ch2/ch2_q16.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/ch2/ch2_q20.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/ch2/ch2_q22.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/nested_loj2.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/exists.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/in_let_3.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/not_exists.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results/tpcds/query-ASTERIXDB-1581-correlated.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/ASTERIXDB-2402.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/ch2/ch2_q16.plan M asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested_loj2.plan A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/udf-with-like-in/udf-with-like-in.01.ddl.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/udf-with-like-in/udf-with-like-in.02.update.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/udf-with-like-in/udf-with-like-in.03.query.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/udf-with-like-in/udf-with-like-in.04.query.sqlpp R asterixdb/asterix-app/src/test/resources/runtimets/results/column/temporal/001/001.005.plan R asterixdb/asterix-app/src/test/resources/runtimets/results/column/temporal/001/001.006.plan R asterixdb/asterix-app/src/test/resources/runtimets/results/column/temporal/001/001.007.plan M asterixdb/asterix-app/src/test/resources/runtimets/results/profile/plansleep/sleep.3.regexjson A asterixdb/asterix-app/src/test/resources/runtimets/results/udf-with-like-in/udf-with-like-in.03.plan A asterixdb/asterix-app/src/test/resources/runtimets/results/udf-with-like-in/udf-with-like-in.04.plan M asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/SqlppQueryRewriter.java A asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/LikeFunctionCallVisitor.java M asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/OperatorExpressionVisitor.java 26 files changed, 1,354 insertions(+), 1,089 deletions(-) Approvals: Jenkins: Verified; Verified Peeyush Gupta: Looks good to me, approved -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20764?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: merged Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I8387141bc0edf36195934ae4452ad530c63bb4bf Gerrit-Change-Number: 20764 Gerrit-PatchSet: 18 Gerrit-Owner: Shahrzad Shirazi <[email protected]> Gerrit-Reviewer: Ali Alsuliman <[email protected]> Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins <[email protected]> Gerrit-Reviewer: Peeyush Gupta <[email protected]> Gerrit-Reviewer: Preetham Poluparthi <[email protected]> Gerrit-Reviewer: Shahrzad Shirazi <[email protected]>
