[GitHub] [incubator-doris] EmmyMiao87 opened a new pull request #2003: Change the priority of different type in function

[GitBox <gi...@apache.org>]

EmmyMiao87 opened a new pull request #2003: Change the priority of different type in function
URL: https://github.com/apache/incubator-doris/pull/2003
 
 
   This commit fix the issue [ISSUE-2002].
   It changes the priority of coalesce, ifnull, nullif function etc.
   The priority of decimal is higher then varchar in the IS_SUPERTYPE_OF compare mode.
   
   Example:
   select coalesce(decimal_column, 1) from table;
       the return type of coalesce should be decimal instead of varchar.
   
   Add supertype about datetime and date
   The supertype of datetime is bigint, largeint etc.
   In IS_SUPERTYPE_OF compare mode, the function(bigint, bigint, bigint) is a supertype of function(datetime, bigint, int).
   
   Example:
   select coalesce(now(), 1)) from web_returns;
       the return type of coalesce should be bigint instead of varchar.
   
   #2002 ISSUE-2002

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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