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.

Back to top ↑