11.27. Release 0.203

General Changes

Fix spurious duplicate key errors from map().
Fix planning failure when a correlated subquery containing a LIMITclause is used within EXISTS (#10696).
Fix out of memory error caused by missing pushback checks in data exchanges.
Fix execution failure for queries containing a cross join when using bucketed execution.
Fix execution failure for queries containing an aggregation functionwith DISTINCT and a highly selective aggregation filter.For example: sum(DISTINCT x) FILTER (WHERE y = 0)
Fix quoting in error message for SHOW PARTITIONS.
Eliminate redundant calls to check column access permissions.
Improve query creation reliability by delaying query start until the clientacknowledges the query ID by fetching the first response link. This eliminatestimeouts during the initial request for queries that take a long time to analyze.
Remove support for legacy ORDER BY semantics.
Distinguish between inner and left spatial joins in explain plans.

Fix sending authentication challenge when at least two of theKERBEROS, PASSWORD, or JWT authentication types are configured.
Allow using PEM encoded (PKCS #8) keystore and truststore with the HTTP serverand the HTTP client used for internal communication. This was already supportedfor the CLI and JDBC driver.

Declare a dependency on uuidgen. The uuidgen program is required duringinstallation of the Presto server RPM package and lack of it resulted in an invalidconfig file being generated during installation.

Fix complex type handling in the optimized Parquet reader. Previously, null values,optional fields, and Parquet backward compatibility rules were not handled correctly.
Fix an issue that could cause the optimized ORC writer to fail with a LazyBlock error.
Improve error message for max open writers.

Fix retry of requests when the remote Thrift server indicates that theerror is retryable.