You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "changxue (Jira)" <ji...@apache.org> on 2022/11/14 08:10:00 UTC
[jira] [Commented] (IOTDB-4926) [udf]should return error and error message when the key of parameter attributes is not quoted
[ https://issues.apache.org/jira/browse/IOTDB-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17633585#comment-17633585 ]
changxue commented on IOTDB-4926:
---------------------------------
反引号(back quotes)也应该处理，它也不报错，一起处理下吧
{code:java}
-- [1]28:select sum_sec(s1, `interval`=3) from root.udf.d1
STRICT{
Time(TIME) |
总数目：0
}
-- [1]31:select sum_sec(s1, 'interval'=`3`) from root.udf.d1
STRICT{
Time(TIME) |
总数目：0
}
{code}
> [udf]should return error and error message when the key of parameter attributes is not quoted
> ---------------------------------------------------------------------------------------------
>
> Key: IOTDB-4926
> URL: https://issues.apache.org/jira/browse/IOTDB-4926
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: changxue
> Assignee: liaolanyu
> Priority: Major
> Attachments: image-2022-11-14-15-40-37-461.png, normla-udf-0.14-SNAPSHOT.jar
>
>
> [udf]should return error and error message when the key of parameter attributes is not quoted
> reproduction:
> {code:java}
> create function sum_sec as "com.timecho.udf.normal.TestSlidingTimeWindowAccessStrategy";CREATE TIMESERIES root.udf.d1.s1 WITH DATATYPE=int64, ENCODING=PLAIN;
> CREATE TIMESERIES root.udf.d1.s2 WITH DATATYPE=int64, ENCODING=PLAIN;
> CREATE TIMESERIES root.udf.d1.s3 WITH DATATYPE=int32, ENCODING=PLAIN;
> CREATE TIMESERIES root.udf.d1.ss1 WITH DATATYPE=int64, ENCODING=PLAIN;select (s1, interval=3) from root.udf.d1;
>
> insert into root.udf.d1 (time, s1, s2) values (1, 1, 2),(2, 3, 4),(3, null, 6),(4, 7, 8),(5, 9, 10),(6, 11, null),(7, 13, 14),(8, 15, 16),(12, 17, 18),(20, 19, 20);-- 检验
> -- quote
> select sum_sec(s1, 'interval'=3) from root.udf.d1;
> -- no error, no logs, but it doesn't work.
> select sum_sec(s1, interval=3) from root.udf.d1; {code}
>
> !image-2022-11-14-15-40-37-461.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)