This is an automated email from the ASF dual-hosted git repository.
w41ter pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 712e19738a0 [fix](suites) Enable common expr pushdown in the restore
inverted idx case #45547 (#45575)
712e19738a0 is described below
commit 712e19738a0b0feada109c33432c5f4a709130a8
Author: walter <maoch...@selectdb.com>
AuthorDate: Wed Dec 18 13:02:43 2024 +0800
[fix](suites) Enable common expr pushdown in the restore inverted idx case
#45547 (#45575)
cherry pick from #45547
---
.../suites/backup_restore/test_backup_restore_inverted_idx.groovy | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git
a/regression-test/suites/backup_restore/test_backup_restore_inverted_idx.groovy
b/regression-test/suites/backup_restore/test_backup_restore_inverted_idx.groovy
index 0dadc99dd21..9c5718e3bf7 100644
---
a/regression-test/suites/backup_restore/test_backup_restore_inverted_idx.groovy
+++
b/regression-test/suites/backup_restore/test_backup_restore_inverted_idx.groovy
@@ -117,13 +117,13 @@ suite("test_backup_restore_inverted_idx",
"backup_restore") {
// 1. query with inverted index
sql """ set enable_match_without_inverted_index = false """
- def res = sql """ SELECT /*+ SET_VAR(inverted_index_skip_threshold =
0) */ * FROM ${dbName}.${tableName} WHERE value MATCH_ANY "10" """
+ def res = sql """ SELECT /*+ SET_VAR(inverted_index_skip_threshold =
0, enable_common_expr_pushdown = true) */ * FROM ${dbName}.${tableName} WHERE
value MATCH_ANY "10" """
assertTrue(res.size() > 0)
// 2. add partition and query
sql """ ALTER TABLE ${dbName}.${tableName} ADD PARTITION p8 VALUES
LESS THAN ("80") """
sql """ INSERT INTO ${dbName}.${tableName} VALUES (75, "75 750", "76
77") """
- res = sql """ SELECT /*+ SET_VAR(inverted_index_skip_threshold = 0) */
* FROM ${dbName}.${tableName} WHERE value MATCH_ANY "75" """
+ res = sql """ SELECT /*+ SET_VAR(inverted_index_skip_threshold = 0,
enable_common_expr_pushdown = true) */ * FROM ${dbName}.${tableName} WHERE
value MATCH_ANY "75" """
assertTrue(res.size() > 0)
// 3. add new index
@@ -159,7 +159,7 @@ suite("test_backup_restore_inverted_idx", "backup_restore")
{
logger.info("the build index status: ${build_status}")
assertTrue(false)
}
- res = sql """ SELECT /*+ SET_VAR(inverted_index_skip_threshold = 0) */
* FROM ${dbName}.${tableName} WHERE value1 MATCH_ANY "12321" """
+ res = sql """ SELECT /*+ SET_VAR(inverted_index_skip_threshold = 0,
enable_common_expr_pushdown = true) */ * FROM ${dbName}.${tableName} WHERE
value1 MATCH_ANY "12321" """
assertTrue(res.size() > 0)
} finally {
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
