columnstore_decimal_overflow_check

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.

CHANGE HISTORY

EXTERNAL REFERENCES

• Information specific to MariaDB SkySQL can be found on the columnstore_decimal_overflow_check page in the SkySQL Documentation.