v.23.4Improvement
Improved Flexibility in Insert Table Structure Propagation for Table Functions
For use_structure_from_insertion_table_in_table_functions more flexible insert table structure propagation to table function. Fixed an issue with name mapping and using virtual columns. No more need for 'auto' setting. #47962 (Yakov Olkhovskiy).Why it matters
This feature addresses issues with name mapping and the use of virtual columns when inserting into table functions. It enhances the propagation of the inserted table's structure allowing for more reliable and predictable behavior without relying on the 'auto' setting.How to use it
Users can enable this feature by setting theuse_structure_from_insertion_table_in_table_functions option. This setting ensures the table structure from the insertion source is properly propagated to table functions, improving compatibility and correctness during data insertion.