v.18.14Improvement
Added UUID Specializations in if Statement
Added specializations forUUIDinif. #3366
Why it matters
This feature addresses the limitation where theif function did not support UUID data types, allowing users to write conditional logic that directly manipulates UUID values without needing workarounds or type conversions.How to use it
Users can now write conditional expressions using theif function with UUID arguments as usual, for example:SELECT if(condition, uuid_value_if_true, uuid_value_if_false) FROM table;This requires no special configuration or settings.