v.23.7Improvement
Allow UUID to UInt128 Conversion
Allow UUID to UInt128 conversion. #51765 (Dmitry Kardymon).
Why it matters
This feature allows users to convertUUID values into the UInt128 type, facilitating easier manipulation and processing of UUIDs as numeric values, improving compatibility and performance in queries where numeric representation is preferred.How to use it
Users can apply this feature by using type conversion functions or casting expressions to convertUUID columns or values to UInt128. For example: SELECT CAST(uuid_column AS UInt128) FROM example_table