This is an automated email from the ASF dual-hosted git repository.
eldenmoon pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new 2e73b72d727 branch-4.0: [fix](regression) Stabilize variant hirachinal
array output #63610 (#63649)
2e73b72d727 is described below
commit 2e73b72d7274bcf199d125d1956049f52c7a1d00
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu May 28 10:27:34 2026 +0800
branch-4.0: [fix](regression) Stabilize variant hirachinal array output
#63610 (#63649)
Cherry-picked from #63610
Co-authored-by: lihangyu <[email protected]>
---
regression-test/data/variant_p0/predefine/variant_hirachinal.out | 2 +-
.../suites/variant_p0/predefine/variant_hirachinal.groovy | 8 ++++----
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/regression-test/data/variant_p0/predefine/variant_hirachinal.out
b/regression-test/data/variant_p0/predefine/variant_hirachinal.out
index e5ab29c3d46..7e87108b84a 100644
--- a/regression-test/data/variant_p0/predefine/variant_hirachinal.out
+++ b/regression-test/data/variant_p0/predefine/variant_hirachinal.out
@@ -12,7 +12,7 @@
6 {"a":1234,"xxxx":"kaana"}
-- !sql --
-[1, 2, 3]
+[1,2,3]
{"c":456,"d":"null","e":7.111}
-- !sql --
diff --git
a/regression-test/suites/variant_p0/predefine/variant_hirachinal.groovy
b/regression-test/suites/variant_p0/predefine/variant_hirachinal.groovy
index 8edb50af80c..ff4884380cd 100644
--- a/regression-test/suites/variant_p0/predefine/variant_hirachinal.groovy
+++ b/regression-test/suites/variant_p0/predefine/variant_hirachinal.groovy
@@ -32,9 +32,9 @@ suite("regression_test_variant_predefine_hirachinal",
"variant_type"){
sql """insert into ${table_name} select * from (select -2, '{"a": 11245,
"b" : [123, {"xx" : 1}], "c" : {"c" : 456, "d" : "null", "e" : 7.111}}' as
json_str
union all select -1, '{"a": 1123}' as json_str union all select
*, '{"a" : 1234, "xxxx" : "kaana"}' as json_str from numbers("number" =
"4096"))t order by 1 limit 4098 ;"""
qt_sql "select * from ${table_name} order by k limit 10"
- qt_sql "select cast(v['c'] as string) from ${table_name} where k = -3 or k
= -2 order by k"
+ qt_sql "select cast(v['c'] as json) from ${table_name} where k = -3 or k =
-2 order by k"
qt_sql "select v['b'] from ${table_name} where k = -3 or k = -2"
sql """insert into ${table_name} values (-3, '{"c" : 12345}')"""
- order_qt_sql1 "select cast(v['c'] as string) from var_rs where k = -3 or k
= -2 or k = -4 or (k = 1 and v['c'] = 1024) order by k"
- order_qt_sql2 "select cast(v['c'] as string) from var_rs where k = -3 or k
= -2 or k = 1 order by k, cast(v['c'] as text) limit 3"
-}
\ No newline at end of file
+ order_qt_sql1 "select cast(v['c'] as json) from var_rs where k = -3 or k =
-2 or k = -4 or (k = 1 and v['c'] = 1024) order by k"
+ order_qt_sql2 "select cast(v['c'] as json) from var_rs where k = -3 or k =
-2 or k = 1 order by k, cast(v['c'] as text) limit 3"
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
