Hi, Alexander! On Mar 17, Alexander Barkov wrote: > > > > why is it NOT_FIXED_DEC? it seems to me that it has to be 0 here. > > Perhaps my example in the comments made you think that > it happens in a very special case with CAST AS UNSIGNED. > It also happens in simpler cases: > > SELECT CASE WHEN TRUE > THEN COALESCE(NULL) > ELSE 40 > END; > > I guess I should fix the example to this ^^^.
Yes, please. More questions: 1. Perhaps my_decimal_length_to_precision() then? It's used not only in Item_func_case::agg_num_lengths. Quick grepping finds more potentially dangerous places. For example Item_decimal_typecast::print. 2. Why my_decimal_length_to_precision is only used in Item_func_case? How do other functions aggregate types? Perhaps CASE needs to be changed to work like other similar functions do? Regards, Sergei Chief Architect MariaDB and [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
