RAW_OBJECT_SIZE may include rows marked as deleted
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15031 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0 |
| Fix Versions | Exasol 8.0.7, Exasol 7.0.20, Exasol 7.1.13 |
| Resolution Date | 2022-08-01 |
Description
The calculation of RAW_OBJECT_SIZE shown in EXA_ALL_OBJECT_SIZES may incorrectly include rows marked as deleted if a table contains the following:
- rows marked as deleted
- variable-sized columns like CHAR() or VARCHAR()
Workaround
Run the REORGANIZE TABLE <table-name> ENFORCE statement
Fix
RAW_OBJECT_SIZE is correct in those cases
