v.23.7Improvement
Fix use_structure_from_insertion_table_in_table_functions for MATERIALIZED and ALIAS columns
Fixuse_structure_from_insertion_table_in_table_functionsdoes not work withMATERIALIZEDandALIAScolumns. Closes #51817. Closes #51019. #51825 (flynn).
Why it matters
This fix addresses the issue where theuse_structure_from_insertion_table_in_table_functions setting did not correctly interpret the structure of tables containing MATERIALIZED and ALIAS columns. It ensures that these special column types are now recognized and handled properly, improving table function behavior and data consistency when these columns are involved.How to use it
To enable the fix, simply use theuse_structure_from_insertion_table_in_table_functions setting as before. This update ensures that when enabled, the structure resolution now includes MATERIALIZED and ALIAS columns automatically without any additional configuration.