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/10/11 11:12:54 UTC

[GitHub] [doris] Kikyou1997 opened a new issue, #13295: [Bug] Unexpected error when run SQL with CASE-WHEN expr

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

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   run `SELECT CASE WHEN col1=1 THEN NULL END FROM t2;`
   
   get
   
   `ERROR 1105 (HY000): IllegalStateException, msg: null`
   
   ### What You Expected?
   
   get result set normally
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] 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] nextdreamblue commented on issue #13295: [Bug] Unexpected error when run SQL with CASE-WHEN expr

Posted by GitBox <gi...@apache.org>.
nextdreamblue commented on issue #13295:
URL: https://github.com/apache/doris/issues/13295#issuecomment-1276134552

   try this:
   SELECT CASE WHEN col1=1 THEN 'NULL' END FROM t2;


-- 
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