Materialize v0.58
v0.58.0
SQL
-
Add support for new SQL functions:
Function Description datediff
Returns the difference between two date, time or timestamp expressions based on the specified date or time part. pg_cancel_backend
Cancels an in-progress query on the specified connection ID. Returns whether the connection ID existed. -
Accept scalar functions in the
FROM
clause of a query. -
Add support for the PostgreSQL
IS DISTINCT FROM
operator. This operator behaves like<>
, except that it treatsNULL
like a normal value that compares equal to itself and not equal to all other values. -
Allow specifying a comma-separated list of schemas in the
DROP SCHEMA
. -
Add
mz_internal.mz_object_transitive_dependencies
to the system catalog. This table describes the transitive dependency structure between all database objects in the system. -
Improve and extend the base implementation of Role-based access control (RBAC):
-
Allow specifying multiple role names in the
GRANT ROLE
andREVOKE ROLE
commands. -
Add the
ALTER DEFAULT PRIVILEGES
command, which allows users to configure the default privileges for newly created objects. -
Add the
has_system_privilege
function to query role’s system privileges, which reports if a specified user has a system privilege.
It’s important to note that role-based access control (RBAC) is disabled by default. You must contact us to enable this feature in your Materialize region.
-