Improved active session management for open prepared statements

Detail name	Value
Changelog Number	12190
Type	Improvement
Status	Resolved
Fix Versions	Exasol 7.1.0
Resolution Date	2021-08-03

Background

Prepared statements exist in two different states

• prepare statement
• execute prepared statement

Improvement

Exasols Session Management has been improved as sessions are not counted as active sessions in the following circumstances:

• the session only contains prepared statements
• the prepared statements are only in the prepare statement state (not in execute prepared statement)

As a result, these sessions are not consuming an active session slot, preventing sessions to be queued.

Changed behavior

Sessions with open prepared statements only are not counted as active sessions any more.