Materialize v0.57

v0.57.0

SQL

• Improve and extend the base implementation of Role-based access control (RBAC):

  • Allow specifying multiple database objects in the GRANT PRIVILEGE and REVOKE PRIVILEGE commands.

  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.

• Add RESET schema as an alias to RESET search_path. From this release, the following sequence of commands provide the same functionality:

  materialize=> SET schema = finance;
  SET
  materialize=> SHOW schema;
   schema
  ---------
   finance
  (1 row)
  
  materialize=> RESET schema;
  RESET
  materialize=> SHOW schema;
   schema
  --------
   public
  (1 row)
  

   materialize=> SET search_path = finance, public;
   SET
   materialize=> SELECT current_schema;
    current_schema
   ----------------
    finance
   (1 row)
  
   materialize=> RESET schema;
   RESET
   materialize=> SELECT current_schema;
    current_schema
   ----------------
    public
   (1 row)
  

• Add support for new SQL functions:

  Function	Description
  array_position	Returns the subscript of the first occurrence of the second argument in the array. NULL if not found.
  parse_ident	Splits a qualified identifier into an array of identifiers, removing any quoting of individual identifiers.

Bug fixes and other improvements

• Breaking change. Change the type associated with progress subsources in the mz_sources system catalog table from subsource to progress. This change should have no user impact, but please let us know if you run into any issues.

• Breaking change. Add oid and re-order the columns of the mz_secrets system catalog table. This change should have no user impact, but please let us know if you run into any issues.

• Avoid panicking in the absence of the default materialize database (#19874).