Rare memory corruption involving big IN lists and query cache leads to session crashes

Details

Detail name Value
Changelog Number 8500
Type Bug
Status Resolved
Affected Versions Exasol 6.1.0
Fix Versions Exasol 7.0.0, Exasol 6.1.7, Exasol 6.2.2
Resolution Date 2019-09-16

Problem

While accessing the internal query cache, queries may crash when they contain very large IN lists (>150,000 elements). The cause of this is a bug in internal memory garbage collection in context of the query cache.

Workaround

Disabling the query cache avoids this problem (see ALTER SESSION and ALTER SYSTEM)