You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@iotdb.apache.org by "李伟豪 (Jira)" <ji...@apache.org> on 2023/02/28 03:37:00 UTC

[jira] [Assigned] (IOTDB-5592) Unexpected error when use not expression in having/where

     [ https://issues.apache.org/jira/browse/IOTDB-5592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

李伟豪 reassigned IOTDB-5592:
--------------------------

    Assignee: 李伟豪

> Unexpected error when use not expression in having/where 
> ---------------------------------------------------------
>
>                 Key: IOTDB-5592
>                 URL: https://issues.apache.org/jira/browse/IOTDB-5592
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Query
>            Reporter: 李伟豪
>            Assignee: 李伟豪
>            Priority: Major
>         Attachments: image-2023-02-28-11-35-48-768.png
>
>
> 复现SQL：
> INSERT INTO root.test.wf01.wt01(timestamp,ts0,ts1,ts2,ts3,ts4,ts5)VALUES(2,false,3,5,6.8,99.88,'IoTDB'),(10,true,3,5,6,99.88,'IoTDB');
> select * from root.test.wf01.wt01 where root.test.wf01.wt01.ts1 NOT in (1,2);
> !image-2023-02-28-11-35-48-768.png!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)