v.23.5Improvement
Added Support for Temporary Tables in ATTACH and REPLACE PARTITION Queries
Added possibility to use temporary tables in FROM part of ATTACH PARTITION FROM and REPLACE PARTITION FROM. #49436 (Roman Vasin).
Why it matters
This feature allows greater flexibility in managing partitions by enabling users to specify temporary tables as the source in partition attachment or replacement operations. It simplifies workflows where data is prepared or staged in temporary tables before being merged into main tables.How to use it
Users can specify a temporary table directly in theFROM part of ATTACH PARTITION FROM or REPLACE PARTITION FROM queries, allowing partition data to be sourced dynamically from those temporary tables during partition operations.