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.