| 12345678910111213141516171819202122232425262728293031 |
- # 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 other
- statement ok
- CREATE VIEW other.public.v AS SELECT 1 AS num, 'a' AS char
- statement ok
- CREATE VIEW v AS SELECT 1 AS num, 'a' AS char
- statement ok
- CREATE TABLE t (c1 int DEFAULT 1234, c2 int DEFAULT 1 + 2)
- query TTTTTTTTTTT colnames,rowsort
- SELECT * FROM information_schema.columns WHERE table_name = 'v' OR table_name = 't'
- ----
- table_catalog table_schema table_name column_name ordinal_position column_default is_nullable data_type character_maximum_length numeric_precision numeric_scale
- materialize public t c1 1 1234 YES integer NULL NULL NULL
- materialize public t c2 2 1␠+␠2 YES integer NULL NULL NULL
- materialize public v char 2 NULL NO text NULL NULL NULL
- materialize public v num 1 NULL NO integer NULL NULL NULL
|
