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 treats NULL 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 and REVOKE 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.