id_reuse.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.

# Test that cluster ids aren't reused.

mode cockroach

# Requires stable ids
reset-server

statement ok
CREATE SCHEMA foo

query TT rowsort
SELECT id, name FROM mz_schemas
----
s1 mz_catalog
s2 pg_catalog
u3 public
s4 mz_internal
s5 information_schema
u6 foo

statement ok
DROP schema foo

statement ok
DROP SCHEMA IF EXISTS foo, bar

statement ok
CREATE schema bar

query TT rowsort
SELECT id, name FROM mz_schemas
----
s1 mz_catalog
s2 pg_catalog
u3 public
s4 mz_internal
s5 information_schema
u7 bar

statement ok
CREATE DATABASE foo

query TT rowsort
SELECT id, name FROM mz_databases
----
u1 materialize
u2 foo

statement ok
DROP DATABASE foo

statement ok
CREATE DATABASE bar

query TT rowsort
SELECT id, name FROM mz_databases
----
u1 materialize
u3 bar

statement ok
CREATE ROLE foo

query TT rowsort
SELECT id, name FROM mz_roles
----
s1  mz_system
s2  mz_support
u1  materialize
u2  foo

statement ok
DROP ROLE foo

statement ok
DROP ROLE IF EXISTS foo, bar, foo

statement ok
CREATE ROLE bar

query TT rowsort
SELECT id, name FROM mz_roles
----
s1  mz_system
s2  mz_support
u1  materialize
u3  bar

statement ok
CREATE CLUSTER foo REPLICAS (r1 (size '1'))

query TT rowsort
SELECT id, name FROM mz_clusters
----
s1 mz_system
s2 mz_introspection
u1 default
u2 foo

statement ok
DROP CLUSTER foo CASCADE

statement ok
CREATE CLUSTER bar REPLICAS (r1 (size '1'))

query TT rowsort
SELECT id, name FROM mz_clusters
----
s1 mz_system
s2 mz_introspection
u1 default
u3 bar