COALESCE and DAYOFYEAR nesting in outer join leads to wrong output in Columnstore

See the attached SQL EBI-499_bug_exposal_dummy.sql: the lines with "!!!" expose the bug when tested against dummy data tables on both EBI01 and EBI04 (MariaDB 10.3 and 10.5).
The problem are the MAX_INT values that must not occur when using COALESCE in the green boxes (and do not occur using InnoDB engine).

TODOs:

• check whether only Columnstore or also InnoDB is affected ==> DONE: only Columnstore
• simplify the bug exposal by using dummy data ==> DONE, see attached
• check if outer join or also inner join is affected ==> reduced to outer join (example makes no sense for inner join)
• check which MariaDB Version is affected ==> DONE, also 10.5 (on EBI04) is affected, same behaviour as for 10.3 (EBI01).