This is an automated email from the ASF dual-hosted git repository.
zhangstar333 pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 730271768e0 [fix](test) order by clause in test_map(#27390) (#27391)
730271768e0 is described below
commit 730271768e05aef1ac39e4fc8e9b8759506013f6
Author: Jerry Hu <[email protected]>
AuthorDate: Thu Nov 23 20:10:57 2023 +0800
[fix](test) order by clause in test_map(#27390) (#27391)
pick #27390
---
.../data/datatype_p0/complex_types/test_map.out | 26 +++++++++++-----------
.../datatype_p0/complex_types/test_map.groovy | 17 +++++++-------
2 files changed, 22 insertions(+), 21 deletions(-)
diff --git a/regression-test/data/datatype_p0/complex_types/test_map.out
b/regression-test/data/datatype_p0/complex_types/test_map.out
index 00a74e74af0..4ac971fb3a1 100644
--- a/regression-test/data/datatype_p0/complex_types/test_map.out
+++ b/regression-test/data/datatype_p0/complex_types/test_map.out
@@ -1,16 +1,16 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql --
-1 {"key1":"value1"} 1 1
-1 {"key1_1":"value1_1"} 1 1
-1 {"key1":"value1"} 2 1
-1 {"key1_1":"value1_1"} 2 1
-2 {"key2":"value2", "key22":"value22"} 3 2
-2 {"key2_1":"value2_1", "key22_1":"value22_1"} 3 2
-2 {"key2_2":"value2_2", "key22_2":"value22_2"} 3 2
-2 {"key2":"value2", "key22":"value22"} 4 2
-2 {"key2_1":"value2_1", "key22_1":"value22_1"} 4 2
-2 {"key2_2":"value2_2", "key22_2":"value22_2"} 4 2
-3 {"key3":"value3", "key33":"value33", "key3333":"value333"} 5
3
-3 {"key3":"value3", "key33":"value33", "key3333":"value333"} 6
3
-4 {"key4":"value4", "key44":"value44", "key444":"value444",
"key4444":"value4444"} \N \N
+1 1 {"key1":"value1"} 1 1
+1 1 {"key1":"value1"} 2 1
+2 1 {"key1_1":"value1_1"} 1 1
+2 1 {"key1_1":"value1_1"} 2 1
+3 2 {"key2":"value2", "key22":"value22"} 3 2
+3 2 {"key2":"value2", "key22":"value22"} 4 2
+4 2 {"key2_1":"value2_1", "key22_1":"value22_1"} 3 2
+4 2 {"key2_1":"value2_1", "key22_1":"value22_1"} 4 2
+5 2 {"key2_2":"value2_2", "key22_2":"value22_2"} 3 2
+5 2 {"key2_2":"value2_2", "key22_2":"value22_2"} 4 2
+6 3 {"key3":"value3", "key33":"value33", "key3333":"value333"}
5 3
+6 3 {"key3":"value3", "key33":"value33", "key3333":"value333"}
6 3
+7 4 {"key4":"value4", "key44":"value44", "key444":"value444",
"key4444":"value4444"} \N \N
diff --git a/regression-test/suites/datatype_p0/complex_types/test_map.groovy
b/regression-test/suites/datatype_p0/complex_types/test_map.groovy
index 6a3d28c5ed0..3c146e832e7 100644
--- a/regression-test/suites/datatype_p0/complex_types/test_map.groovy
+++ b/regression-test/suites/datatype_p0/complex_types/test_map.groovy
@@ -20,18 +20,19 @@ suite("test_map") {
sql "DROP TABLE IF EXISTS `test_map_table`"
sql """
create table `test_map_table` (
+ `id` int,
`k1` int,
`value` map<text, text>
) distributed by hash(`k1`) buckets 1 properties("replication_num" =
"1");
"""
- sql 'insert into `test_map_table` values (1, {"key1": "value1"});'
- sql 'insert into `test_map_table` values (1, {"key1_1": "value1_1"});'
- sql 'insert into `test_map_table` values (2, {"key2": "value2", "key22":
"value22"});'
- sql 'insert into `test_map_table` values (2, {"key2_1": "value2_1",
"key22_1": "value22_1"});'
- sql 'insert into `test_map_table` values (2, {"key2_2": "value2_2",
"key22_2": "value22_2"});'
- sql 'insert into `test_map_table` values (3, {"key3": "value3", "key33":
"value33", "key3333": "value333"});'
- sql 'insert into `test_map_table` values (4, {"key4": "value4", "key44":
"value44", "key444": "value444", "key4444": "value4444"});'
+ sql 'insert into `test_map_table` values (1, 1, {"key1": "value1"});'
+ sql 'insert into `test_map_table` values (2, 1, {"key1_1": "value1_1"});'
+ sql 'insert into `test_map_table` values (3, 2, {"key2": "value2",
"key22": "value22"});'
+ sql 'insert into `test_map_table` values (4, 2, {"key2_1": "value2_1",
"key22_1": "value22_1"});'
+ sql 'insert into `test_map_table` values (5, 2, {"key2_2": "value2_2",
"key22_2": "value22_2"});'
+ sql 'insert into `test_map_table` values (6, 3, {"key3": "value3",
"key33": "value33", "key3333": "value333"});'
+ sql 'insert into `test_map_table` values (7, 4, {"key4": "value4",
"key44": "value44", "key444": "value444", "key4444": "value4444"});'
sql "DROP TABLE IF EXISTS `test_map_table_right`"
sql """
@@ -49,6 +50,6 @@ suite("test_map") {
sql 'insert into `test_map_table_right` values(6, 3);'
qt_sql """
- select * from test_map_table left join test_map_table_right on
test_map_table.k1 = test_map_table_right.value order by 1,3;
+ select * from test_map_table left join test_map_table_right on
test_map_table.k1 = test_map_table_right.value order by 1,2,4,5;
"""
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
