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)