Prepared parameters in a table operator on the top level crashes

Detail name	Value
Changelog Number	28201
Type	Bug
Status	Resolved
Affected Versions	Exasol 8.21.0
Fix Versions	Exasol 2025.1.6, Exasol 2026.1.0, Exasol 2025.2.1
Resolution Date	2025-12-05

Description

Query with a table operator on the top level with prepared parameters crashes with SIGSEGV signal (“Internal Server Error” for end user).

Example

PreparedStatement stmt = con.prepareStatement("select ? as X union all select 'User2';");
stmt.setString(1, "User1");    
ResultSet rs = stmt.executeQuery();

Workaround

Wrap a table operator with a simple select.

PreparedStatement stmt = con.prepareStatement("select * from (select ? as X union all select 'User2');");
stmt.setString(1, "User1");    
ResultSet rs = stmt.executeQuery();

Fix

The query runs as expected.