Version 2025.2.1 Release Notes
Release date: 2026-03-20
This list provides an overview of all changes in version 2025.2.1.
Download version 2025.2.1 from the Exasol Download Portal.
This version includes fixes for a security vulnerability. We strongly recommend reading the change log below and updating as soon as possible if you are affected. If you have any questions or require assistance, contact support.
Changed behavior
| Changelog entry | Changed behavior |
|---|---|
| 28252 | Exasol no longer allows common table expressions (CTEs) that are not in parentheses to be used immediately after a table operator. For example, "SELECT ... UNION WITH CTE AS (SELECT ...) SELECT ..." is no longer allowed. |
| 28180 | The operator precedence of the table operator EXCEPT was incorrectly higher than INTERSECT. We changed the operator precedence to be the same as UNION. |
| 27358 | Changes the behavior of ORDER BY and LIMIT in combination with table operators to comply with the SQL Standard. |
| 8224 | Changes the behavior of ORDER BY and LIMIT in combination with table operators. |
New features
| Changelog entry | Summary |
|---|---|
| 28781 | Remote Server Support for Parquet Imports (HTTP/HTTPS, FTP/FTPS, SFTP) |
| 28742 | Optimization to push LIMIT and ORDER BY into UNION ALL |
| 28704 | Parquet files can now be imported from S3-compatible storage. |
| 27162 | REGEXP_COUNT feature introduction |
Improvements
| Changelog entry | Summary |
|---|---|
| 29578 | Optimized Memory Usage for ETL Parquet Imports with SOURCE COLUMN NAMES |
| 28531 | Access control improvement |
| 28252 | Exasol syntax no longer allows unbracketed CTE on right-hand side of a table operator |
| 27358 | Make table operator syntax SQL Standard compliant |
| 22384 | Multiple node restarts boot-up faster. |
| 8224 | Make table operator syntax SQL standard compliant |
| 2537 | Allow unqualified asterisk and other expressions in the select list |
Bug fixes
| Changelog entry | Summary |
|---|---|
| 29559 | Fix for Parquet Import Failure Due to Column Count Mismatch Across Files |
| 29180 | MUL set function gives wrong results for DECIMAL with non-zero scale |
| 29170 | UPDATE with prepared parameter does not update rows |
| 29169 | UPDATE with prepared parameters and subquery causes error |
| 29168 | Prepared parameter in LIMIT causes issues |
| 29054 | Exporting data to Azure Blob Storage may inadvertently overwrite an existing file with the same name |
| 28887 | SELECT INVALID with prepared parameters cause an error |
| 28636 | Error for prepared parameters in removable subqueries |
| 28576 | Fix Internal Error when importing UDF scripts in another UDF script. |
| 28323 | Do not perform unnecessary transcation rollbacks on client disconnects |
| 28244 | Fix wrong ordering with "SELECT INVALID UNIQUE / PRIMARY KEY / FOREIGN KEY" |
| 28243 | Unbracketed CTE on right-hand side of a table operator with ORDER BY or LIMIT can give wrong results |
| 28201 | Prepared parameters in a table operator on the top level crashes |
| 28180 | Fix precedence of EXCEPT |
| 28122 | Querying EXA_DB_SNAPSHOTS table on the worker cluster causes PddServer to crash which leads to DB restart |
| 28060 | Increasing disk redundancy chokes cored protocol |
| 27922 | Virtual Schemas: Wrong results for UNION ALL with ORDER BY, LIMIT |
| 27852 | Client connections may disconnect after a longer period of inactivity |
| 27828 | Wrong exception message when a client unexpectedly reconnects |
| 27528 | Wrong results from UNION ALL with LIMIT and the first operand has WHERE FALSE |
| 27499 | Crash or wrong results with table operator with LIMIT where first operand has a LIMIT clause |
| 27051 | A leak in shared memory can lead to failed snapshot backup operations and unsuccessful database restarts. |
| 27000 | Session may perform successful reconnect while still connected to another node |
| 26960 | Internal error on UNION with CTE and ORDER BY FALSE |
| 26084 | Node Startup Failure |
| 24037 | Failure to start nodes after scaling via the ConfD job "infra_db_scale" leaves an inconsistent state |
| 23957 | Use of DISTINCT with SET EMITS script causes Internal Server Error |
| 22923 | Exasol support archives are missing logs for the interval end date |
| 21791 | Invalid usage of tables in PRIOR and CONNECT BY causes Internal Server Error |
| 17738 | Correlated scalar subselect using literal projected from outer select throws unexpected exception |
| 17644 | Query with UNION, CTE and LIMIT fails due to "insertion limit" |
| 12888 | Internal Server Error for UNION ALL with LIMIT in WITH-clause |
| 8214 | Error on UNION with window function and ORDER BY |
