20.152. 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.