This is an automated email from the ASF dual-hosted git repository.
eldenmoon 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 90f4cb7af78 [regression-test](Variant) fix unstable case (#29648)
90f4cb7af78 is described below
commit 90f4cb7af787906388c10d7647119908070367eb
Author: lihangyu <[email protected]>
AuthorDate: Mon Jan 8 16:09:30 2024 +0800
[regression-test](Variant) fix unstable case (#29648)
---
regression-test/data/variant_p0/load.out | 6 +++---
regression-test/suites/variant_p0/load.groovy | 8 ++++----
2 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/regression-test/data/variant_p0/load.out
b/regression-test/data/variant_p0/load.out
index a3d237dc156..3a701a5db76 100644
--- a/regression-test/data/variant_p0/load.out
+++ b/regression-test/data/variant_p0/load.out
@@ -28,10 +28,10 @@
15
-- !sql_2 --
-123456789101112
1
123
123456
+123456789101112
-- !sql_4 --
123 \N {"A":123}
@@ -48,7 +48,7 @@
-- !sql_6 --
\N \N
\N \N
-"123" \N
+123 \N
\N 1
\N 123
1.10111 1800
@@ -143,7 +143,7 @@
[123]
-- !sql_25 --
-50000 55000.00000000226 6150000
+50000 54999.99999995274 6150000
-- !sql_26 --
5000
diff --git a/regression-test/suites/variant_p0/load.groovy
b/regression-test/suites/variant_p0/load.groovy
index a8793bddec1..580b15524ae 100644
--- a/regression-test/suites/variant_p0/load.groovy
+++ b/regression-test/suites/variant_p0/load.groovy
@@ -112,7 +112,7 @@ suite("regression_test_variant", "variant_type"){
create_table table_name
sql """insert into ${table_name} values (1, '{"c" : "123"}');"""
sql """insert into ${table_name} values (2, '{"c" : 123}');"""
- sql """insert into ${table_name} values (3, '{"cc" : [123]}');"""
+ sql """insert into ${table_name} values (3, '{"cc" : [123.0]}');"""
sql """insert into ${table_name} values (4, '{"cc" : [123.1]}');"""
sql """insert into ${table_name} values (5, '{"ccc" : 123}');"""
sql """insert into ${table_name} values (6, '{"ccc" : 123321}');"""
@@ -135,11 +135,11 @@ suite("regression_test_variant", "variant_type"){
sql """insert into ${table_name} values (2, '{"A" : 1}');"""
sql """insert into ${table_name} values (4, '{"A" : 123456}');"""
sql """insert into ${table_name} values (8, '{"A" :
123456789101112}');"""
- qt_sql_2 "select v:A from ${table_name} order by cast(v:A as int)"
+ qt_sql_2 "select v:A from ${table_name} order by cast(v:A as bigint)"
sql """insert into ${table_name} values (12, '{"AA" : [123456]}');"""
sql """insert into ${table_name} values (14, '{"AA" :
[123456789101112]}');"""
// qt_sql_3 "select v:AA from ${table_name} where size(v:AA) > 0 order
by k"
- qt_sql_4 "select v:A, v:AA, v from ${table_name} order by k"
+ qt_sql_4 "select cast(v:A as string), v:AA, v from ${table_name} order
by k"
qt_sql_5 "select v:A, v:AA, v, v from ${table_name} where cast(v:A as
bigint) > 123 order by k"
sql """insert into ${table_name} values (16, '{"a" : 123.0, "A" :
191191, "c": 123}');"""
@@ -148,7 +148,7 @@ suite("regression_test_variant", "variant_type"){
// sql """insert into ${table_name} values (12, '{"a" : [123]}, "c":
"123456"');"""
sql """insert into ${table_name} values (22, '{"a" : 1.1111, "A" :
17211, "c" : 111111}');"""
sql "sync"
- qt_sql_6 "select v:a, v:A from ${table_name} order by cast(v:A as
bigint), k"
+ qt_sql_6 "select cast(v:a as string), v:A from ${table_name} order by
cast(v:A as bigint), k"
qt_sql_7 "select k, v:A from ${table_name} where cast(v:A as bigint)
>= 1 order by cast(v:A as bigint), k"
// FIXME: if not cast, then v:a could return "123" or 123 which is
none determinately
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
