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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
