You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2025/12/03 07:44:36 UTC
(doris) branch branch-3.1 updated: branch-3.1: [fix](case) fix unstable case #58499 (#58633)
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] <41...@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 <su...@selectdb.com>
---
.../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: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org