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)