Expand the approx_distinct() function to support the following types:
INTEGER, SMALLINT, TINYINT, DECIMAL, REAL, DATE,
TIMESTAMP, TIMESTAMPWITHTIMEZONE, TIME, TIMEWITHTIMEZONE, IPADDRESS.
Add a resource group ID column to the system.runtime.queries table.
Add support for executing ORDERBY without LIMIT in a distributed manner.
This can be disabled with the distributed-sort configuration property
or the distributed_sort session property.
Add implicit coercion from VARCHAR(n) to CHAR(n), and remove implicit coercion the other way around.
As a result, comparing a CHAR with a VARCHAR will now follow
trailing space insensitive CHAR comparison semantics.
Improve query cost estimation by only including non-null rows when computing average row size.
Improve query cost estimation to better account for overhead when estimating data size.
Add new semantics that conform to the SQL standard for temporal types.
It affects the TIMESTAMP (aka TIMESTAMPWITHOUTTIMEZONE) type,
TIME (aka TIMEWITHOUTTIMEZONE) type, and TIMEWITHTIMEZONE type.
The legacy behavior remains default.
At this time, it is not recommended to enable the new semantics.
For any connector that supports temporal types, code changes are required before the connector
can work correctly with the new semantics. No connectors have been updated yet.
In addition, the new semantics are not yet stable as more breaking changes are planned,
particularly around the TIMEWITHTIMEZONE type.