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
andREVOKE 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.
- Allow specifying multiple database objects in the
-
Add
RESET schema
as an alias toRESET 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 themz_sources
system catalog table fromsubsource
toprogress
. 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 themz_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).