EXA_CLUSTERS.LOAD_XMIN column could exceed data type range

Detail name	Value
Changelog Number	19794
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0
Fix Versions	Exasol 7.1.26
Resolution Date	2024-03-15

Description

The system table[ EXA_CLUSTERS |https://docs.exasol.com/db/latest/sql_references/system_tables/metadata/exa_clusters.htm]has three columns that report the load on the database: LOAD_1MIN, LOAD_5MIN, and LOAD_15MIN. These columns had a SQL type of DEC(4,2) which allows values up to 99.99; however, these values can be above 99.99. In this case, a data exception is thrown when accessing the table:

{{Error: [22003] data exception - numeric value out of range: value 111.7 (internal number representation) is not in [ -99.99 .. 99.99 ] }}

Workaround

There is no workaround.

Fix

The data type of the LOAD_1MIN, LOAD_5MIN, and LOAD_15MIN columns are increased to DEC(6,2).