# 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

statement ok
CREATE DATABASE d1

statement ok
CREATE DATABASE d2

statement ok
CREATE TABLE d1.public.foo(a int)

statement ok
CREATE TABLE d2.public.bar(b int)

statement ok
CREATE VIEW v AS SELECT foo.a, bar.b FROM d1.public.foo, d2.public.bar

statement error renaming conflict: in materialize.public.v, which uses d1.public.foo, found reference to "bar"; cannot rename "foo" to any identity used in any existing view definitions
ALTER TABLE d1.public.foo RENAME TO bar