[ 
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)

Reply via email to