Release Notes

Exasol 7.1 brings significant features, performance improvements, number of optimizations, and bug fixes. To view the packages and details about the release, see Downloads.

Main Features

Feature Description
New Scalar Functions

Two new functions are introduced in this release:

  • MIN_SCALE: This function returns the minimum scale needed to represent the value exactly.

  • TYPEOF: This function returns the SQL data type of its argument.

Transport Layer Security (TLS) encryption for drivers

Exasol JDBC, ODBC, and ADO.NET drivers now support TLS encryption. The feature also provides you an option to use fingerprints for the clients where certificate verification is not possible. To know more about the fingerprints, see Upload TLS Certificate.

If the certificate used by Exasol is not signed by a publicly recognized certificate authority (CA) or if the necessary CA certificate has not been provided to the client to use for verification, the connection will fail.
If another certificate has not been uploaded using EXAoperation, a self-signed certificate is used by Exasol per default. Since this certificate is self-signed, TLS connections to Exasol will fail by default. If this self-signed certificate should nevertheless be used, the certificate verification method must be changed.

JDBC 4.2 Support Exasol's JDBC driver now supports JDBC 4.2 Core APIs.
Lua 5.4 Exasol 7.1 database comes with Lua 5.4. To know more about Lua 5.4, see Lua 5.4 Readme File.
Lua adapter scripts for Virtual Schema Exasol now supports Lua adapter scripts for virtual schemas. This feature provides you better performance for regularly executed queries because it takes less time to start up. For more information, see CREATE SCRIPT, Database Interaction in Adapter Scripts, and Adapter Script Callback Function.
New Syntax in SQL Statements

New syntax VALUES BETWEEN is introduced in INSERT and SELECT SQL statements.

OpenID support

Exasol now support OpenID token for the database user authentication. Exasol supports OpenID Connect Core 1.0 specification.

You can create or edit database users authenticated by OpenID using CREATE USER and ALTER USER. For more detail, see Authentication using OpenID.

Snapshot Mode for SQL Statements Exasol now supports snapshot execution of the SQL statements for queries to the system tables. For more details, see Snapshot Mode.
Query timeout attribute for consumer group A new attribute QUERY_TIMEOUT is added to the consumer group. For more information, see CONSUMER GROUP and Consumer Group Attributes.
Idle timeout attribute for consumer group and system/ session parameters A new attribute IDLE_TIMEOUT is added to the consumer group and system/ session parameter. For more information, see ALTER SYSTEM, ALTER SESSION, CONSUMER GROUP and Consumer Group Attributes.
Improved reordering of local filter expressions Improved query performance by reordering cheaper local filter expressions first, if possible.
Improved performance of user, role and privileges system tables

Query performance has been improved for the following system tables:

  • EXA_*_USERS
  • EXA_*_ROLES
  • EXA_*_ROLE_PRIVS
  • EXA_*_OBJ_PRIVS

Speedup scales well with the size of these tables. The larger the number of concerned database objects, the more significant the speedup is.

Control the number of UDF instance per UDF call to avoid query out-of-memory situations

Exasol now provides you with an option to control the number of UDF instances per UDF Call per Node to avoid query out-of-memory situations. For more information, see UDF Instance Limit per Node and UDF Call.

This feature is available for Java, Python, and R programming languages.

Changed Behavior

Python 2 is deprecated and will not be supported from next Exasol release. Therefore, Exasol recommends you to use Python 3 in all UDF's.