EXA_USAGE_* system tables may show incorrect number of queries
Details
| Detail name | Value |
|---|---|
| Changelog Number | 14649 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0 |
| Fix Versions | Exasol 7.1.11, Exasol 8.0.3 |
| Resolution Date | 2022-06-09 |
Description
In some cases EXA_USAGE_* system tables
(EXA_USAGE_LAST_DAY, EXA_USAGE_HOURLY, EXA_USAGE_DAILY, EXA_USAGE_MONTHLY)
may incorrectly show more queries (in column QUERIES) than actually run in the corresponding time frame.
Workaround
There is no workaround
Fix
Those system tables receive the correct number of queries.
Historical entries are untouched.