v.20.8Experimental Feature

Add Experimental Big Integer Types and Decimal256 with Known Issues

Official CH changelog text
Add types Int128, Int256, UInt256 and related functions for them. Extend Decimals with Decimal256 (precision up to 76 digits). New types are under the setting allow_experimental_bigint_types. It is working extremely slow and bad. The implementation is incomplete. Please don't use this feature. #13097 (Artem Zuikov).
Introduces new experimental integer types Int128, Int256, and UInt256, along with related functions, and extends decimal support with Decimal256 for up to 76 digits of precision.

Why it matters

This feature aims to provide support for very large integers and high-precision decimals, enabling users to work with numeric values exceeding the limits of existing types. However, the current implementation is incomplete and has significant performance drawbacks.

How to use it

To enable these new types, set the configuration option allow_experimental_bigint_types to 1 or true. Usage of these types and their functions should be done with caution as the implementation is still experimental and slow.

Related resources

PreviousNext