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 9c3ee8dafc0cd429dd1bea0e3c26bb2249d11493 Author: morrySnow <[email protected]> AuthorDate: Tue Aug 29 18:30:16 2023 +0800 [fix](view) The parameter positions of timestamp diff function to sql are reversed (#23601) --- regression-test/data/view_p0/view_p0.out | 7 +++ regression-test/suites/view_p0/view_p0.groovy | 85 +++++++++++++++++++++++++++ 2 files changed, 92 insertions(+) diff --git a/regression-test/data/view_p0/view_p0.out b/regression-test/data/view_p0/view_p0.out index d665718ba0..ff952fdaa7 100644 --- a/regression-test/data/view_p0/view_p0.out +++ b/regression-test/data/view_p0/view_p0.out @@ -8,3 +8,10 @@ -- !sql -- 1 +-- !sql -- +1 2023-08-01 DORID_FIELD1 DORID_FIELD2 ["cat", "dog"] cat +1 2023-08-01 DORID_FIELD1 DORID_FIELD2 ["cat", "dog"] dog + +-- !sql -- +960 + diff --git a/regression-test/suites/view_p0/view_p0.groovy b/regression-test/suites/view_p0/view_p0.groovy index 0d513cff55..bb6a5ab5a6 100644 --- a/regression-test/suites/view_p0/view_p0.groovy +++ b/regression-test/suites/view_p0/view_p0.groovy @@ -38,4 +38,89 @@ suite("view_p0") { qt_sql "select * from test_varchar_view;" qt_sql "select cast( id as varchar(*)) from test_view_table;" + + // array view + sql """DROP TABLE IF EXISTS test_array_tbl_1""" + + sql """ + CREATE TABLE `test_array_tbl_1` ( + `id` int(11) NULL COMMENT "", + `field1` DATEV2, + `field2` varchar(1000), + `field3` varchar(1000), + `field4` ARRAY<STRING>, + `field5` ARRAY<STRING> + ) ENGINE=OLAP + DUPLICATE KEY(`id`) + COMMENT "OLAP" + DISTRIBUTED BY HASH(`id`) BUCKETS 1 + PROPERTIES ( + "replication_allocation" = "tag.location.default: 1", + "in_memory" = "false", + "storage_format" = "V2" + ); + """ + + sql """DROP TABLE IF EXISTS test_array_tbl_2""" + sql """ + CREATE TABLE `test_array_tbl_2` ( + `id` int(11) NULL COMMENT "", + `field1` DATEV2, + `field2` varchar(1000), + `field3` varchar(1000), + `field4` ARRAY<STRING>, + `field5` ARRAY<STRING> + ) ENGINE=OLAP + DUPLICATE KEY(`id`) + COMMENT "OLAP" + DISTRIBUTED BY HASH(`id`) BUCKETS 1 + PROPERTIES ( + "replication_allocation" = "tag.location.default: 1", + "in_memory" = "false", + "storage_format" = "V2" + ); + """ + sql """INSERT into test_array_tbl_1 values(1,'2023-08-01',"DORID_FIELD1","DORID_FIELD2",["cat","dog"],["cat","dog"])""" + + sql """INSERT into test_array_tbl_2 values(1,'2023-08-01',"DORID_FIELD1","DORID_FIELD2",["cat","dog"],["cat","dog"])""" + + sql """DROP VIEW IF EXISTS test_element_at_view""" + + sql """ + CREATE VIEW test_element_at_view AS + SELECT id, dm, pn, field3, ms, ek[sm] AS ek + FROM + ( + SELECT + id, dm, pn, field3, ek, ms, tmp, + SUM(tmp) OVER (PARTITION BY id, dm, pn, field3 ORDER BY id ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS sm + FROM + ( + SELECT + a.id AS id, + a.field1 AS dm, + a.field2 AS pn, + field3, + field4 AS ek, + field5 AS ms, + 1 AS tmp + FROM + ( + SELECT * FROM test_array_tbl_1 LATERAL VIEW explode(field4) test_array_tbl_2 AS mension + ) a + ) b + ) c; + """ + qt_sql "select * from test_element_at_view;" + + sql "drop view if exists test_element_at_view" + + sql "drop view if exists test_time_diff" + + sql "create view test_time_diff as select minutes_diff('2023-01-16 10:05:04', '2023-01-15 18:05:04')" + + qt_sql "select * from test_time_diff" + + sql "drop view if exists test_time_diff" + } --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
