yuqi created IOTDB-920:
--------------------------
Summary: Disable insert values thats only contains time/timestamp
column
Key: IOTDB-920
URL: https://issues.apache.org/jira/browse/IOTDB-920
Project: Apache IoTDB
Issue Type: Improvement
Reporter: yuqi
Currently, It's OK to insert values as the following
{code:sql}
// Some comments here
INSERT INTO root.ln.wf01.wt01(timestamp,status) values(10000,true);
{code}
However, if we insert values only contains the time/timestamp columns, though
there is no error information, however, we can never query it
{code:sql}
// Some comments here
INSERT INTO root.ln.wf01.wt01(timestamp,status) values(10000,true);
IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp) values(20000);
Msg: The statement is executed successfully.
IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp) values(30000);
Msg: The statement is executed successfully.
IoTDB> select * from root.ln.wf01.wt01;
+-----------------------------+------------------------+-----------------------------+
|
Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|
+-----------------------------+------------------------+-----------------------------+
|1970-01-01T08:00:00.100+08:00| true|
null|
|1970-01-01T08:00:00.200+08:00| false|
20.71|
|1970-01-01T08:00:00.300+08:00| false|
0.0|
|1970-01-01T08:00:00.400+08:00| false|
0.0|
|1970-01-01T08:00:00.600+08:00| false|
0.07|
|1970-01-01T08:00:00.700+08:00| false|
0.0615|
|1970-01-01T08:00:00.800+08:00| false|
0.0611|
|1970-01-01T08:00:10.000+08:00| true|
null|
+-----------------------------+------------------------+-----------------------------+
Total line number = 8
It costs 3.909s
{code}
So, I suggest we should explicitly prohibit inserting values that only contains
time/timestamp values
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
