Release 0.108#
General#
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()
andto_iso8601()
functions.Add support for
position()
syntax.Add Teradata compatibility functions:
index()
,char2hexint()
,to_char()
,to_date()
andto_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
fromVARCHAR
toTIMESTAMP WITH TIME ZONE
.Allow optional time zone in
CAST
fromVARCHAR
toTIMESTAMP
andTIMESTAMP 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#
Randomly select Cassandra node for split generation.
Fix handling of
UUID
partition keys.