Home  /  Releases

Materialize v0.57

v0.57.0

SQL

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

    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).

Back to top ↑