EXA_DBA_AUDIT_SQL: Statement ID may be incorrect after reconnecting to a session
Details
| Detail name | Value |
|---|---|
| Changelog Number | 30884 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 2025.1.0, Exasol 2026.1.0 |
| Fix Versions | Exasol 2026.1.2 |
| Resolution Date | 2026-09-14 |
Description
If a client disconnects and reconnects to an IDLE session, the statement counter (stmt_id) may be incremented spuriously. This results in the first statement after the reconnect having a stmt_id that is 1 higher than expected.
Workaround
There is no workaround.
Fix
When an IDLE session experiences a connection loss followed by a reconnect, the stmt_id does not incorrectly skip ahead after the reconnect.