[
https://issues.apache.org/jira/browse/IOTDB-4751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17623667#comment-17623667
]
xiaozhihong commented on IOTDB-4751:
------------------------------------
About LIMIT, SLIMIT, OFFSET, SOFFSET is not checked currently.
!image-2022-10-25-16-42-50-131.png!
> [cluster]Aggregation by Tags with having clause is not checked
> --------------------------------------------------------------
>
> Key: IOTDB-4751
> URL: https://issues.apache.org/jira/browse/IOTDB-4751
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Query
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: xiaozhihong
> Assignee: Eric Pai
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2022-10-25-15-46-51-708.png,
> image-2022-10-25-16-42-50-131.png
>
>
> commit cbc622573fe403b4e91bd576bf5b49156d1c91eb
> Start 3CD, then execute write and query SQL. The limitation of Aggregation by
> Tags, with the having clause is not currently supported, but no verification
> is currently added.
> {code:java}
> IoTDB> SELECT COUNT(temperature) FROM root.** GROUP BY ([1000, 10000), 5s),
> TAGS(city, workshop) having count(temperature) > 5;
> Msg: 400: null {code}
> !image-2022-10-25-15-46-51-708.png|width=592,height=130!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
