This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 621b1a4ac67 branch-3.1: [fix](case) fix unstable case #58499 (#58633)
621b1a4ac67 is described below
commit 621b1a4ac6727a0cceca359e52d2d83594bbbec4
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Dec 3 15:44:28 2025 +0800
branch-3.1: [fix](case) fix unstable case #58499 (#58633)
Cherry-picked from #58499
Co-authored-by: Sun Chenyang <[email protected]>
---
.../variant_p1/compaction/compaction_sparse_column.groovy | 14 +++++++-------
.../compaction/test_compaction_extract_root.groovy | 12 ++++++------
2 files changed, 13 insertions(+), 13 deletions(-)
diff --git
a/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
b/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
index e6fffa25b41..0e59421aaa1 100644
---
a/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
+++
b/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
@@ -112,34 +112,34 @@ suite("test_compaction_sparse_column", "p1") {
// b is sparse
// a is dense
- sql """insert into ${tableName} select 0, '{"a": 11245, "b" : 42000}'
as json_str
- union all select 0, '{"a": 1123}' as json_str union all select 0,
'{"a" : 1234, "xxxx" : "aaaaa"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
+ sql """insert into test_compaction select 0, '{"a": 11245, "b" :
42000}' as json_str
+ union all select 0, '{"a": 1123}' as json_str union all (select
0, '{"a" : 1234, "xxxx" : "aaaaa"}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
// b is sparse
// a, xxxx is dense
sql """insert into ${tableName} select 1, '{"a": 11245, "b" : 42001}'
as json_str
- union all select 1, '{"a": 1123}' as json_str union all select 1,
'{"a" : 1234, "xxxx" : "bbbbb"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
+ union all select 1, '{"a": 1123}' as json_str union all (select
1, '{"a" : 1234, "xxxx" : "bbbbb"}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
// b is sparse
// xxxx is dense
sql """insert into ${tableName} select 2, '{"a": 11245, "b" : 42002}'
as json_str
- union all select 2, '{"a": 1123}' as json_str union all select 2,
'{"a" : 1234, "xxxx" : "ccccc"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
+ union all select 2, '{"a": 1123}' as json_str union all (select
2, '{"a" : 1234, "xxxx" : "ccccc"}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
// point, xxxx is sparse
// a, b is dense
sql """insert into ${tableName} select 3, '{"a" : 1234, "point" : 1,
"xxxx" : "ddddd"}' as json_str
- union all select 3, '{"a": 1123}' as json_str union all select 3,
'{"a": 11245, "b" : 42003}' as json_str from numbers("number" = "4096") limit
4096 ;"""
+ union all select 3, '{"a": 1123}' as json_str union all (select
3, '{"a": 11245, "b" : 42003}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
// xxxx, eeeee is sparse
// a, b is dense
sql """insert into ${tableName} select 4, '{"a" : 1234, "xxxx" :
"eeeee", "point" : 5}' as json_str
- union all select 4, '{"a": 1123}' as json_str union all select 4,
'{"a": 11245, "b" : 42004}' as json_str from numbers("number" = "4096") limit
4096 ;"""
+ union all select 4, '{"a": 1123}' as json_str union all (select
4, '{"a": 11245, "b" : 42004}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
// xxxx, point is sparse
// a, b is dense
sql """insert into ${tableName} select 5, '{"a" : 1234, "xxxx" :
"fffff", "point" : 42000}' as json_str
- union all select 5, '{"a": 1123}' as json_str union all select 5,
'{"a": 11245, "b" : 42005}' as json_str from numbers("number" = "4096") limit
4096 ;"""
+ union all select 5, '{"a": 1123}' as json_str union all (select
5, '{"a": 11245, "b" : 42005}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
sql """insert into ${tableName} values (6, '{"b" : "789"}')"""
diff --git
a/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
b/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
index 7d9c5eee668..62fd4462a08 100644
---
a/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
+++
b/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
@@ -34,27 +34,27 @@ suite("test_compaction_extract_root", "p1") {
"""
sql """insert into ${tableName} select 0, '{"a": 11245, "b" : {"state" :
"open", "code" : 2}}' as json_str
- union all select 8, '{"a": 1123}' as json_str union all select 0,
'{"a" : 1234, "xxxx" : "aaaaa"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
+ union all select 8, '{"a": 1123}' as json_str union all (select 0,
'{"a" : 1234, "xxxx" : "aaaaa"}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
sql """insert into ${tableName} select 1, '{"a": 11245, "b" : {"state" :
"colse", "code" : 2}}' as json_str
- union all select 1, '{"a": 1123}' as json_str union all select 1,
'{"a" : 1234, "xxxx" : "bbbbb"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
+ union all select 1, '{"a": 1123}' as json_str union all (select 1,
'{"a" : 1234, "xxxx" : "bbbbb"}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
sql """insert into ${tableName} select 2, '{"a": 11245, "b" : {"state" :
"flat", "code" : 3}}' as json_str
- union all select 2, '{"a": 1123}' as json_str union all select 2,
'{"a" : 1234, "xxxx" : "ccccc"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
+ union all select 2, '{"a": 1123}' as json_str union all (select 2,
'{"a" : 1234, "xxxx" : "ccccc"}' as json_str from numbers("number" = "4096")
limit 4096) ;"""
sql """insert into ${tableName} select 3, '{"a" : 1234, "xxxx" : 4,
"point" : 5}' as json_str
- union all select 3, '{"a": 1123}' as json_str union all select 3,
'{"a": 11245, "b" : 42003}' as json_str from numbers("number" = "4096") limit
4096 ;"""
+ union all select 3, '{"a": 1123}' as json_str union all (select 3,
'{"a": 11245, "b" : 42003}' as json_str from numbers("number" = "4096") limit
4096) ;"""
sql """insert into ${tableName} select 4, '{"a" : 1234, "xxxx" : "eeeee",
"point" : 5}' as json_str
- union all select 4, '{"a": 1123}' as json_str union all select 4,
'{"a": 11245, "b" : 42004}' as json_str from numbers("number" = "4096") limit
4096 ;"""
+ union all select 4, '{"a": 1123}' as json_str union all (select 4,
'{"a": 11245, "b" : 42004}' as json_str from numbers("number" = "4096") limit
4096) ;"""
sql """insert into ${tableName} select 5, '{"a" : 1234, "xxxx" : "fffff",
"point" : 42000}' as json_str
- union all select 5, '{"a": 1123}' as json_str union all select 5,
'{"a": 11245, "b" : 42005}' as json_str from numbers("number" = "4096") limit
4096 ;"""
+ union all select 5, '{"a": 1123}' as json_str union all (select 5,
'{"a": 11245, "b" : 42005}' as json_str from numbers("number" = "4096") limit
4096) ;"""
// // fix cast to string tobe {}
// qt_select_b_1 """ SELECT count(cast(v['b'] as string)) FROM test_t
where cast(v['b'] as string) != '{}' """
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
