Release 413-e LTS (30 May 2023)#

The 413-e release includes all improvements from the following Trino project releases:

Highlights since 407-e#

Added support for PingIdentity as an OAuth 2.0 identity provider.
Added Managed statistics to the Redshift, Snowflake, MySQL, and SQL Server connectors as a public preview.
Added support for Fault-tolerant execution of write operations in SingleStore and IBM Db2.
Added query sharing to the Starburst Enterprise web UI query editor as a public preview.

The following changes from the 413-e STS are all part of the first public release.

Added support for usage metrics to be uploaded through a proxy server.
Updated the Saved queries tab to hide the Share button when built-in access control is not enabled.
Added support for arranging worksheet tabs in the query editor.
Changed managed statistics to use the in-memory statistics cache by default.
Added support for sharing query tabs as a public preview.
Added a new timeout configuration property that automatically logs users out of the Starburst Enterprise web UI after a specified period of inactivity.
Improved performance of queries run in the Query editor.
Updated the query editor to retain worksheet tabs when the node.environment configuration property is changed.

Fixed issue that allowed Built-in access control privileges grants to have more than one entity category.
Added PingIdentity as a supported OAuth 2.0 identity provider.
Added support for client token authentication page to be enabled when OAuth 2.0 token pass-through is in use.
Changed Built-in access control masks and filters expressions to be evaluated based on the security context of the current session.
Fixed an issue that caused some row filter and column mask expressions to result in an access denied error.

Updated the data preview window to automatically resize based on the number of columns in the dataset.

Added support for fault-tolerant execution of read operations with a TASK retry policy.

Added support for Fault-tolerant execution of write operations with the TASK retry policy.

Fixed Starburst Enterprise web UI Overview page error when internal TLS is enabled.
Fixed a potential internal communication secret leak. See the security advisory for more information.
Remediated CVE-2023-1370.
Fixed read permissions for columns required by table functions. See the full security advisory for more information.

Fixed issue where querying Redshift catalogs returned incorrect results when encountering unsupported types.
Fixed Iceberg query failure when reading ORC files with nullable time columns.
Fixed reading concatenated GZIP streams.
Fixed TEXTFILE and RCTEXT handling of an escaped escape character.
Fixed missing data when reading large text and sequence files with a single header row.

Fixed parallel read of tables with non-clustered index in SQL Server.
Fixed write conflict detection for UPDATE/DELETE/MERGE operations. In rare situations, this issue may have resulted in duplicate rows when multiple of these operations were run at the same time, or at the same time as an optimize procedure.
Fixed caching in LDAP group provider.
Improved performance in BIAC for queries with large numbers of columns.

Fixed issue with Query Editor not running queries to completion which may have prevented results from being visible.
Fixed Kudu merge error between two CTAS tables.

413-e.8 was skipped.

Fixed license issue in DynamoDB connector.
Fixed run and download when browser policies disallow downloading larger result sets.
Fixed potential for incorrect results when a table has deletion vectors in the Delta Lake connector.
Fixed issue where the catalog name was included twice when creating an access policy for a catalog session property (BIAC).
Added access control check to redirected tables when getting comments.
Fixed JavaScript policy evaluation in Privacera.
Fixed performance when planning queries involving multiple window functions.