v.25.1Backward Incompatible Changes
Merge Tables Enhancements and Compatibility Considerations
Mergetables will unify the structure of underlying tables by using a union of their columns and deriving common types. This closes #64864. In certain cases, this change could be backward incompatible. One example is when there is no common type between tables, but conversion to the type of the first table is still possible, such as in the case of UInt64 and Int64 or any numeric type and String. If you want to return to the old behavior, setmerge_table_max_tables_to_look_for_schema_inferenceto1or setcompatibilityto24.12or earlier. #73956 (Alexey Milovidov).