[
https://issues.apache.org/jira/browse/IOTDB-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jialin Qiao reassigned IOTDB-2974:
----------------------------------
Assignee: Jialin Qiao (was: Haonan Hou)
> It is recommended to use double quotation marks or quotation marks to insert
> data in the TEXT type.
> ---------------------------------------------------------------------------------------------------
>
> Key: IOTDB-2974
> URL: https://issues.apache.org/jira/browse/IOTDB-2974
> Project: Apache IoTDB
> Issue Type: Improvement
> Components: Core/Server
> Reporter: xiaozhihong
> Assignee: Jialin Qiao
> Priority: Minor
>
> In th CLI ,the timeseries' datatype is TEXT, but inserted data can also be
> inserted successfully if the data is 1 or false.
> {code:java}
> IoTDB> set storage group to root.ln;
> Msg: The statement is executed successfully.
> IoTDB> create timeseries root.ln.wf01.wt01.temperature with
> datatype=FLOAT,encoding=RLE;
> Msg: The statement is executed successfully.
> IoTDB> create timeseries root.ln.wf01.wt01.hardware with
> datatype=Text,encoding=PLAIN;
> Msg: The statement is executed successfully.
> IoTDB> show timeseries root.ln.**;
> +-----------------------------+-----+-------------+--------+--------+-----------+----+----------+
> | timeseries|alias|storage
> group|dataType|encoding|compression|tags|attributes|
> +-----------------------------+-----+-------------+--------+--------+-----------+----+----------+
> |root.ln.wf01.wt01.temperature| null| root.ln| FLOAT| RLE|
> SNAPPY|null| null|
> | root.ln.wf01.wt01.hardware| null| root.ln| TEXT| PLAIN|
> SNAPPY|null| null|
> +-----------------------------+-----+-------------+--------+--------+-----------+----+----------+
> Total line number = 2
> It costs 0.010s
> IoTDB> insert into root.ln.wf01.wt01(timestamp, hardware) values(2,1)
> Msg: The statement is executed successfully.
> IoTDB> insert into root.ln.wf01.wt01(timestamp, hardware) values(3,false)
> Msg: The statement is executed successfully.
> IoTDB> insert into root.ln.wf01.wt01(timestamp, hardware) values(4,'a')
> Msg: The statement is executed successfully.
> IoTDB> select hardware from root.ln.wf01.wt01;
> +-----------------------------+--------------------------+
> | Time|root.ln.wf01.wt01.hardware|
> +-----------------------------+--------------------------+
> |1970-01-01T08:00:00.002+08:00| 1|
> |1970-01-01T08:00:00.003+08:00| false|
> |1970-01-01T08:00:00.004+08:00| a|
> +-----------------------------+--------------------------+
> Total line number = 3
> It costs 0.010s
> {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)