This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
commit e44ddbd63d172a99763e10c43b2ec43dca6ddfd2
Author: amory <wangqian...@selectdb.com>
AuthorDate: Fri Oct 13 11:39:29 2023 +0800
[FIX](regresstest) fix cases for test_nested_types_insert_into_with_s3
(#25228)
---
.../test_nested_types_insert_into_with_s3.out | 95 ++--------------------
.../test_nested_types_insert_into_with_s3.groovy | 7 ++
2 files changed, 12 insertions(+), 90 deletions(-)
diff --git
a/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
b/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
index aaa91af32c0..ae5ccad04ac 100644
---
a/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
+++
b/regression-test/data/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.out
@@ -15,13 +15,13 @@
0 [0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 0, 1, 1, 1, 1,
1, 0, 0, 1, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 1, 0, 1, 1, 0,
1, 1, 0, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1,
1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0]
[-1083129163, -963910427, 1519845280, -1958563757, 1057667264, 886496321,
662551246, 126037819, -469806662, -935616127, -1926402015, -1511954706,
-1787866480, -80725363, -1564632457, -10507 [...]
-- !sql_arr_parquet_doris --
-0 [1, 1, 1, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1, 0,
0, 0, 1, 0, 0, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0,
0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 1, 1,
0, 1, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1]
[-110, -104, -65, -121, 110, 66, 55, 4, -114, 35, 39, -59, 13, 103, -123, 11,
-94, 59, -88, -54, 31, 66, -66, 57, -7, 41, 93, 75, -73, 4, -23, 42, -124, -9,
42, -62, -93, -112, -65, 54, -14 [...]
+0 [0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 0, 1, 1, 1, 1,
1, 0, 0, 1, 0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 1, 0, 1, 1, 0,
1, 1, 0, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1,
1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0]
[-75, -27, -96, 83, -64, 65, -50, 59, -70, -127, 33, -18, -112, -115, 119, -8,
-21, 105, 37, -79, -80, -75, 122, -34, -128, 44, 76, 20, 55, 36, 99, 81, 114,
22, 4, 94, -4, 12, 118, 110, 115 [...]
-- !sql_arr_parquet_s3 --
0 [[], [0], [0, 0, 1, 1, 1, 0, 1, 0, 0], [0, 0, 0, 1, 0, 1, 0], [1], [0,
0, 1, 0, 1, 0, 0], [0, 0], [0, 0, 1, 0, 0, 1, 0], [1, 0, 0, 0, 1, 1, 0], [0, 1,
0, 0], [1, 1, 0, 0, 0, 0, 1], [1, 1, 0, 0, 1, 0, 1], [1, 0, 1, 1, 1], [1, 0, 1,
0, 0, 1, 0, 0, 1], [0, 0, 1, 0, 0, 0], [0, 1, 1, 1], [0, 1, 0, 0, 0, 0], [1],
[1, 0, 1, 1, 1, 1], [], [1, 1, 1, 1, 0], [0], [0, 1], [1, 1, 0, 1, 1], [0, 1,
0, 1, 1, 1, 1, 0, 0], [0, 1, 0, 0, 0, 1], [1, 0, 1, 0, 1], [0, 0, 0, 1], [0,
1], [], [1, 1, 1, 1, 1], [ [...]
-- !sql_arr_parquet_doris --
-0 [[0, 1], [0, 1, 0, 0, 1], [1, 1, 1, 1, 1, 0], [1, 1, 0, 0], [0], [1, 0,
0, 1, 0], [0, 1, 0], [1, 1, 0, 1, 1, 0, 1, 1], [1, 0, 1, 0, 1, 1], [], [0, 1,
1, 1, 0, 0, 1], [], [], [1, 0, 0, 1], [0, 1, 1, 0, 1, 1, 1, 1], [0, 0], [0, 0,
1, 0], [1, 0, 0], [1, 1, 1, 0, 0], [1, 1, 0], [], [0], [0, 1], [1, 0], [], [0,
1, 1, 0, 0], [], [1, 0, 0, 1, 0, 1], [1, 0, 1, 1, 0], [1, 1], [1, 1], [1, 1, 0,
1, 0, 1], [0, 0, 0, 1, 1, 1, 1, 1, 1], [1, 1, 1, 1], [0, 0, 1, 1, 1], [0], [0,
0, 0], [0, 0, 1, 0, 0, [...]
+0 [[], [0], [0, 0, 1, 1, 1, 0, 1, 0, 0], [0, 0, 0, 1, 0, 1, 0], [1], [0,
0, 1, 0, 1, 0, 0], [0, 0], [0, 0, 1, 0, 0, 1, 0], [1, 0, 0, 0, 1, 1, 0], [0, 1,
0, 0], [1, 1, 0, 0, 0, 0, 1], [1, 1, 0, 0, 1, 0, 1], [1, 0, 1, 1, 1], [1, 0, 1,
0, 0, 1, 0, 0, 1], [0, 0, 1, 0, 0, 0], [0, 1, 1, 1], [0, 1, 0, 0, 0, 0], [1],
[1, 0, 1, 1, 1, 1], [], [1, 1, 1, 1, 0], [0], [0, 1], [1, 1, 0, 1, 1], [0, 1,
0, 1, 1, 1, 1, 0, 0], [0, 1, 0, 0, 0, 1], [1, 0, 1, 0, 1], [0, 0, 0, 1], [0,
1], [], [1, 1, 1, 1, 1], [ [...]
-- !sql_arr_orc_s3 --
[{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1,
1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1},
{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1,
1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1},
{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1,
1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1},
{0:1, 1:1}, {0:1, 1:1}, [...]
@@ -45,75 +45,25 @@
[{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0,
0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0},
{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0,
0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0},
{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0,
0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0},
{1:0, 0:0}, {1:0, 0:0}, [...]
-- !sql_arr_parquet_doris --
-[{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1,
1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1},
{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1,
1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1},
{0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1,
1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1}, {0:1, 1:1},
{0:1, 1:1}, {0:1, 1:1}, [...]
+[{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0,
0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0},
{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0,
0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0},
{1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0,
0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0}, {1:0, 0:0},
{1:0, 0:0}, {1:0, 0:0}, [...]
-- !sql_arr_parquet_s3 --
{0:1, 1:0} {9223372036854775807:-9223372036854775807,
-9223372036854775808:-9223372036854775805,
-9223372036854775807:-9223372036854775808,
-9223372036854775806:-9223372036854775807,
-9223372036854775805:-9223372036854775807} {1059.941:788218.105,
542258.211:951433.817, 854102.627:762104.404, 971920.736:69587.055,
739777.517:306829.134, 564657.809:169026.506, 796536.158:647878.524,
737096.019:797021.625, 163990.318:205839.086, 685585.822:253088.443,
185680.043:853018.363, 945924.048:2024 [...]
-- !sql_arr_parquet_doris --
-{0:1, 1:0} {-9223372036854775808:-9223372036854775807,
-9223372036854775807:-9223372036854775805,
-9223372036854775806:-9223372036854775807,
-9223372036854775805:9223372036854775807,
9223372036854775807:-9223372036854775806} {1197.432:955434.191,
2220.680:624922.648, 2449.230:575914.155, 7803.790:278700.206,
43331.216:971641.903, 46014.780:271049.371, 58978.057:8615.804,
75724.725:533484.354, 76289.362:777656.860, 86530.261:848675.560,
94144.098:454944.688, 95938.056:649967.716, 108260.2 [...]
+{0:1, 1:0} {9223372036854775807:-9223372036854775807,
-9223372036854775808:-9223372036854775805,
-9223372036854775807:-9223372036854775808,
-9223372036854775806:-9223372036854775807,
-9223372036854775805:-9223372036854775807} {1059.941:788218.105,
542258.211:951433.817, 854102.627:762104.404, 971920.736:69587.055,
739777.517:306829.134, 564657.809:169026.506, 796536.158:647878.524,
737096.019:797021.625, 163990.318:205839.086, 685585.822:253088.443,
185680.043:853018.363, 945924.048:2024 [...]
-- !sql_arr_parquet_s3 --
{1:[0, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0,
0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0,
0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0,
0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1], 0:[1, 0,
1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 1, 0,
0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1,
0, 0, 1, 1, 1, 1, 0, 0 [...]
-- !sql_arr_parquet_doris --
-{0:[0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1,
0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0,
1, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0,
1, 1, 0, 1, 0, 0, 1, 1, 1, 1, 0, 0, 1, 0, 0, 1, 1, 1, 1, 0, 0, 0, 1], 1:[1, 0,
0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1,
0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1,
0, 1, 0, 1, 0, 1, 1, 1 [...]
+{1:[0, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0,
0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0,
0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0,
0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1], 0:[1, 0,
1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 1, 0,
0, 0, 1, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 0, 1,
0, 0, 1, 1, 1, 1, 0, 0 [...]
-- !sql_arr --
100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-- !sql_arr --
100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-- !sql_arr --
100
@@ -142,43 +92,8 @@
100
100
100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-100
-- !sql_map_arr --
-83
-84
-86
-81
-84
-78
-83
-86
-84
-81
84
83
82
diff --git
a/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
b/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
index ba7eb3e8010..2b59e76aa29 100644
---
a/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
+++
b/regression-test/suites/datatype_p0/nested_types/query/test_nested_types_insert_into_with_s3.groovy
@@ -216,8 +216,13 @@ suite("test_nested_types_insert_into_with_s3", "p0") {
"""
qt_sql_arr_orc_doris """ select * from ${table_names[i]} order by k1
limit 1; """
+ sql "sync"
+ sql "truncate table ${table_names[i]} "
}
+ // here need truncate table for insert into same table with parquet file
which data is not same with orc file,
+ // so select from parquet will fail
+
for (int i = 0; i < 2; ++i) {
qt_sql_arr_parquet_s3 """
@@ -256,6 +261,8 @@ suite("test_nested_types_insert_into_with_s3", "p0") {
"format" = "orc");"""
qt_sql_arr_orc_doris """ select
c_bool,c_bigint,c_decimalv3,c_datetimev2 from ${table_names[i]} order by k1
limit 1; """
+ sql "sync"
+ sql "truncate table ${table_names[i]} "
}
for (int i = 2; i < parquetFiles.size(); ++i) {
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
