# Presto 316 Documentation

## 12.78. Release 0.156

Warning

Query may incorrectly produce `NULL` when no row qualifies for the aggregation if the `optimize_mixed_distinct_aggregations` session property or the `optimizer.optimize-mixed-distinct-aggregations` config option is enabled.

## General Changes

- Fix potential correctness issue in queries that contain correlated scalar aggregation subqueries.
- Fix query failure when using `AT TIME ZONE` in `VALUES` list.
- Add support for quantified comparison predicates: `ALL`, `ANY`, and `SOME`.
- Add support for ARRAY and ROW that contain `NULL` in `checksum()` aggregation.
- Add support for filtered aggregations. Example: `SELECT sum(a) FILTER (WHERE b > 0) FROM ...`
- Add a variant of `from_unixtime()` function that takes a timezone argument.
- Improve performance of `GROUP BY` queries that compute a mix of distinct and non-distinct aggregations. This optimization can be turned on by setting the `optimizer.optimize-mixed-distinct-aggregations` configuration option or via the `optimize_mixed_distinct_aggregations` session property.
- Change default task concurrency to 16.

## Hive Changes

- Add support for legacy RCFile header version in new RCFile reader.

## Redis Changes

- Support `iso8601` data format for the `hash` row decoder.

## SPI Changes

- Make `ConnectorPageSink#finish()` asynchronous.

Note

These are backwards incompatible changes with the previous SPI. If you have written a plugin, you will need to update your code before deploying this release.