You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Tao Yi (Jira)" <ji...@apache.org> on 2022/08/29 10:08:00 UTC
[jira] [Created] (IOTDB-4269) Error 500 occurs while where and having clause has nearly the same elements
Tao Yi created IOTDB-4269:
-----------------------------
Summary: Error 500 occurs while where and having clause has nearly the same elements
Key: IOTDB-4269
URL: https://issues.apache.org/jira/browse/IOTDB-4269
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: 0.14.0-SNAPSHOT
Environment: Windows 10
Reporter: Tao Yi
Attachments: image-2022-08-29-18-04-23-568.png, image-2022-08-29-18-05-16-278.png
I try to do the following insert and query in iotdb-0.14.0-SNAPSHOT client(new-server), and get an unexpected error 500 inconsistent data type for path:
create timeseries root.sg1.d1.code with datatype=TEXT, encoding=plain;
create timeseries root.sg1.d1.tem with datatype=INT32, encoding=plain;
insert into root.sg1.d1(timestamp, code, tem) values(1, '123', 345);
select avg(tem) from root.sg1.d1 where code='123' group by([0,5), 1ms) having min_value(tem)!=123;
select avg(tem) from root.sg1.d1 where code='123' group by([0,5), 1ms) having min_value(tem)!=124;
This is the result:
!image-2022-08-29-18-04-23-568.png|width=1080,height=489!
It seems that when the String constant's value in where clause is equal to the constant in the having clause, this error will happen. But if I use like clause in where(code like '123'), it will also not get this error.
So if this is a bug? Or I shouldn't use where clause together with having? Or I shouldn't use where xx = "" as a String value? (which haven't mention in the document)
Thanks.
The error in IoTDB server:
!image-2022-08-29-18-05-16-278.png|width=979,height=488!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)