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() and to_iso8601() functions.
- Add support for position() syntax.
- Add Teradata compatibility functions: index(), char2hexint(), to_char(), to_date() and to_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.
