This is an automated email from the ASF dual-hosted git repository.
jianliangqi 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 a7538377a42 branch-3.0: [test](index compaction)Fix unstable index
compaction fault injection case #45784 (#45802)
a7538377a42 is described below
commit a7538377a42445ce1c6386edde47f198c5d3df7c
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Dec 23 18:09:30 2024 +0800
branch-3.0: [test](index compaction)Fix unstable index compaction fault
injection case #45784 (#45802)
Cherry-picked from #45784
Co-authored-by: qiye <l...@selectdb.com>
---
...est_index_compaction_exception_fault_injection.groovy | 16 ++++++----------
1 file changed, 6 insertions(+), 10 deletions(-)
diff --git
a/regression-test/suites/fault_injection_p0/test_index_compaction_exception_fault_injection.groovy
b/regression-test/suites/fault_injection_p0/test_index_compaction_exception_fault_injection.groovy
index b54f6374d83..9c0cb5aea97 100644
---
a/regression-test/suites/fault_injection_p0/test_index_compaction_exception_fault_injection.groovy
+++
b/regression-test/suites/fault_injection_p0/test_index_compaction_exception_fault_injection.groovy
@@ -26,8 +26,6 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
def changed_variables = sql "show variables where Changed = 1"
logger.info("changed variables: " + changed_variables.toString())
- // sql "UNSET GLOBAL VARIABLE ALL;"
- sql "SET global enable_match_without_inverted_index = false"
boolean disableAutoCompaction = false
@@ -120,7 +118,7 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
}
def run_sql = { ->
- def result = sql_return_maparray "SELECT * FROM ${tableName} WHERE
name MATCH 'bason'"
+ def result = sql_return_maparray "SELECT /*+
SET_VAR(enable_match_without_inverted_index = false,
enable_common_expr_pushdown = true) */ * FROM ${tableName} WHERE name MATCH
'bason'"
assertEquals(3, result.size())
assertEquals(1, result[0]['id'])
assertEquals("bason", result[0]['name'])
@@ -129,7 +127,7 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
assertEquals(3, result[2]['id'])
assertEquals("bason", result[2]['name'])
- result = sql_return_maparray "SELECT * FROM ${tableName} WHERE age =
11"
+ result = sql_return_maparray "SELECT /*+
SET_VAR(enable_match_without_inverted_index = false,
enable_common_expr_pushdown = true) */ * FROM ${tableName} WHERE age = 11"
assertEquals(3, result.size())
assertEquals(1, result[0]['id'])
assertEquals("bason", result[0]['name'])
@@ -138,7 +136,7 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
assertEquals(3, result[2]['id'])
assertEquals("bason", result[2]['name'])
- result = sql_return_maparray "SELECT * FROM ${tableName} WHERE
description MATCH 'singing'"
+ result = sql_return_maparray "SELECT /*+
SET_VAR(enable_match_without_inverted_index = false,
enable_common_expr_pushdown = true) */ * FROM ${tableName} WHERE description
MATCH 'singing'"
assertEquals(3, result.size())
assertEquals("bason", result[0]['name'])
assertEquals("bason is good at singing", result[0]['description'])
@@ -147,7 +145,7 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
assertEquals("bason", result[2]['name'])
assertEquals("bason is good at singing", result[2]['description'])
- result = sql_return_maparray "SELECT * FROM ${tableName} WHERE
array_contains(scores, 79)"
+ result = sql_return_maparray "SELECT /*+
SET_VAR(enable_match_without_inverted_index = false,
enable_common_expr_pushdown = true) */ * FROM ${tableName} WHERE
array_contains(scores, 79)"
assertEquals(3, result.size())
assertEquals("bason", result[0]['name'])
assertEquals("[79, 85, 97]", result[0]['scores'])
@@ -156,7 +154,7 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
assertEquals("bason", result[2]['name'])
assertEquals("[79, 85, 97]", result[2]['scores'])
- result = sql_return_maparray "SELECT * FROM ${tableName} WHERE
array_contains(hobbies, 'dancing')"
+ result = sql_return_maparray "SELECT /*+
SET_VAR(enable_match_without_inverted_index = false,
enable_common_expr_pushdown = true) */ * FROM ${tableName} WHERE
array_contains(hobbies, 'dancing')"
assertEquals(3, result.size())
assertEquals("bason", result[0]['name'])
assertEquals('["singing", "dancing"]', result[0]['hobbies'])
@@ -165,7 +163,7 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
assertEquals("bason", result[2]['name'])
assertEquals('["singing", "dancing"]', result[2]['hobbies'])
- result = sql_return_maparray "SELECT * FROM ${tableName} WHERE
array_contains(evaluation, 'bason is very clever')"
+ result = sql_return_maparray "SELECT /*+
SET_VAR(enable_match_without_inverted_index = false,
enable_common_expr_pushdown = true) */ * FROM ${tableName} WHERE
array_contains(evaluation, 'bason is very clever')"
assertEquals(3, result.size())
assertEquals("bason", result[0]['name'])
assertEquals('["bason is very clever", "bason is very healthy"]',
result[0]['evaluation'])
@@ -338,7 +336,5 @@ suite("test_index_compaction_exception_fault_injection",
"nonConcurrent") {
if (has_update_be_config) {
set_be_config.call("inverted_index_compaction_enable",
invertedIndexCompactionEnable.toString())
}
- sql "SET global enable_match_without_inverted_index = true"
}
-
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
