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.

413-e initial changes#

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

General#

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.

Security#

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.

Data products#

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

IBM Db2 connector#

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

MongoDB connector#

Added support for Kerberos authentication using a keytab.

MySQL connector#

Added support for Managed statistics as a public preview.

Redshift connector#

Added support for Managed statistics as a public preview.

SingleStore connector#

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

Snowflake connector#

Added support for Managed statistics as a public preview.

SQL Server connector#

Added support for Managed statistics as a public preview.

Starburst Stargate#

Added support for OAuth 2.0 token pass-through.

413-e.1 changes (30 May 2023)#

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.

413-e.2 changes (12 Jun 2023)#

Multiple backend improvements.

413-e.3 changes (14 Jul 2023)#

Fixed Iceberg statistics loading after snapshot expiration.

413-e.4 changes (26 Jul 2023)#

Fixed Starburst Warp Speed loading issue in GKE and AKS deployments.

413-e.5 changes (9 Aug 2023)#

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.

413-e.6 changes (29 Aug 2023)#

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.

413-e.7 changes (19 Sep 2023)#

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.

413-e.9 changes (2 Oct 2023)#

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.

413-e.10 changes (18 Oct 2023)#

Fixed performance issue when reading with the native CSV reader on Hive.
Improved performance for filtering catalogs, schemas, tables, and columns in BIAC.
Fixed MongoDB mixed case schemas with custom roles.
Remediated the following CVEs:
- CVE-2018-20839
- CVE-2023-36478
- CVE-2023-36479

413-e.11 changes (13 Nov 2023)#

Fixed incorrect column statistics for Parquet file format in manifest files.
Cast char fields, if necessary, to varchar type in Hive view translations.
Fixed incorrect results for queries involving ORDER BY and window functions with ordered frames.
Masked additional sensitive values in log files.
Fixed incorrect results in MongoDB when a query contains several != or NOT IN predicates.
Improved support for concurrent updates of table statistics in Glue.
Support RENAME SCHEMA and RENAME TABLE when snowflake.database-prefix-for-schema.enabled=true.
Remediated CVE-2023-39410.
Fixed incorrect results for queries involving an aggregation in a correlated subquery.

413-e.12 changes (27 Nov 2023)#

Fixed possible JVM crash when reading short decimal columns in parquet files created by Impala (Hive, Hudi, Delta, Iceberg).
Remediated CVE-2023-41900.
Granting execution rights on a non-qualified function no longer makes all catalogs visible.