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]

Reply via email to