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 c34c986ffec [opt](regression-test) More test case to trace problem of
datetime v2 round (#37520)
c34c986ffec is described below
commit c34c986ffec949507eda3e21d1de1173e3f8c96d
Author: zhiqiang <[email protected]>
AuthorDate: Wed Jul 10 19:30:32 2024 +0800
[opt](regression-test) More test case to trace problem of datetime v2 round
(#37520)
We have some problem in other rep. The problem can not be reproduced on
master, so refine the test case to trace problem.
---
.../array_functions/test_array_with_scale_type.out | 6 ++
.../test_array_with_scale_type.groovy | 88 +++++++++++-----------
2 files changed, 52 insertions(+), 42 deletions(-)
diff --git
a/regression-test/data/query_p0/sql_functions/array_functions/test_array_with_scale_type.out
b/regression-test/data/query_p0/sql_functions/array_functions/test_array_with_scale_type.out
index 8d3a74e67b2..54a30a24eda 100644
---
a/regression-test/data/query_p0/sql_functions/array_functions/test_array_with_scale_type.out
+++
b/regression-test/data/query_p0/sql_functions/array_functions/test_array_with_scale_type.out
@@ -1,4 +1,10 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select_varify_datetime --
+2022-12-01T22:23:25
+2022-12-02T22:23:25
+\N
+\N
+
-- !select --
2022-12-02T22:23:24.999999
diff --git
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_with_scale_type.groovy
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_with_scale_type.groovy
index cbd6bcd01cf..0d60daff644 100644
---
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_with_scale_type.groovy
+++
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_with_scale_type.groovy
@@ -18,9 +18,9 @@
suite("test_array_with_scale_type") {
def tableName = "test_array_with_scale_type_table"
- sql "DROP TABLE IF EXISTS ${tableName}"
+ sql "DROP TABLE IF EXISTS test_array_with_scale_type_table"
sql """
- CREATE TABLE IF NOT EXISTS `${tableName}` (
+ CREATE TABLE IF NOT EXISTS `test_array_with_scale_type_table` (
`uid` int(11) NULL COMMENT "",
`c_datetimev2` datetimev2(3) NULL COMMENT "",
`c_decimal` decimal(8,3) NULL COMMENT "",
@@ -39,7 +39,7 @@ suite("test_array_with_scale_type") {
// load with same insert into data
streamLoad {
- table "${tableName}"
+ table "test_array_with_scale_type_table"
set 'column_separator', '|'
@@ -59,71 +59,75 @@ suite("test_array_with_scale_type") {
assertEquals(0, json.NumberUnselectedRows)
}
}
- sql """INSERT INTO ${tableName} values
+ sql """
+ INSERT INTO test_array_with_scale_type_table values
(1,"2022-12-01 22:23:24.999999",22.6789,33.6789,["2022-12-01
22:23:24.999999","2022-12-01
23:23:24.999999"],[22.6789,33.6789],[22.6789,33.6789]),
- (2,"2022-12-02 22:23:24.999999",23.6789,34.6789,["2022-12-02
22:23:24.999999","2022-12-02
23:23:24.999999"],[23.6789,34.6789],[22.6789,34.6789])
+ (2,"2022-12-02 22:23:24.999999",23.6789,34.6789,["2022-12-02
22:23:24.999999","2022-12-02
23:23:24.999999"],[23.6789,34.6789],[22.6789,34.6789]);
+ """
+ qt_select_varify_datetime """
+ SELECT c_datetimev2 from test_array_with_scale_type_table order by
uid;
"""
qt_select "select array_min(array(cast ('2022-12-02 22:23:24.999999'
as datetimev2(6))))"
qt_select "select array_min(array(cast ('2022-12-02 22:23:24.999999'
as datetimev2(3))))"
- qt_select "select array_min(c_array_datetimev2) from ${tableName}
order by uid"
+ qt_select "select array_min(c_array_datetimev2) from
test_array_with_scale_type_table order by uid"
qt_select "select array_max(array(cast ('2022-12-02 22:23:24.999999'
as datetimev2(6))))"
qt_select "select array_max(array(cast ('2022-12-02 22:23:24.999999'
as datetimev2(3))))"
- qt_select "select array_max(c_array_datetimev2) from ${tableName}
order by uid"
+ qt_select "select array_max(c_array_datetimev2) from
test_array_with_scale_type_table order by uid"
qt_select "select array_min(array(cast (22.99 as decimalv3)))"
qt_select "select array_min(array(cast (22.99 as decimalv3(10,3))))"
qt_select "select array_min(array(cast (22.99 as decimalv3(10,6))))"
- qt_select "select array_min(c_array_decimal) from ${tableName} order
by uid"
- qt_select "select array_min(c_array_decimalv3) from ${tableName}
order by uid"
+ qt_select "select array_min(c_array_decimal) from
test_array_with_scale_type_table order by uid"
+ qt_select "select array_min(c_array_decimalv3) from
test_array_with_scale_type_table order by uid"
qt_select "select array_max(array(cast (22.99 as decimalv3)))"
qt_select "select array_max(array(cast (22.99 as decimalv3(10,3))))"
qt_select "select array_max(array(cast (22.99 as decimalv3(10,6))))"
- qt_select "select array_max(c_array_decimal) from ${tableName} order
by uid"
- qt_select "select array_max(c_array_decimalv3) from ${tableName}
order by uid"
+ qt_select "select array_max(c_array_decimal) from
test_array_with_scale_type_table order by uid"
+ qt_select "select array_max(c_array_decimalv3) from
test_array_with_scale_type_table order by uid"
- qt_select "select array(c_decimal) from ${tableName} order by uid"
- qt_select "select array(cast (24.99 as decimalv3(10,3)),cast (25.99
as decimalv3(10,3))) from ${tableName} order by uid"
+ qt_select "select array(c_decimal) from
test_array_with_scale_type_table order by uid"
+ qt_select "select array(cast (24.99 as decimalv3(10,3)),cast (25.99
as decimalv3(10,3))) from test_array_with_scale_type_table order by uid"
qt_select "select array(cast (24.99 as decimalv3(10,3)),cast (25.99
as decimalv3(10,3)))"
- qt_select "select array(c_decimalv3) from ${tableName} order by uid"
- qt_select "select array(cast (24.99 as decimalv3(10,3)),cast (25.99
as decimalv3(10,3))) from ${tableName} order by uid"
+ qt_select "select array(c_decimalv3) from
test_array_with_scale_type_table order by uid"
+ qt_select "select array(cast (24.99 as decimalv3(10,3)),cast (25.99
as decimalv3(10,3))) from test_array_with_scale_type_table order by uid"
qt_select "select array(cast (24.99 as decimalv3(10,3)),cast (25.99
as decimalv3(10,3)))"
- qt_select "select array(c_datetimev2) from ${tableName} order by uid"
- qt_select "select array(cast ('2022-12-02 22:23:24.999999' as
datetimev2(3)),cast ('2022-12-02 22:23:23.997799' as datetimev2(3))) from
${tableName} order by uid"
+ qt_select "select array(c_datetimev2) from
test_array_with_scale_type_table order by uid"
+ qt_select "select array(cast ('2022-12-02 22:23:24.999999' as
datetimev2(3)),cast ('2022-12-02 22:23:23.997799' as datetimev2(3))) from
test_array_with_scale_type_table order by uid"
qt_select "select array(cast ('2022-12-02 22:23:24.999999' as
datetimev2(3)),cast ('2022-12-02 22:23:23.997799' as datetimev2(3)))"
- qt_select """select array_apply(c_array_datetimev2, "=", '2022-12-02
22:23:24.999999') from ${tableName} order by uid"""
- qt_select """select array_apply(c_array_datetimev2, ">", '2022-12-01
22:23:24.999999') from ${tableName} order by uid"""
- qt_select """select array_apply(c_array_datetimev2, ">", null) from
${tableName} order by uid"""
- qt_select """select array_apply(c_array_decimal, "=", 22.679) from
${tableName} order by uid"""
- qt_select """select array_apply(c_array_decimal, ">=", 22.1) from
${tableName} order by uid"""
- qt_select """select array_apply(c_array_decimal, ">=", null) from
${tableName} order by uid"""
+ qt_select """select array_apply(c_array_datetimev2, "=", '2022-12-02
22:23:24.999999') from test_array_with_scale_type_table order by uid"""
+ qt_select """select array_apply(c_array_datetimev2, ">", '2022-12-01
22:23:24.999999') from test_array_with_scale_type_table order by uid"""
+ qt_select """select array_apply(c_array_datetimev2, ">", null) from
test_array_with_scale_type_table order by uid"""
+ qt_select """select array_apply(c_array_decimal, "=", 22.679) from
test_array_with_scale_type_table order by uid"""
+ qt_select """select array_apply(c_array_decimal, ">=", 22.1) from
test_array_with_scale_type_table order by uid"""
+ qt_select """select array_apply(c_array_decimal, ">=", null) from
test_array_with_scale_type_table order by uid"""
- qt_select """select array_concat(array(cast ('2022-12-02
22:23:24.123123' as datetimev2(3)),cast ('2022-12-02 22:23:23.123123' as
datetimev2(3)))) from ${tableName} order by uid"""
- qt_select """select array_concat(c_array_datetimev2) from ${tableName}
order by uid"""
- qt_select """select array_concat(c_array_datetimev2, array(cast
('2022-12-02 22:23:24.123123' as datetimev2(3)),cast ('2022-12-02
22:23:23.123123' as datetimev2(3)))) from ${tableName} order by uid"""
- qt_select """select array_concat(c_array_decimal, c_array_decimal,
c_array_decimal) from ${tableName} order by uid"""
- qt_select """select array_zip(c_array_decimal, c_array_decimal,
c_array_datetimev2, c_array_decimal) from ${tableName} order by uid"""
+ qt_select """select array_concat(array(cast ('2022-12-02
22:23:24.123123' as datetimev2(3)),cast ('2022-12-02 22:23:23.123123' as
datetimev2(3)))) from test_array_with_scale_type_table order by uid"""
+ qt_select """select array_concat(c_array_datetimev2) from
test_array_with_scale_type_table order by uid"""
+ qt_select """select array_concat(c_array_datetimev2, array(cast
('2022-12-02 22:23:24.123123' as datetimev2(3)),cast ('2022-12-02
22:23:23.123123' as datetimev2(3)))) from test_array_with_scale_type_table
order by uid"""
+ qt_select """select array_concat(c_array_decimal, c_array_decimal,
c_array_decimal) from test_array_with_scale_type_table order by uid"""
+ qt_select """select array_zip(c_array_decimal, c_array_decimal,
c_array_datetimev2, c_array_decimal) from test_array_with_scale_type_table
order by uid"""
- qt_select """select array_zip(array(cast ('2022-12-02 22:23:24.123123'
as datetimev2(3)),cast ('2022-12-02 22:23:23.123123' as datetimev2(3)))) from
${tableName} order by uid"""
- qt_select """select array_zip(c_array_datetimev2) from ${tableName}
order by uid"""
- qt_select """select array_zip(c_array_datetimev2, array(cast
('2022-12-02 22:23:24.123123' as datetimev2(3)),cast ('2022-12-02
22:23:23.123123' as datetimev2(3)))) from ${tableName} order by uid"""
+ qt_select """select array_zip(array(cast ('2022-12-02 22:23:24.123123'
as datetimev2(3)),cast ('2022-12-02 22:23:23.123123' as datetimev2(3)))) from
test_array_with_scale_type_table order by uid"""
+ qt_select """select array_zip(c_array_datetimev2) from
test_array_with_scale_type_table order by uid"""
+ qt_select """select array_zip(c_array_datetimev2, array(cast
('2022-12-02 22:23:24.123123' as datetimev2(3)),cast ('2022-12-02
22:23:23.123123' as datetimev2(3)))) from test_array_with_scale_type_table
order by uid"""
- qt_select "select array_pushfront(array(cast ('2022-12-02
22:23:24.123123' as datetimev2(3))),cast ('2022-12-02 22:23:23.123123' as
datetimev2(3))) from ${tableName} order by uid"
- qt_select "select array_pushfront(c_array_datetimev2, cast
('2023-03-08 23:23:23.123123' as datetimev2(3))) from ${tableName} order by uid"
- qt_select "select c_datetimev2, c_array_datetimev2,
array_pushfront(c_array_datetimev2, c_datetimev2) from ${tableName} order by
c_datetimev2, uid"
- qt_select "select array_pushfront(c_array_decimal, cast (25.99 as
decimalv3(10,3))) from ${tableName} order by uid"
- qt_select "select c_decimal, c_array_decimal,
array_pushfront(c_array_decimal, c_decimal) from ${tableName} order by
c_decimal, uid"
+ qt_select "select array_pushfront(array(cast ('2022-12-02
22:23:24.123123' as datetimev2(3))),cast ('2022-12-02 22:23:23.123123' as
datetimev2(3))) from test_array_with_scale_type_table order by uid"
+ qt_select "select array_pushfront(c_array_datetimev2, cast
('2023-03-08 23:23:23.123123' as datetimev2(3))) from
test_array_with_scale_type_table order by uid"
+ qt_select "select c_datetimev2, c_array_datetimev2,
array_pushfront(c_array_datetimev2, c_datetimev2) from
test_array_with_scale_type_table order by c_datetimev2, uid"
+ qt_select "select array_pushfront(c_array_decimal, cast (25.99 as
decimalv3(10,3))) from test_array_with_scale_type_table order by uid"
+ qt_select "select c_decimal, c_array_decimal,
array_pushfront(c_array_decimal, c_decimal) from
test_array_with_scale_type_table order by c_decimal, uid"
- qt_select "select array_pushback(array(cast ('2022-12-02
22:23:24.123123' as datetimev2(3))),cast ('2022-12-02 22:23:23.123123' as
datetimev2(3))) from ${tableName}"
- qt_select "select array_pushback(c_array_datetimev2, cast ('2023-03-08
23:23:23.123123' as datetimev2(3))) from ${tableName}"
- qt_select "select c_datetimev2, c_array_datetimev2,
array_pushback(c_array_datetimev2, c_datetimev2) from ${tableName} order by
c_datetimev2, uid"
- qt_select "select array_pushback(c_array_decimal, cast (25.99 as
decimalv3(10,3))) from ${tableName} order by uid"
- qt_select "select c_decimal, c_array_decimal,
array_pushback(c_array_decimal, c_decimal) from ${tableName} order by
c_decimal, uid"
+ qt_select "select array_pushback(array(cast ('2022-12-02
22:23:24.123123' as datetimev2(3))),cast ('2022-12-02 22:23:23.123123' as
datetimev2(3))) from test_array_with_scale_type_table"
+ qt_select "select array_pushback(c_array_datetimev2, cast ('2023-03-08
23:23:23.123123' as datetimev2(3))) from test_array_with_scale_type_table"
+ qt_select "select c_datetimev2, c_array_datetimev2,
array_pushback(c_array_datetimev2, c_datetimev2) from
test_array_with_scale_type_table order by c_datetimev2, uid"
+ qt_select "select array_pushback(c_array_decimal, cast (25.99 as
decimalv3(10,3))) from test_array_with_scale_type_table order by uid"
+ qt_select "select c_decimal, c_array_decimal,
array_pushback(c_array_decimal, c_decimal) from
test_array_with_scale_type_table order by c_decimal, uid"
qt_select "select array_cum_sum(array(cast (22.99 as decimal), cast
(-11.99 as decimal)))"
qt_select "select array_cum_sum(array(cast (22.99 as decimal(10,3)),
cast (-11.99 as decimal(10,3))))"
qt_select "select array_cum_sum(array(cast (22.99 as decimal(10,6)),
cast (-11.991 as decimal(10,6))))"
- qt_select "select array_cum_sum(c_array_decimal) from ${tableName}
order by uid"
+ qt_select "select array_cum_sum(c_array_decimal) from
test_array_with_scale_type_table order by uid"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
