This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 a53d46e317 [Fix](array function) fix array_pushfront function with
DecimalV3 #17760
a53d46e317 is described below
commit a53d46e317b6a1c416340c4b5d4ffbb01e3a38ef
Author: ZhangYu0123 <[email protected]>
AuthorDate: Thu Mar 16 09:03:52 2023 +0800
[Fix](array function) fix array_pushfront function with DecimalV3 #17760
Support array_pushfront function with DecimalV3
Issue Number: close #xxx
---
.../main/java/org/apache/doris/analysis/FunctionCallExpr.java | 1 +
.../sql_functions/array_functions/test_array_functions.out | 11 +++++++++++
.../array_functions/test_array_functions_by_literal.out | 2 ++
.../sql_functions/array_functions/test_array_functions.groovy | 1 +
.../array_functions/test_array_functions_by_literal.groovy | 1 +
5 files changed, 16 insertions(+)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/analysis/FunctionCallExpr.java
b/fe/fe-core/src/main/java/org/apache/doris/analysis/FunctionCallExpr.java
index 30b40088db..ffd6f766a8 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/analysis/FunctionCallExpr.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/analysis/FunctionCallExpr.java
@@ -1424,6 +1424,7 @@ public class FunctionCallExpr extends Expr {
|| fnName.getFunction().equalsIgnoreCase("array_slice")
||
fnName.getFunction().equalsIgnoreCase("array_popback")
||
fnName.getFunction().equalsIgnoreCase("array_popfront")
+ ||
fnName.getFunction().equalsIgnoreCase("array_pushfront")
|| fnName.getFunction().equalsIgnoreCase("reverse")
||
fnName.getFunction().equalsIgnoreCase("%element_slice%")
||
fnName.getFunction().equalsIgnoreCase("array_concat")
diff --git
a/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions.out
b/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions.out
index d85cf5ff5e..7070d95e2b 100644
---
a/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions.out
+++
b/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions.out
@@ -1292,6 +1292,17 @@
8 \N
9 \N
+-- !select --
+1 [NULL, 111.111, 222.222]
+2 [NULL, 3333.333, 4444.444]
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+
-- !select --
[1, 2, 3] 1,2,3
[4] 4
diff --git
a/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out
b/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out
index 006a648a6b..08594b6e8b 100644
---
a/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out
+++
b/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out
@@ -749,3 +749,5 @@ _
-- !sql --
[2023-03-08 16:23:54.999, 2023-03-05 12:23:24.999, 2023-03-05 15:23:23.997]
+-- !sql --
+[333.333, 111.111, 222.222]
diff --git
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions.groovy
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions.groovy
index 12f5628e02..0db24bd6a2 100644
---
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions.groovy
+++
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions.groovy
@@ -198,6 +198,7 @@ suite("test_array_functions") {
qt_select "SELECT k1, array_pushfront(k8, cast('2023-03-05' as datev2))
FROM ${tableName} ORDER BY k1"
qt_select "SELECT k1, array_pushfront(k10, cast('2023-03-08 10:30:00.999'
as datetimev2(3))) FROM ${tableName} ORDER BY k1"
qt_select "SELECT k1, array_pushfront(k10, null) FROM ${tableName} ORDER
BY k1"
+ qt_select "SELECT k1, array_pushfront(k12, null) FROM ${tableName} ORDER
BY k1"
qt_select "select k2, bitmap_to_string(bitmap_from_array(k2)) from
${tableName} order by k1;"
diff --git
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy
index 906cb8ceb9..db245d349a 100644
---
a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy
+++
b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy
@@ -301,6 +301,7 @@ suite("test_array_functions_by_literal") {
qt_sql "select array_pushfront(array(cast (12.99 as decimal(10,3)), cast
(34.99 as decimal(10,3))), cast (999.28 as decimal(10,3)))"
qt_sql "select array_pushfront(array(cast ('2023-03-05' as datev2), cast
('2023-03-04' as datev2)), cast ('2023-02-05' as datev2))"
qt_sql "select array_pushfront(array(cast ('2023-03-05 12:23:24.999' as
datetimev2(3)),cast ('2023-03-05 15:23:23.997' as datetimev2(3))), cast
('2023-03-08 16:23:54.999' as datetimev2(3)))"
+ qt_sql "select array_pushfront(array(cast (111.111 as decimalv3(6,3)),cast
(222.222 as decimalv3(6,3))), cast (333.333 as decimalv3(6,3)))"
// abnormal test
try {
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
