This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.1 by this push:
new f9280c98bc9 branch-4.1: [fix](regression) Fix case
test_segcompaction_agg_keys #61026 (#65441)
f9280c98bc9 is described below
commit f9280c98bc966ff2f87c5ae478f51b024b70bb25
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Jul 10 15:19:26 2026 +0800
branch-4.1: [fix](regression) Fix case test_segcompaction_agg_keys #61026
(#65441)
Cherry-picked from #61026
Co-authored-by: 黄瑞鑫 <[email protected]>
---
.../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]
