Tao Yi created IOTDB-4239:
-----------------------------
Summary: Error 500 occurs while insert a null value into a TEXT
timeseries in iotdb-client in rel/0.13
Key: IOTDB-4239
URL: https://issues.apache.org/jira/browse/IOTDB-4239
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: 0.13.0
Environment: Windows 10
Reporter: Tao Yi
It seems that we can add null in the insert into clause when insert data into
iotdb. (Null is also a valid constant) But when I try to insert null into a
TEXT timeseries in iotdb-client, it occurs a 500 error Exception occurred:
executeNonQueryPlan failed. null, but not 4XX error (if we can't insert like
this), at the same time I can also insert null in other kind of timeseries like
int32.
To reproduce:
I run the following statements in iotdb-client:
create timeseries root.sg0.t0 with datatype=INT32, encoding=plain
create timeseries root.sg0.t1 with datatype=INT32, encoding=plain
create timeseries root.sg0.t2 with datatype=TEXT, encoding=plain
insert into root.sg0(timestamp, t0, t1) values(1, null, 0)
insert into root.sg0(timestamp, t0, t1, t2) values(2, null, 0, null)
I expect the The first and the second insert will be correctly executed or
return a 4XX error if not support (in iotdb 0.14.0, I execute the same same
statements which returned an error 411). But in fact, the first insert executes
correctly but the second insert occurs a 500 ERROR and negated the whole insert.
This is the execute statements and resultin iotdb-client:
!https://user-images.githubusercontent.com/25195216/185781001-c10f9fd6-ba93-45cb-88b5-f75afcdaa969.png|width=746,height=300!
Error in IoTDB-server
!https://user-images.githubusercontent.com/25195216/185781053-6c0f1ab7-3124-4eaf-b289-f9d6eb8c54cb.png|width=972,height=471!
A copy of https://github.com/apache/iotdb/issues/7074
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
