This is an automated email from the ASF dual-hosted git repository.
w41ter pushed a commit to branch fix_test_backup_restore_inverted_idx
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 30013aa35974fdd217309e4b1eb545ac63b56697
Author: w41ter <maoch...@selectdb.com>
AuthorDate: Tue Dec 17 11:44:55 2024 +0000
[fix](suites) Enable common expr pushdown in the restore inverted idx case
---
.../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
