Materialize/test/sqllogictest/pg_catalog_user.slt

# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.

mode cockroach

# Start from a pristine server
reset-server

statement ok
CREATE ROLE nonlogin_because_not_formatted_like_an_email

statement ok
CREATE ROLE "materialize@foocorp.io"

query TIBBBBTTT rowsort
SELECT usename, usesysid, usecreatedb, usesuper, userepl, usebypassrls, passwd, valuntil, useconfig FROM pg_user;
----
materialize@foocorp.io  20190  false  NULL  false  false  ********  NULL  NULL
mz_support  16662  false  NULL  false  false  ********  NULL  NULL
mz_system  16661  true  true  false  false  ********  NULL  NULL

statement ok
ALTER USER "materialize@foocorp.io" SET search_path = 'abc,def';

statement ok
ALTER USER "materialize@foocorp.io" SET cluster = "cluster=cluster=cluster=";

query TT rowsort
SELECT usename, useconfig::text FROM pg_user;
----
materialize@foocorp.io  {cluster=cluster=cluster=cluster=,"search_path=abc,␠def"}
mz_support  NULL
mz_system  NULL