columnstore_decimal_overflow_check

Overview

In 10.6 ES, 10.6 CS:

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

In 10.6 ES:

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

In 10.5 ES, 10.4 ES:

Not present

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

Multi-Node Analytics

10.6

OFF

Single Node Analytics

10.6

OFF

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

Not present

10.5

Not present

10.6

Not present

Single Node Transactions

10.4

Not present

10.5

Not present

10.6

Not present

GCP

Multi-Node Analytics

10.6

OFF

Single Node Analytics

10.6

OFF

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

Not present

10.5

Not present

10.6

Not present

Single Node Transactions

10.4

Not present

10.5

Not present

10.6

Not present

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Added in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Added in MariaDB Community Server 10.6.5.

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.

Release Series

History

10.6 Enterprise

  • Added in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Not present.

10.4 Enterprise

  • Not present.