22.89. 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 falsepredicate
to the result of a non-grouped aggregation produce incorrect results.
- Fix exception when ORDER BYclause 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()andto_iso8601()functions.
- Add support for position()syntax.
- Add Teradata compatibility functions: index(),char2hexint(),to_char(),to_date()andto_timestamp().
- Make ctrl-Cin 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 CASTfromVARCHARtoTIMESTAMP WITH TIME ZONE.
- Allow optional time zone in CASTfromVARCHARtoTIMESTAMPandTIMESTAMP WITH TIME ZONE.
- Trim values when converting from VARCHARto date/time types.
- Add support for fixed time zones +00:00and-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 UUIDpartition keys.