# 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. # This file is auto-generated by ci/test/lint-docs-catalog.py mode cockroach statement ok CREATE VIEW objects AS SELECT schema.name AS schema, objects.name AS object, columns.position, columns.name, columns.type FROM mz_catalog.mz_columns AS columns, mz_catalog.mz_objects AS objects, mz_catalog.mz_schemas AS schema WHERE columns.id = objects.id AND objects.schema_id = schema.id statement ok CREATE INDEX objects_idx ON objects(schema, object) query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_array_types' ORDER BY position ---- 1 id text 2 element_id text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_audit_events' ORDER BY position ---- 1 id uint8 2 event_type text 3 object_type text 4 details jsonb 5 user text 6 occurred_at timestamp␠with␠time␠zone query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_aws_privatelink_connections' ORDER BY position ---- 1 id text 2 principal text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_base_types' ORDER BY position ---- 1 id text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_cluster_replica_frontiers' ORDER BY position ---- 1 object_id text 2 replica_id text 3 write_frontier mz_timestamp query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_cluster_replica_sizes' ORDER BY position ---- 1 size text 2 processes uint8 3 workers uint8 4 cpu_nano_cores uint8 5 memory_bytes uint8 6 disk_bytes uint8 7 credits_per_hour numeric query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_cluster_replicas' ORDER BY position ---- 1 id text 2 name text 3 cluster_id text 4 size text 5 availability_zone text 6 owner_id text 7 disk boolean query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_clusters' ORDER BY position ---- 1 id text 2 name text 3 owner_id text 4 privileges mz_aclitem[] 5 managed boolean 6 size text 7 replication_factor uint4 8 disk boolean 9 availability_zones list 10 introspection_debugging boolean 11 introspection_interval interval query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_columns' ORDER BY position ---- 1 id text 2 name text 3 position uint8 4 nullable boolean 5 type text 6 default text 7 type_oid oid 8 type_mod integer query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_connections' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 type text 6 owner_id text 7 privileges mz_aclitem[] 8 create_sql text 9 redacted_create_sql text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_databases' ORDER BY position ---- 1 id text 2 oid oid 3 name text 4 owner_id text 5 privileges mz_aclitem[] query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_default_privileges' ORDER BY position ---- 1 role_id text 2 database_id text 3 schema_id text 4 object_type text 5 grantee text 6 privileges text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_egress_ips' ORDER BY position ---- 1 egress_ip text 2 prefix_length integer 3 cidr text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_functions' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 argument_type_ids text[] 6 variadic_argument_type_id text 7 return_type_id text 8 returns_set boolean 9 owner_id text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_indexes' ORDER BY position ---- 1 id text 2 oid oid 3 name text 4 on_id text 5 cluster_id text 6 owner_id text 7 create_sql text 8 redacted_create_sql text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_index_columns' ORDER BY position ---- 1 index_id text 2 index_position uint8 3 on_position uint8 4 on_expression text 5 nullable boolean query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_kafka_connections' ORDER BY position ---- 1 id text 2 brokers text[] 3 sink_progress_topic text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_kafka_sinks' ORDER BY position ---- 1 id text 2 topic text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_kafka_sources' ORDER BY position ---- 1 id text 2 group_id_prefix text 3 topic text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_list_types' ORDER BY position ---- 1 id text 2 element_id text 3 element_modifiers list query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_map_types' ORDER BY position ---- 1 id text 2 key_id text 3 value_id text 4 key_modifiers list 5 value_modifiers list query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_materialized_views' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 cluster_id text 6 definition text 7 owner_id text 8 privileges mz_aclitem[] 9 create_sql text 10 redacted_create_sql text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_objects' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 type text 6 owner_id text 7 cluster_id text 8 privileges mz_aclitem[] query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_pseudo_types' ORDER BY position ---- 1 id text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_relations' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 type text 6 owner_id text 7 cluster_id text 8 privileges mz_aclitem[] query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_recent_storage_usage' ORDER BY position ---- 1 object_id text 2 size_bytes uint8 query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_roles' ORDER BY position ---- 1 id text 2 oid oid 3 name text 4 inherit boolean query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_role_members' ORDER BY position ---- 1 role_id text 2 member text 3 grantor text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_role_parameters' ORDER BY position ---- 1 role_id text 2 parameter_name text 3 parameter_value text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_schemas' ORDER BY position ---- 1 id text 2 oid oid 3 database_id text 4 name text 5 owner_id text 6 privileges mz_aclitem[] query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_secrets' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 owner_id text 6 privileges mz_aclitem[] query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_ssh_tunnel_connections' ORDER BY position ---- 1 id text 2 public_key_1 text 3 public_key_2 text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_sinks' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 type text 6 connection_id text 7 size text 8 envelope_type text 9 format text 10 key_format text 11 value_format text 12 cluster_id text 13 owner_id text 14 create_sql text 15 redacted_create_sql text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_sources' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 type text 6 connection_id text 7 size text 8 envelope_type text 9 key_format text 10 value_format text 11 cluster_id text 12 owner_id text 13 privileges mz_aclitem[] 14 create_sql text 15 redacted_create_sql text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_storage_usage' ORDER BY position ---- 1 object_id text 2 size_bytes uint8 3 collection_timestamp timestamp␠with␠time␠zone query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_system_privileges' ORDER BY position ---- 1 privileges mz_aclitem query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_tables' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 owner_id text 6 privileges mz_aclitem[] 7 create_sql text 8 redacted_create_sql text 9 source_id text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_timezone_abbreviations' ORDER BY position ---- 1 abbreviation text 2 utc_offset interval 3 dst boolean 4 timezone_name text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_timezone_names' ORDER BY position ---- 1 name text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_types' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 category text 6 owner_id text 7 privileges mz_aclitem[] 8 create_sql text 9 redacted_create_sql text query ITT SELECT position, name, type FROM objects WHERE schema = 'mz_catalog' AND object = 'mz_views' ORDER BY position ---- 1 id text 2 oid oid 3 schema_id text 4 name text 5 definition text 6 owner_id text 7 privileges mz_aclitem[] 8 create_sql text 9 redacted_create_sql text query T SELECT DISTINCT object FROM objects WHERE schema IN ('mz_catalog') ORDER BY object ---- mz_array_types mz_audit_events mz_aws_privatelink_connections mz_base_types mz_cluster_replica_frontiers mz_cluster_replica_sizes mz_cluster_replicas mz_clusters mz_columns mz_connections mz_databases mz_default_privileges mz_egress_ips mz_functions mz_index_columns mz_indexes mz_kafka_connections mz_kafka_sinks mz_kafka_sources mz_list_types mz_map_types mz_materialized_views mz_objects mz_operators mz_pseudo_types mz_recent_storage_usage mz_relations mz_role_members mz_role_parameters mz_roles mz_schemas mz_secrets mz_sinks mz_sources mz_ssh_tunnel_connections mz_storage_usage mz_system_privileges mz_tables mz_timezone_abbreviations mz_timezone_names mz_types mz_views