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

# Introspection sources are unstable.

statement error cannot create view with unstable dependencies
CREATE VIEW v AS SELECT count(*) FROM mz_introspection.mz_active_peeks

simple conn=mz_system,user=mz_system
ALTER SYSTEM SET enable_rbac_checks TO false
----
COMPLETE 0

# Following materialize#26434, this still goes through RBAC now
statement error must be owner of VIEW mz_introspection.mz_active_peeks
CREATE DEFAULT INDEX ON mz_introspection.mz_active_peeks

simple conn=mz_system,user=mz_system
CREATE DEFAULT INDEX ON mz_introspection.mz_active_peeks
----
db error: ERROR: cannot create index with unstable dependencies
DETAIL: The object depends on the following unstable objects:
    mz_active_peeks

simple conn=mz_system,user=mz_system
ALTER SYSTEM RESET enable_rbac_checks
----
COMPLETE 0

# Introspection views are unstable.

statement error cannot create view with unstable dependencies
CREATE VIEW v AS SELECT count(*) FROM mz_introspection.mz_scheduling_elapsed

# Unstable temporary views are allowed

statement ok
CREATE TEMPORARY VIEW v AS SELECT count(*) FROM mz_introspection.mz_scheduling_elapsed

# SELECTs from unstable objects are allowed.

statement ok
SET cluster_replica = r1

statement ok
SELECT * FROM mz_introspection.mz_active_peeks