[GitHub] [incubator-doris] rongyousu opened a new issue #4926: UNION ALL query return wrong type, NULL value but get ''

[GitBox]

rongyousu opened a new issue #4926:
URL: https://github.com/apache/incubator-doris/issues/4926


   the detail is that:
   sql:
   with a as 
   (
     select 2 as id, '1234' as user_id
      union all
       select 1 as id, NULL as user_id 
   ),
   b as 
   (  
     select 4 as id, '543' as user_id
     union all
      select 3 as id, NULL as user_id
   )
   select id,user_id from a
   union all
   select id ,user_id from b
   
   the result is :
   
![image](https://user-images.githubusercontent.com/7709573/99634610-bfac0d80-2a7b-11eb-915c-7cb9ef125068.png)
   
   
   my value is "NULL "  ,but  use with lable ,the result is issue, now is '' 


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

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



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