[ https://issues.apache.org/jira/browse/IOTDB-4269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
李伟豪 reassigned IOTDB-4269: -------------------------- Assignee: Minghui Liu > 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)