v.25.11New Feature
flipCoordinates Function
Add flipCoordinates function that unwraps the required number of dimensions in an array and swaps pointers inside the Tuple column. Resolves #79469. #79634 (Sachin Kumar Singh).Why it matters
This feature addresses the need to manipulate multi-dimensional arrays and Tuple columns by enabling dimension unwrapping and pointer swapping, which simplifies working with complex nested data structures and improves data handling efficiency.How to use it
Use theflipCoordinates function by specifying the number of dimensions to unwrap in an array. It operates on Tuple columns to swap internal pointers accordingly. For example:SELECT flipCoordinates(array_column, number_of_dimensions) FROM table;