nlosilva1 opened a new issue, #7074:
URL: https://github.com/apache/iotdb/issues/7074

   **Describe the bug**
   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, it occurrs a 500 error `Exception occurred: 
executeNonQueryPlan failed. null`, but not 40X error (if we can't insert like 
this), and I can also insert null in other kind of timeseries.
   
   **To Reproduce**
   Running 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)`
   
   **Expected behavior**
   The first and the second insert will  be correctly executed.(Or return a 40X 
error if not support)
   But in fact, the first insert executes correctly but the second insert 
occurs a 500 ERROR and negated the whole insert.
   
   **Screenshots**
   Execute statements and result in IoTDB-client
   
![image](https://user-images.githubusercontent.com/25195216/185781001-c10f9fd6-ba93-45cb-88b5-f75afcdaa969.png)
   
   Error in IoTDB-server
   
![image](https://user-images.githubusercontent.com/25195216/185781053-6c0f1ab7-3124-4eaf-b289-f9d6eb8c54cb.png)
    
   
   **Desktop :**
    - OS: Windows 10
    - IoTDB Version: rel/0.13
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to