[
https://issues.apache.org/jira/browse/IOTDB-4269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17601702#comment-17601702
]
Minghui Liu commented on IOTDB-4269:
------------------------------------
PR: https://github.com/apache/iotdb/pull/7266
> 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
> Assignee: Minghui Liu
> Priority: Minor
> 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)
