# Presto 316 Documentation

## 12.136. Release 0.108

## General Changes

- Fix incorrect query results when a window function follows a `row_number()` function and both are partitioned on the same column(s).
- Fix planning issue where queries that apply a `false` predicate to the result of a non-grouped aggregation produce incorrect results.
- Fix exception when `ORDER BY` clause contains duplicate columns.
- Fix issue where a query (read or write) that should fail can instead complete successfully with zero rows.
- Add `normalize()`, `from_iso8601_timestamp()`, `from_iso8601_date()` and `to_iso8601()` functions.
- Add support for `position()` syntax.
- Add Teradata compatibility functions: `index()`, `char2hexint()`, `to_char()`, `to_date()` and `to_timestamp()`.
- Make `ctrl-C` in CLI cancel the query (rather than a partial cancel).
- Allow calling `Connection.setReadOnly(false)` in the JDBC driver. The read-only status for the connection is currently ignored.
- Add missing `CAST` from `VARCHAR` to `TIMESTAMP WITH TIME ZONE`.
- Allow optional time zone in `CAST` from `VARCHAR` to `TIMESTAMP` and `TIMESTAMP WITH TIME ZONE`.
- Trim values when converting from `VARCHAR` to date/time types.
- Add support for fixed time zones `+00:00` and `-00:00`.
- Properly account for query memory when using the `row_number()` function.
- Skip execution of inner join when the join target is empty.
- Improve query detail UI page.
- Fix printing of table layouts in EXPLAIN.
- Add Black Hole Connector.

## Cassandra Changes

- Randomly select Cassandra node for split generation.
- Fix handling of `UUID` partition keys.