Version 7.0.4 Release Notes

Please view the list below for an overview of all changes in version 7.0.4. Version 7.0.4 was released on 2020-11-26.

Changed Behavior

Changelog Entry Changed Behavior
11058 Exasol will send the CLOSE control frame after receiving the 'disconnect' command to initiate closing the WebSocket connection.
10950 If a custom TLS certificate was uploaded in ExaOperation, it will be used for WebSocket database connections instead of an autogenerated self-signed TLS-certificate. This does not affect ODBC, JDBC and ADO.NET, but only WebSocket API (e.g. via pyExasol). Also, if no custom certificate was uploaded, the default autogenerated TLS certificate for the database will be increased from 1024 to 2048 bits. See the issue description for more details.
10899 Filtering or joining a timestamp or date column with strings that contain invalid values now always throws an exception.
10802 LISTAGG and new FN_AGG_LISTAGG* capabilities were added to the virtual schema API. LISTAGG no longer uses the GROUP_CONCAT API.

Improvements

Changelog Entry Summary
11208 Updated built-in script language container
10804 Virtual Schemas: Added Pushdown of COUNT of Tuple
10569 Optimized DBRAM locking in case of heavy atomic commit pressure

Bug Fixes

Changelog Entry Summary
11139 DISTINCT with JSON_VALUE, IS JSON, or IS NOT JSON returns an error
11134 Queries containing virtual tables and FALSE predicates may lead to an internal server error
11075 Queries on EXA_DBA/USER_PROFILE_RUNNING containing sessions of dropped users may fail
11058 WebSockets: Missing CLOSE command after 'disconnect' command
11051 GROUP_CONCAT function misses default separator on HASHTYPE if used as an analytical function
11045 Internal server error for duplicate GROUP_CONCAT/LISTAGG analytic functions
11023 Drivers: Hashtype code in metadata may cause problems in front-end tools
11000 Storage interface not accessible after reboot of data nodes in the cloud
10992 Long restore time for uncompressed backups on remote volumes
10987 Wrong results with date arithmetic for dates in October 1582
10950 Use custom TLS certificates in WebSocket API and improve default TLS certificate length
10948 SECURITY: Denial of Service Attack via specially crafted network packets
10940 Exaoperation Monitoring page vulnerable to XSS attack
10899 Joins and filter conditions do not always raise an exception for implicit casts to invalid timestamps or dates
10894 Virtual Schemas: Pushdown of String Literals Containing Double Quotes returns incorrect results
10802 Virtual Schemas: LISTAGG and GROUP_CONCAT Pushdown incomplete
10681 Small exact numeric literals as input may cause wrong results when using AVG, STDDEV_*,VAR_*
10622 Joins with geometry predicates on varchar datatypes may cause unexpected result.
8225 Incorrect results when combining WHERE FALSE, aggregations, and UNION