You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/11/29 15:56:09 UTC

[GitHub] [doris] xiaokang opened a new issue, #14681: [Bug] INSERT/CAST to JSONB will cause error

xiaokang opened a new issue, #14681:
URL: https://github.com/apache/doris/issues/14681

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   
   mysql> INSERT INTO  test_jsonb2 VALUES (1, NULL);
   ERROR 1105 (HY000): errCode = 2, detailMessage = can not cast from origin type NULL_TYPE to target type=JSONB
   
   mysql> SELECT CAST(NULL as JSONB);
   ERROR 1105 (HY000): errCode = 2, detailMessage = Invalid type cast of NULL from NULL_TYPE to JSONB
   
   
   ### What You Expected?
   
   INSERT/CAST NULL to JSONB should get NULL as other data types
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] morningman closed issue #14681: [Bug] INSERT/CAST to JSONB will cause error

Posted by GitBox <gi...@apache.org>.
morningman closed issue #14681: [Bug] INSERT/CAST to JSONB will cause error
URL: https://github.com/apache/doris/issues/14681


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org