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