[
https://issues.apache.org/jira/browse/IOTDB-4893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17634627#comment-17634627
]
xiaozhihong commented on IOTDB-4893:
------------------------------------
commit 917c8cff42a2fc908280d1bb6727ab7b4bb50aca
!image-2022-11-16-11-30-40-753.png|width=713,height=457!
> IN query operation, the data type check is incorrect
> ----------------------------------------------------
>
> Key: IOTDB-4893
> URL: https://issues.apache.org/jira/browse/IOTDB-4893
> Project: Apache IoTDB
> Issue Type: Bug
> Components: mpp-cluster
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: xiaozhihong
> Assignee: 李伟豪
> Priority: Minor
> Labels: pull-request-available
> Attachments: image-2022-11-16-11-30-40-753.png
>
>
> When IN Operators perform operations, when the data type corresponding to the
> query column is FLOAT, the parentheses contain values of BOOLEAN and TEXT
> types. The verification prompt is incorrect and needs to be modify.
> Like this:
> {code:java}
> IoTDB> show timeseries root.sg.d1.*;
> +-------------+-----+-------------+--------+--------+-----------+----+----------+
> | timeseries|alias|storage
> group|dataType|encoding|compression|tags|attributes|
> +-------------+-----+-------------+--------+--------+-----------+----+----------+
> |root.sg.d1.s3| null| root.sg| BOOLEAN| RLE| SNAPPY|null|
> null|
> |root.sg.d1.s4| null| root.sg| TEXT| PLAIN| SNAPPY|null|
> null|
> |root.sg.d1.s5| null| root.sg| BOOLEAN| RLE| SNAPPY|null|
> null|
> |root.sg.d1.s6| null| root.sg| INT32| RLE| SNAPPY|null|
> null|
> |root.sg.d1.s7| null| root.sg| INT64| RLE| SNAPPY|null|
> null|
> |root.sg.d1.s1| null| root.sg| FLOAT| RLE| SNAPPY|null|
> null|
> |root.sg.d1.s2| null| root.sg| DOUBLE| RLE| SNAPPY|null|
> null|
> +-------------+-----+-------------+--------+--------+-----------+----+----------+
> Total line number = 7
> It costs 0.004s
> IoTDB> select s1 in (1,169,12.5,100.15,'V001') from root.sg.d1;
> Msg: 400: For input string: "V001"
> IoTDB> select s1 in (1,169,false,true,12.5,100.15,'V001') from root.sg.d1;
> Msg: 400: For input string: "false"
> IoTDB> select s1 in (1,169,12.5,100.15) from root.sg.d1;
> +-----------------------------+------------------------------------+
> | Time|root.sg.d1.s1 IN (1,169,12.5,100.15)|
> +-----------------------------+------------------------------------+
> |1970-01-01T08:00:00.001+08:00| false|
> |1970-01-01T08:00:00.002+08:00| false|
> +-----------------------------+------------------------------------+
> Total line number = 2
> It costs 0.007s{code}
> But the query column is BOOLEAN or TEXT type can be verified.
> {code:java}
> IoTDB> select s3 in (1,169,12.5,100.15,false,true) from root.sg.d1;
> +-----------------------------+-----------------------------------------------+
> | Time|root.sg.d1.s3 IN
> (1,169,12.5,100.15,false,true)|
> +-----------------------------+-----------------------------------------------+
> |1970-01-01T08:00:00.001+08:00|
> true|
> |1970-01-01T08:00:00.002+08:00|
> true|
> +-----------------------------+-----------------------------------------------+
> Total line number = 2
> It costs 0.005s
> IoTDB> select s4 in (1,169,12.5,100.15,false,true,'V001') from root.sg.d1;
> +-----------------------------+----------------------------------------------------+
> | Time|root.sg.d1.s4 IN
> (1,169,12.5,100.15,false,true,V001)|
> +-----------------------------+----------------------------------------------------+
> |1970-01-01T08:00:00.001+08:00|
> false|
> |1970-01-01T08:00:00.002+08:00|
> false|
> +-----------------------------+----------------------------------------------------+
> Total line number = 2
> It costs 0.005s {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
