Transactions may exceed schema quotas without error
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11762 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.2.12 |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Background
Schema quota defines the maximum amount of data that can be stored within a certain schema.
It is allowed to exceed this limit temporarily during a transaction, but at commit time, the quota has to be respected.
Description
Under rare circumstances, it is possible for a commit to execute successfully even if a schema quota is exceeded (the expected behavior is an exception).
Subsequent commit statements will successfully validate the schema quota and raise exceptions even if no additional data is added in this transaction.
Workaround
Delete enough data to get below the schema quota again or increase the schema quota.
Fix
Transactions that exceed the schema quota raise an error on commit.
