This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 b87d0bfa7a1 [fix](suites) Enable common expr pushdown in the restore
inverted idx case (#45547)
b87d0bfa7a1 is described below
commit b87d0bfa7a1461e1365eea1aa2631b7efe09e026
Author: walter <[email protected]>
AuthorDate: Wed Dec 18 09:47:40 2024 +0800
[fix](suites) Enable common expr pushdown in the restore inverted idx case
(#45547)
`set enable_common_expr_pushdown = false` will affect the execution of
match_any
---
.../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: [email protected]
For additional commands, e-mail: [email protected]
