This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 0a71bc7de88 branch-3.0 [chore](variant) fix unstable
variant_p0/load.groovy (#53201) (#53229)
0a71bc7de88 is described below
commit 0a71bc7de887e384f97caf5976f529b192bf6e35
Author: lihangyu <[email protected]>
AuthorDate: Tue Jul 15 10:19:24 2025 +0800
branch-3.0 [chore](variant) fix unstable variant_p0/load.groovy (#53201)
(#53229)
cherry-pick #53201
---
regression-test/data/variant_p0/load.out | Bin 16080 -> 16081 bytes
regression-test/suites/variant_p0/load.groovy | 4 +++-
2 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/regression-test/data/variant_p0/load.out
b/regression-test/data/variant_p0/load.out
index dbdee9d7940..f20f7628cad 100644
Binary files a/regression-test/data/variant_p0/load.out and
b/regression-test/data/variant_p0/load.out differ
diff --git a/regression-test/suites/variant_p0/load.groovy
b/regression-test/suites/variant_p0/load.groovy
index b56a97c71d6..8ec837ff18b 100644
--- a/regression-test/suites/variant_p0/load.groovy
+++ b/regression-test/suites/variant_p0/load.groovy
@@ -238,7 +238,7 @@ suite("regression_test_variant", "p0"){
// 12. jsonb values
table_name = "jsonb_values"
- create_table table_name
+ create_table.call(table_name, "DUPLICATE", "1")
sql """insert into ${table_name} values (1, '{"a" : ["123", 123,
[123]]}')"""
// FIXME array -> jsonb will parse error
// sql """insert into ${table_name} values (2, '{"a" : ["123"]}')"""
@@ -251,6 +251,8 @@ suite("regression_test_variant", "p0"){
// sql """insert into ${table_name} values (8, '{"a" : [123,
111........]}')"""
sql """insert into ${table_name} values (9, '{"a" : [123, {"a" :
1}]}')"""
sql """insert into ${table_name} values (10, '{"a" : [{"a" : 1},
123]}')"""
+ sql "select v['a'] from ${table_name} order by k"
+ trigger_and_wait_compaction(table_name, "full")
qt_sql_29 "select cast(v['a'] as string) from ${table_name} order by k"
// b? 7.111 [123,{"xx":1}] {"b":{"c":456,"e":7.111}} 456
qt_sql_30 "select v['b']['e'], v['a'], v['b'], v['b']['c'] from
jsonb_values where cast(v['b']['e'] as double) > 1;"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
