Force CURRENT_* functions to name columns
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15815 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.9.0 |
| Resolution Date | 2023-02-02 |
Background
The Exasol compiler uses internal structures to save additional information like aliases.
Improvement
The Exasol databases uses new internal compiler structures. This reduces the memory consumption of the compiler and speeds up the compilation process.
Changed behavior
Functions CURRENT_CLUSTER, CURRENT_SCHEMA, CURRENT_SESSION, CURRENT_STATEMENT and CURRENT_USER must name columns, if there are expressions in the not-outer query. For example: `with cte as ( select current_statement ) select * from cte;` throws exception "must name expression in query CTE with a column alias"