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

# Regression test for database-issues#8257.

statement ok
CREATE CLUSTER test REPLICAS(
    r1 (SIZE '1'),
    r2 (SIZE '1')
)

statement ok
DROP CLUSTER REPLICA test.r1;

statement ok
CREATE SOURCE counter IN CLUSTER test FROM LOAD GENERATOR COUNTER

query I
SELECT min(counter) FROM counter
----
1

statement ok
DROP CLUSTER test CASCADE

statement ok
CREATE CLUSTER test REPLICAS(
    r1 (SIZE '1'),
    r2 (SIZE '1')
)

statement ok
DROP CLUSTER REPLICA test.r2;

statement ok
CREATE SOURCE counter IN CLUSTER test FROM LOAD GENERATOR COUNTER

query I
SELECT min(counter) FROM counter
----
1