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.
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 |
| 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. |
| 28425 | Internal server error for UNION of VIEW containing ordered UNION |
| 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 |
