You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Jinrui Zhang (Jira)" <ji...@apache.org> on 2022/07/21 11:09:02 UTC
[jira] [Created] (IOTDB-3922) ColumnName is not correct in some scenarios for GroupByLevel
Jinrui Zhang created IOTDB-3922:
-----------------------------------
Summary: ColumnName is not correct in some scenarios for GroupByLevel
Key: IOTDB-3922
URL: https://issues.apache.org/jira/browse/IOTDB-3922
Project: Apache IoTDB
Issue Type: Bug
Reporter: Jinrui Zhang
Assignee: Minghui Liu
Attachments: image-2022-07-21-19-08-24-583.png
Start a local 1c1d IoTDB using IDEA.
Executing the following statement to prepare data:
{color:#FF0000}_INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-27T23:50:00.000+08:00, true, 5, 23, 15.88, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12346");_{color}
{color:#FF0000}_INSERT INTO root.sgcc.wf01.wt01(timestamp, ts1) VALUES (now(), 1);_{color}
{color:#FF0000}_INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (now(), true, 5, 23, 15.88, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12345")_{color}
{color:#172b4d}And then, execute the query below:{color}
{color:#de350b}_SELECT COUNT(ts1) FROM root.sgcc.wf01.wt01 GROUP BY LEVEL = 1_{color}
_{color:#172b4d}The result is not correct:{color}_
_{color:#172b4d}!image-2022-07-21-19-08-24-583.png|width=456,height=148!{color}_
--
This message was sent by Atlassian Jira
(v8.20.10#820010)