# 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