Change in data type of object count columns in statistics schema
Details
| Detail name | Value |
|---|---|
| Changelog Number | 21564 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
| Fix Versions | Exasol 8.34.0, Exasol 8.29.11 |
| Resolution Date | 2025-04-16 |
Description
For large deployments, the number of database objects can exceed 1 million. This is more than datatype of some statistics system tables can store.
Workaround
There is no workaround.
Fix
EXA_STATISTICS.EXA_DB_SIZE_DAILY and EXA_STATISTICS.EXA_DB_SIZE_HOURLY tables have for columns OBJECT_COUNT_AVG and OBJECT_COUNT_MAX changed data type from DECIMAL(6,0) to DECIMAL(9,0).
EXA_STATISTICS.OBJECT_COUNT table has for column OBJECT_COUNT changed data type from DECIMAL(6,0) to DECIMAL(9,0).
EXA_STATISTICS.EXA_DB_SIZE_DAILY and EXA_STATISTICS.EXA_DB_SIZE_HOURLY tables have for columns OBJECT_COUNT_AVG and OBJECT_COUNT_MAX changed data type from DECIMAL(6,0) to DECIMAL(9,0).
EXA_STATISTICS.EXA_DB_SIZE_MONTHLY has for columns OBJECT_COUNT_AVG and OBJECT_COUNT_MAX changed data type from DECIMAL(6,0) to DECIMAL(9,0).
Changed behavior
EXA_STATISTICS.EXA_DB_SIZE_DAILY and EXA_STATISTICS.EXA_DB_SIZE_HOURLY tables have for columns OBJECT_COUNT_AVG and OBJECT_COUNT_MAX changed data type from DECIMAL(6,0) to DECIMAL(9,0). EXA_STATISTICS.OBJECT_COUNT table has for column OBJECT_COUNT changed data type from DECIMAL(6,0) to DECIMAL(9,0). EXA_STATISTICS.EXA_DB_SIZE_DAILY and EXA_STATISTICS.EXA_DB_SIZE_HOURLY tables have for columns OBJECT_COUNT_AVG and OBJECT_COUNT_MAX changed data type from DECIMAL(6,0) to DECIMAL(9,0). EXA_STATISTICS.EXA_DB_SIZE_MONTHLY has for columns OBJECT_COUNT_AVG and OBJECT_COUNT_MAX changed data type from DECIMAL(6,0) to DECIMAL(9,0).
