columnstore_decimal_overflow_check
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: System Variables for MariaDB Enterprise Server
Topics on this page:
Overview
- In 10.6 ES, 10.6 CS:
Enable/disable for ColumnStore to check for overflow in arithmetic operation.
- In 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
See also: System Variables for MariaDB Enterprise Server 10.6, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
USAGE
Enterprise ColumnStore can be configured to check for decimal overflows by setting the columnstore_decimal_overflow_check system variable:
SET SESSION columnstore_decimal_overflow_check=ON;
SELECT (big_decimal1 * big_decimal2) AS product
FROM columnstore_tab;
DETAILS
When Enterprise ColumnStore performs mathematical operations with very big values using the DECIMAL, NUMERIC, and FIXED data types, the operation can sometimes overflow ColumnStore's maximum precision or scale. The maximum precision and scale depends on the version of Enterprise ColumnStore:
In Enterprise ColumnStore 6, the maximum precision (
M) is 38, and the maximum scale (D) is 18.In Enterprise ColumnStore 5, the maximum precision (
M) is 18, and the maximum scale (D) is 18.
When decimal overflow checks are enabled, math operations are slower.
When the decimal overflow check fails, MariaDB Enterprise ColumnStore raises an error with the ER_INTERNAL_ERROR error code, and it writes detailed information about the overflow check failure to the ColumnStore system logs.
PARAMETERS
Command-line | --columnstore_decimal_overflow_check |
Configuration file | Supported |
Dynamic | Yes |
Scope | Global, Session |
Data Type | BOOLEAN (OFF, ON) |
Default Value | OFF |
CHANGE HISTORY
Release Series | History |
|---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Information specific to MariaDB SkySQL can be found on the columnstore_decimal_overflow_check page in the SkySQL Documentation.