columnstore_decimal_overflow_check

In 10.6 ES:

Enable/disable for ColumnStore to check for overflow in arithmetic operation.

In 10.6 CS, 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

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

Not present

AWS

HA (Primary/Replica)

10.5

Not present

AWS

Transactional Standalone

10.4

Not present

AWS

Transactional Standalone

10.5

Not present

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

Not present

GCP

ColumnStore Multi

10.5

Not present

GCP

Galera

10.4

Not present

GCP

Galera

10.5

Not present

GCP

HA (Primary/Replica)

10.4

Not present

GCP

HA (Primary/Replica)

10.5

Not present

GCP

HTAP

10.5

Not present

GCP

Transactional Standalone

10.4

Not present

GCP

Transactional Standalone

10.5

Not present

GCP

Distributed Transactions

10.5

Not present

See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Added in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Not present.

10.5 Enterprise

  • Not present.

10.5 Community

  • Not present.

10.4 Enterprise

  • Not present.

10.4 Community

  • Not present.

10.3 Enterprise

  • Not present.

10.3 Community

  • Not present.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

EXTERNAL REFERENCES