v.20.5Improvement

When reading Decimal values, truncate extra digits for MySQL and PostgreSQL compatibility

Official CH changelog text
When reading Decimal value, cut extra digits after point. This behaviour is more compatible with MySQL and PostgreSQL. This fixes #10202. #11831 (alexey-milovidov).
When reading Decimal values, extra digits after the decimal point are truncated, improving compatibility with MySQL and PostgreSQL.

Why it matters

This feature addresses the inconsistency in reading Decimal types by cutting off surplus digits after the decimal point. It ensures that ClickHouse behaves similarly to popular databases like MySQL and PostgreSQL, preventing precision-related issues and making data interchange more reliable.

How to use it

This behavior is applied automatically when reading Decimal values; no additional user configuration is required.

Related resources

PreviousNext