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

simple conn=mz_system,user=mz_system
SET CLUSTER TO quickstart
----
COMPLETE 0

# Test creating indexes on system objects
simple conn=mz_system,user=mz_system
CREATE INDEX i ON mz_views()
----
COMPLETE 0

# Test that creating indexes on objects in the mz_internal schema fails
simple conn=mz_system,user=mz_system
CREATE INDEX illegal_sys_ind ON mz_internal.mz_comments (id)
----
db error: ERROR: cannot create index with unstable dependencies
DETAIL: The object depends on the following unstable objects:
    mz_comments