Optimization issue when prepared parameters are use within subselect of an INSERT ... SELECT statement
Details
| Detail name | Value |
|---|---|
| Changelog Number | 28353 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.29.0, Exasol 8.21.0, Exasol 2025.1.0, Exasol 2025.2.0 |
| Fix Versions | Exasol 2025.1.7 |
| Resolution Date | 2025-12-02 |
Description
When prepared parameters are used in an INSERT … SELECT statement and appear within a subselect, the optimization does not work correctly and the execution results in Internal server error
Example:
insert into T(X) select A from (select ? as A);
Workaround
The only workaround is to modify the query so that the optimization is not applied.
Example:
insert into T(X) select A from (select ? as A ORDER BY FALSE);
Fix
A DB parameter is added to disable a particular optimization as it is still enabled by default. Please contact Exasol Support if you face the problem in the above described scenario, to guide you through adding it.
Later this use case will be fixed so disabling the particular optimization will be unnecessary.
