[
https://issues.apache.org/jira/browse/IOTDB-4239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhijia Cao reassigned IOTDB-4239:
---------------------------------
Assignee: (was: Zhijia Cao)
> 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.1
> Environment: Windows 10
> Reporter: Tao Yi
> Priority: Minor
>
> 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
> 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 statements and result in 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)
