You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
# 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