You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2022/11/09 07:15:00 UTC

[jira] [Created] (IOTDB-4893) Unary Logical Operators logical operation and the msg was wrong

xiaozhihong created IOTDB-4893:
----------------------------------

             Summary: Unary Logical Operators logical operation and the msg was wrong
                 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: liaolanyu
         Attachments: image-2022-11-09-15-12-13-981.png

The expression contains an unsupported data type. When performing the logical operation of Unary Logical Operators, the msg is wrong. 
Unary Logical Operators only support BOOLEAN data type, but TEXT type is expected in Msg.
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.s1| null|      root.sg|   FLOAT|     RLE|     SNAPPY|null|      null|
|root.sg.d1.s2| null|      root.sg|  DOUBLE|     RLE|     SNAPPY|null|      null|
+-------------+-----+-------------+--------+--------+-----------+----+----------+
Total line number = 5
It costs 0.003s
IoTDB> select s1, s2, s4, !(s1 <=S2),!(s4 > s1) from root.sg.d1;
Msg: 416: Invalid input expression data type. expression: root.sg.d1.s1, actual data type: FLOAT, expected data type(s): [TEXT]. {code}

!image-2022-11-09-15-12-13-981.png|width=924,height=501!



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