# 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

# Start from a pristine server
reset-server

statement ok
CREATE SOURCE s1 FROM LOAD GENERATOR COUNTER;

statement ok
CREATE SOURCE s2 FROM LOAD GENERATOR COUNTER;

query TTTTTT rowsort
SELECT id, schema_id, name, type, connection_id, size FROM mz_sources WHERE id LIKE 'u%'
----
u2  u3  s1  load-generator  NULL  NULL
u4  u3  s2  load-generator  NULL  NULL
u1  u3  s1_progress  progress  NULL  NULL
u3  u3  s2_progress  progress  NULL  NULL

# clusters.
query TTTT
SHOW SOURCES
----
s1  load-generator  quickstart (empty)
s1_progress  progress  NULL (empty)
s2  load-generator  quickstart (empty)
s2_progress  progress  NULL (empty)