[
https://issues.apache.org/jira/browse/IOTDB-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
李伟豪 reassigned IOTDB-4319:
--------------------------
Assignee: 李伟豪
> 400 Error "no data type found for path" in having clause when using upper
> case
> -------------------------------------------------------------------------------
>
> Key: IOTDB-4319
> URL: https://issues.apache.org/jira/browse/IOTDB-4319
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: 0.14.0-SNAPSHOT
> Environment: Windows 10
> Reporter: Tao Yi
> Assignee: 李伟豪
> Priority: Minor
> Attachments: err.txt, image-2022-09-03-12-42-36-314.png,
> image-2022-09-03-12-56-11-434.png
>
>
> I try some queries in IoTDB-0.14.0-SNAPSHOT client, but got unexpected error
> only when I use an upper case aggregate function in having.
> These are the queries I executed:
> create timeseries root.sg1.d1.t1 with datatype=FLOAT, encoding=plain;
> create timeseries root.sg1.d1.t2 with datatype=FLOAT, encoding=plain;
> insert into root.sg1.d1(timestamp, t1, t2) values(1, 0, 1);
> insert into root.sg1.d1(timestamp, t1, t2) values(2, -1, 2);
> insert into root.sg1.d1(timestamp, t1, t2) values(3, -2, 3);
> select last_value(t1) from root.sg1.d1 group by([1, 4), 2ms) having
> last_value(t2) > 0
> select last_value(t1) from root.sg1.d1 group by([1, 4), 2ms) having
> LAST_VALUE(t2) > 0
> select last_value(t2) from root.sg1.d1 group by([1, 4), 2ms) having
> LAST_VALUE(t2) > 0
> This is the result:
> !image-2022-09-03-12-42-36-314.png|width=848,height=339!
> From the result, the only difference between the first and the second query
> is changing the aggregate function in having clause from lower case to upper
> case. But when I change the column in select clause into the same as the
> having clause (without changing the upper case), we can still get the result.
> So I think it should be a bug.
> This is the error info in IoTDB-server. Full stacktrace is in the attachment.
> !image-2022-09-03-12-56-11-434.png|width=1028,height=599!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
