[
https://issues.apache.org/jira/browse/IOTDB-4944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuan Tian reassigned IOTDB-4944:
--------------------------------
Assignee: liaolanyu (was: Yuan Tian)
> [UDF]the results of calling UDF alone and calling with wildcard are
> inconsistent, when all is null
> --------------------------------------------------------------------------------------------------
>
> Key: IOTDB-4944
> URL: https://issues.apache.org/jira/browse/IOTDB-4944
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: changxue
> Assignee: liaolanyu
> Priority: Major
>
> [UDF]the results of calling UDF alone and calling with wildcard are
> inconsistent, when all is null
> reproduction:
> {code:java}
> CREATE FUNCTION COUNT_SEC as
> "com.timecho.udf.normal.TestStateWindowAccessStrategy";
> CREATE TIMESERIES root.udf.d1.s1 WITH DATATYPE=boolean, ENCODING=PLAIN;
> CREATE TIMESERIES root.udf.d1.s2 WITH DATATYPE=boolean, ENCODING=PLAIN;
> CREATE TIMESERIES root.udf.d1.ss1 WITH DATATYPE=boolean, ENCODING=PLAIN;
> INSERT INTO root.udf.d1 (time, s1, s2) VALUES (1, 1, 1),(2, 1, 0),(3, 0,
> 1),(4, 0, 1),(5, 0, 1),(8, 1, 1),(7, 1, 1),(6, null, 1),(12, 1, 1),(20, 1, 1);
> -- all null
> SELECT count_sec(ss1) FROM root.udf.d1;
> select count_sec(*) from root.udf.d1;{code}
> 下面两个结果不一致。
> 问题：
> 为什么同样是ss1列，都是null值，cout_sec(ss1)是空的，而 count_sec(*) 的ss1列第一个值是10?
>
> result of count_sec(ss1) :
> {code:java}
> +----+
> |Time|
> +----+
> +----+
> Empty set.
> {code}
> result of count_sec(\*):
> {code:java}
> Time(TIME) |count_sec(root.udf.d1.ss1)(TEXT)
> |count_sec(root.udf.d1.s1)(TEXT) |count_sec(root.udf.d1.s2)(TEXT) |
> --------------------------------------------------------------------------------------------------------------------------------
> 1 |10 |2
> |1 |
> --------------------------------------------------------------------------------------------------------------------------------
> 2 |null |null
> |1 |
> --------------------------------------------------------------------------------------------------------------------------------
> 3 |null |4
> |8 |
> --------------------------------------------------------------------------------------------------------------------------------
> 7 |null |4
> |null |
> 总数目：4{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
