Materialize/test/sqllogictest/pg_catalog_namespace.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

statement ok
CREATE SCHEMA other;

statement ok
CREATE DATABASE other

query TT rowsort
SELECT nspname, nspacl FROM pg_catalog.pg_namespace
----
information_schema NULL
mz_catalog   NULL
mz_catalog_unstable  NULL
mz_unsafe   NULL
mz_internal  NULL
mz_introspection  NULL
other   NULL
pg_catalog   NULL
public   NULL

query I
SELECT COUNT(*) FROM pg_catalog.pg_namespace WHERE nspowner IS NOT NULL
----
9

statement ok
SET database = other;

query TT rowsort
SELECT nspname, nspacl FROM pg_catalog.pg_namespace
----
information_schema NULL
mz_catalog   NULL
mz_catalog_unstable  NULL
mz_unsafe NULL
mz_internal  NULL
mz_introspection  NULL
pg_catalog   NULL
public   NULL

query I
SELECT COUNT(*) FROM pg_catalog.pg_namespace WHERE nspowner IS NOT NULL
----
8