Filter on System Tables in Snapshot Mode may cause Data Exception

Detail name	Value
Changelog Number	24799
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0, Exasol 8.0.0
Fix Versions	Exasol 2025.1.0, Exasol 8.29.11
Resolution Date	2025-07-08

Description

Under rare conditions it is possible that a valid query returns error “data exception - variable access out of bound”.
Necessary conditions:

• The query runs in in SNAPSHOT_MODE = 'SYSTEM TABLES' or uses /snapshot execution/.
• The query or a sub query contains system tables.
• The query or a sub query contains a filter on system tables.

Even when the conditions apply, this error only occurs very rarely.

Workaround

Rerun the query. There is no other workaround.

Fix

The query no longer causes an error.