This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 4c1f7f241c3 [test](regression) Force index pushdown for multi match
null query (#65505)
4c1f7f241c3 is described below
commit 4c1f7f241c33964be270db2d2da0379eb533833f
Author: liangj777 <[email protected]>
AuthorDate: Mon Jul 13 18:04:17 2026 +0800
[test](regression) Force index pushdown for multi match null query (#65505)
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR
should merge into -->
---
.../suites/inverted_index_p0/test_multi_match_null_query.groovy | 6 ++++--
1 file changed, 4 insertions(+), 2 deletions(-)
diff --git
a/regression-test/suites/inverted_index_p0/test_multi_match_null_query.groovy
b/regression-test/suites/inverted_index_p0/test_multi_match_null_query.groovy
index 7b516ca8517..4444f1562f4 100644
---
a/regression-test/suites/inverted_index_p0/test_multi_match_null_query.groovy
+++
b/regression-test/suites/inverted_index_p0/test_multi_match_null_query.groovy
@@ -36,8 +36,10 @@ suite("test_multi_match_null_query", "p0") {
// Disable FE constant folding so NULL is not optimized to VEMPTYSET,
// forcing the predicate to reach the BE inverted index path
(pushAggOp=COUNT_ON_INDEX).
sql "SET disable_nereids_expression_rules = 'FOLD_CONSTANT_ON_FE'"
- sql "SET enable_fold_constant_by_be = 'true'"
- sql "SET enable_sql_cache = 0"
+ sql "SET enable_fold_constant_by_be = true"
+ sql "SET enable_sql_cache = false"
+ sql "SET enable_common_expr_pushdown = true"
+ sql "SET enable_common_expr_pushdown_for_inverted_index = true"
qt_sql "SELECT count() FROM test_multi_match_null_query WHERE body
MATCH_ALL NULL"
qt_sql "SELECT count() FROM test_multi_match_null_query WHERE body
MATCH_ANY NULL"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
