This is an automated email from the ASF dual-hosted git repository.
liaoxin 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 491d2183def [fix](regression) Fix case test_segcompaction_agg_keys
(#61026)
491d2183def is described below
commit 491d2183def863e4ff24e80742191f4bc767af15
Author: 黄瑞鑫 <[email protected]>
AuthorDate: Mon Mar 9 10:44:07 2026 +0800
[fix](regression) Fix case test_segcompaction_agg_keys (#61026)
---
.../data/segcompaction_p2/test_segcompaction_agg_keys.out | 3 ---
.../segcompaction_p2/test_segcompaction_agg_keys.groovy | 12 +++++++++++-
2 files changed, 11 insertions(+), 4 deletions(-)
diff --git
a/regression-test/data/segcompaction_p2/test_segcompaction_agg_keys.out
b/regression-test/data/segcompaction_p2/test_segcompaction_agg_keys.out
deleted file mode 100644
index 4d375f3ccb5..00000000000
--- a/regression-test/data/segcompaction_p2/test_segcompaction_agg_keys.out
+++ /dev/null
@@ -1,3 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !select_default --
-47 Lychee Lychee Plum Banana Lychee Lychee Cherry Pineapple
Banana Watermelon Mango Apple Apple Peach Raspberry Grapes
Raspberry Raspberry Kiwi Orange Apple Plum Blueberry
Strawberry Orange Raspberry Strawberry Lemon Orange
Blueberry Apple Peach Banana Kiwi Orange Banana Strawberry
Lemon Mango Orange Peach Avocado Pineapple Kiwi Lemon Grapes
Strawberry Grapes Lychee
diff --git
a/regression-test/suites/segcompaction_p2/test_segcompaction_agg_keys.groovy
b/regression-test/suites/segcompaction_p2/test_segcompaction_agg_keys.groovy
index 3c09af9c542..d16627f956f 100644
--- a/regression-test/suites/segcompaction_p2/test_segcompaction_agg_keys.groovy
+++ b/regression-test/suites/segcompaction_p2/test_segcompaction_agg_keys.groovy
@@ -86,7 +86,17 @@ suite("test_segcompaction_agg_keys") {
}
}
- qt_select_default """ SELECT * FROM ${tableName} WHERE col_0=47; """
+ // Cannot use qt_select_default here: S3 Load parallelizes across
multiple BE workers,
+ // each creating separate segments with non-deterministic sequence
numbers.
+ // REPLACE aggregation picks the value from the segment with the
highest sequence,
+ // so the winner among the 12 source rows with col_0=47 is not
guaranteed across runs.
+ def selectResult = sql """ SELECT * FROM ${tableName} WHERE col_0=47;
"""
+ assertEquals(1, selectResult.size(), "Expected exactly 1 row for
col_0=47 after REPLACE aggregation")
+ def row = selectResult[0].collect { it?.toString() }
+ def possibleResult1 = ["47", "Lychee", "Lychee", "Plum", "Banana",
"Lychee", "Lychee", "Cherry", "Pineapple", "Banana", "Watermelon", "Mango",
"Apple", "Apple", "Peach", "Raspberry", "Grapes", "Raspberry", "Raspberry",
"Kiwi", "Orange", "Apple", "Plum", "Blueberry", "Strawberry", "Orange",
"Raspberry", "Strawberry", "Lemon", "Orange", "Blueberry", "Apple", "Peach",
"Banana", "Kiwi", "Orange", "Banana", "Strawberry", "Lemon", "Mango", "Orange",
"Peach", "Avocado", "Pineapple", "Ki [...]
+ def possibleResult2 = ["47", "Banana", "Watermelon", "Lychee",
"Blueberry", "Raspberry", "Strawberry", "Grapes", "Watermelon", "Lemon",
"Lemon", "Pineapple", "Watermelon", "Peach", "Kiwi", "Lychee", "Peach",
"Pineapple", "Raspberry", "Grapes", "Lychee", "Raspberry", "Peach", "Kiwi",
"Pineapple", "Apple", "Lemon", "Lychee", "Pineapple", "Blueberry", "Blueberry",
"Avocado", "Cherry", "Kiwi", "Cherry", "Watermelon", "Plum", "Banana", "Peach",
"Pineapple", "Apple", "Strawberry", "Avo [...]
+ assertTrue(row == possibleResult1 || row == possibleResult2,
+ "Result for col_0=47 does not match either expected outcome.\nGot:
${row}")
String[][] tablets = sql """ show tablets from ${tableName}; """
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]