The two above functions pose buggy / inconsistent behavior when called using the dot notation. Instead of returning the expected value they return several different errors depending on how they are ...
-- ifnull(shipper_id , 'not assigned') as shipper -- it will put the not assigned wherever the shipper id is null in orders table coalesce(shipper_id , comments ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results