Materialize/test/sqllogictest/autogenerated/mz_internal.slt

# 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_internal' AND object = 'mz_recent_activity_log' ORDER BY position
----
1  execution_id  uuid
2  sample_rate  double␠precision
3  cluster_id  text
4  application_name  text
5  cluster_name  text
6  database_name  text
7  search_path  list
8  transaction_isolation  text
9  execution_timestamp  uint8
10  transient_index_id  text
11  params  text[]
12  mz_version  text
13  began_at  timestamp␠with␠time␠zone
14  finished_at  timestamp␠with␠time␠zone
15  finished_status  text
16  error_message  text
17  result_size  bigint
18  rows_returned  bigint
19  execution_strategy  text
20  transaction_id  uint8
21  prepared_statement_id  uuid
22  sql_hash  bytea
23  prepared_statement_name  text
24  session_id  uuid
25  prepared_at  timestamp␠with␠time␠zone
26  statement_type  text
27  throttled_count  uint8
28  initial_application_name  text
29  authenticated_user  text
30  sql  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_aws_connections' ORDER BY position
----
1  id  text
2  endpoint  text
3  region  text
4  access_key_id  text
5  access_key_id_secret_id  text
6  secret_access_key_secret_id  text
7  session_token  text
8  session_token_secret_id  text
9  assume_role_arn  text
10  assume_role_session_name  text
11  principal  text
12  external_id  text
13  example_trust_policy  jsonb

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_aws_privatelink_connection_status_history' ORDER BY position
----
1  occurred_at  timestamp␠with␠time␠zone
2  connection_id  text
3  status  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_aws_privatelink_connection_statuses' ORDER BY position
----
1  id  text
2  name  text
3  last_status_change_at  timestamp␠with␠time␠zone
4  status  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_deployment_lineage' ORDER BY position
----
1  cluster_id  text
2  current_deployment_cluster_id  text
3  cluster_name  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_schedules' ORDER BY position
----
1  cluster_id  text
2  type  text
3  refresh_hydration_time_estimate  interval

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_metrics' ORDER BY position
----
1  replica_id  text
2  process_id  uint8
3  cpu_nano_cores  uint8
4  memory_bytes  uint8
5  disk_bytes  uint8

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_metrics_history' ORDER BY position
----
1  replica_id  text
2  process_id  uint8
3  cpu_nano_cores  uint8
4  memory_bytes  uint8
5  disk_bytes  uint8
6  occurred_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_statuses' ORDER BY position
----
1  replica_id  text
2  process_id  uint8
3  status  text
4  reason  text
5  updated_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_status_history' ORDER BY position
----
1  replica_id  text
2  process_id  uint8
3  status  text
4  reason  text
5  occurred_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_utilization' ORDER BY position
----
1  replica_id  text
2  process_id  uint8
3  cpu_percent  double␠precision
4  memory_percent  double␠precision
5  disk_percent  double␠precision

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_utilization_history' ORDER BY position
----
1  replica_id  text
2  process_id  uint8
3  cpu_percent  double␠precision
4  memory_percent  double␠precision
5  disk_percent  double␠precision
6  occurred_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_history' ORDER BY position
----
1  replica_id  text
2  size  text
3  cluster_id  text
4  cluster_name  text
5  replica_name  text
6  created_at  timestamp␠with␠time␠zone
7  dropped_at  timestamp␠with␠time␠zone
8  credits_per_hour  numeric

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_cluster_replica_name_history' ORDER BY position
----
1  occurred_at  timestamp␠with␠time␠zone
2  id  text
3  previous_name  text
4  new_name  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_internal_cluster_replicas' ORDER BY position
----
1  id           text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_pending_cluster_replicas' ORDER BY position
----
1  id           text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_comments' ORDER BY position
----
1  id  text
2  object_type  text
3  object_sub_id  integer
4  comment  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_compute_dependencies' ORDER BY position
----
1  object_id  text
2  dependency_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_compute_hydration_statuses' ORDER BY position
----
1  object_id  text
2  replica_id  text
3  hydrated  boolean
4  hydration_time  interval

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_compute_operator_hydration_statuses' ORDER BY position
----
1  object_id  text
2  physical_plan_node_id  uint8
3  replica_id  text
4  hydrated  boolean

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_frontiers' ORDER BY position
----
1  object_id  text
2  read_frontier  mz_timestamp
3  write_frontier  mz_timestamp

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_history_retention_strategies' ORDER BY position
----
1  id  text
2  strategy  text
3  value  jsonb

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_hydration_statuses' ORDER BY position
----
1  object_id  text
2  replica_id  text
3  hydrated  boolean

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_license_keys' ORDER BY position
----
1  id  text
2  organization  text
3  environment_id  text
4  expiration  timestamp␠with␠time␠zone
5  not_before  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_index_advice' ORDER BY position
----
1  object_id  text
2  hint  text
3  details  text
4  referenced_object_ids  list

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_materialization_dependencies' ORDER BY position
----
1  object_id  text
2  dependency_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_materialization_lag' ORDER BY position
----
1  object_id  text
2  local_lag  interval
3  global_lag  interval
4  slowest_local_input_id  text
5  slowest_global_input_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_materialized_view_refresh_strategies' ORDER BY position
----
1  materialized_view_id  text
2  type  text
3  interval  interval
4  aligned_to  timestamp␠with␠time␠zone
5  at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_materialized_view_refreshes' ORDER BY position
----
1  materialized_view_id  text
2  last_completed_refresh  mz_timestamp
3  next_refresh  mz_timestamp

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_object_dependencies' ORDER BY position
----
1  object_id  text
2  referenced_object_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_object_fully_qualified_names' ORDER BY position
----
1  id  text
2  name  text
3  object_type  text
4  schema_id  text
5  schema_name  text
6  database_id  text
7  database_name  text
8  cluster_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_object_lifetimes' ORDER BY position
----
1  id  text
2  previous_id  text
3  object_type  text
4  event_type  text
5  occurred_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_object_history' ORDER BY position
----
1  id  text
2  cluster_id  text
3  object_type  text
4  created_at  timestamp␠with␠time␠zone
5  dropped_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_object_transitive_dependencies' ORDER BY position
----
1  object_id  text
2  referenced_object_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_notices' ORDER BY position
----
1  id  text
2  notice_type  text
3  message  text
4  hint  text
5  action  text
6  redacted_message  text
7  redacted_hint  text
8  redacted_action  text
9  action_type  text
10  object_id  text
11  created_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_notices_redacted' ORDER BY position
----
1  id  text
2  notice_type  text
3  message  text
4  hint  text
5  action  text
6  action_type  text
7  object_id  text
8  created_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_postgres_sources' ORDER BY position
----
1  id  text
2  replication_slot  text
3  timeline_id  uint8

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_postgres_source_tables' ORDER BY position
----
1  id  text
2  schema_name  text
3  table_name  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_mysql_source_tables' ORDER BY position
----
1  id  text
2  schema_name  text
3  table_name  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_sql_server_source_tables' ORDER BY position
----
1  id  text
2  schema_name  text
3  table_name  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_kafka_source_tables' ORDER BY position
----
1  id  text
2  topic  text
3  envelope_type  text
4  key_format  text
5  value_format  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_sessions' ORDER BY position
----
1  id  uuid
2  connection_id  uint4
3  role_id  text
4  client_ip  text
5  connected_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_network_policies' ORDER BY position
----
1  id  text
2  name  text
3  owner_id  text
4  privileges  mz_aclitem[]
5  oid  oid

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_network_policy_rules' ORDER BY position
----
1  name  text
2  policy_id  text
3  action  text
4  address  text
5  direction  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_all_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  database  text
4  schema  text
5  name  text
6  object_type  text
7  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_cluster_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  name  text
4  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_database_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  name  text
4  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_default_privileges' ORDER BY position
----
1  object_owner  text
2  database  text
3  schema  text
4  object_type  text
5  grantee  text
6  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_object_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  database  text
4  schema  text
5  name  text
6  object_type  text
7  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_role_members' ORDER BY position
----
1  role  text
2  member  text
3  grantor  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_schema_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  database  text
4  name  text
5  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_system_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_all_my_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  database  text
4  schema  text
5  name  text
6  object_type  text
7  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_cluster_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  name  text
4  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_database_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  name  text
4  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_default_privileges' ORDER BY position
----
1  object_owner  text
2  database  text
3  schema  text
4  object_type  text
5  grantee  text
6  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_object_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  database  text
4  schema  text
5  name  text
6  object_type  text
7  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_role_members' ORDER BY position
----
1  role  text
2  member  text
3  grantor  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_schema_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  database  text
4  name  text
5  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_show_my_system_privileges' ORDER BY position
----
1  grantor  text
2  grantee  text
3  privilege_type  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_sink_statistics' ORDER BY position
----
1  id  text
2  replica_id  text
3  messages_staged  uint8
4  messages_committed  uint8
5  bytes_staged  uint8
6  bytes_committed  uint8

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_sink_statuses' ORDER BY position
----
1  id  text
2  name  text
3  type  text
4  last_status_change_at  timestamp␠with␠time␠zone
5  status  text
6  error  text
7  details  jsonb

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_sink_status_history' ORDER BY position
----
1  occurred_at  timestamp␠with␠time␠zone
2  sink_id  text
3  status  text
4  error  text
5  details  jsonb
6  replica_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_source_statistics' ORDER BY position
----
1  id  text
2  replica_id  text
3  messages_received  uint8
4  bytes_received  uint8
5  updates_staged  uint8
6  updates_committed  uint8
7  records_indexed  uint8
8  bytes_indexed  uint8
9  rehydration_latency  interval
10  snapshot_records_known  uint8
11  snapshot_records_staged  uint8
12  snapshot_committed  boolean
13  offset_known  uint8
14  offset_committed  uint8

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_source_statuses' ORDER BY position
----
1  id  text
2  name  text
3  type  text
4  last_status_change_at  timestamp␠with␠time␠zone
5  status  text
6  error  text
7  details  jsonb

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_source_status_history' ORDER BY position
----
1  occurred_at  timestamp␠with␠time␠zone
2  source_id  text
3  status  text
4  error  text
5  details  jsonb
6  replica_id  text

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_statement_lifecycle_history' ORDER BY position
----
1  statement_id  uuid
2  event_type  text
3  occurred_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_subscriptions' ORDER BY position
----
1  id  text
2  session_id  uuid
3  cluster_id  text
4  created_at  timestamp␠with␠time␠zone
5  referenced_object_ids  list

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_wallclock_global_lag' ORDER BY position
----
1  object_id  text
2  lag  interval

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_wallclock_lag_history' ORDER BY position
----
1  object_id  text
2  replica_id  text
3  lag  interval
4  occurred_at  timestamp␠with␠time␠zone

query ITT
SELECT position, name, type FROM objects WHERE schema = 'mz_internal' AND object = 'mz_webhook_sources' ORDER BY position
----
1  id  text
2  name  text
3  url  text

query T
SELECT DISTINCT object FROM objects WHERE schema IN ('mz_internal') ORDER BY object
----
mz_activity_log_thinned
mz_aggregates
mz_aws_connections
mz_aws_privatelink_connection_status_history
mz_aws_privatelink_connection_statuses
mz_cluster_deployment_lineage
mz_cluster_replica_history
mz_cluster_replica_metrics
mz_cluster_replica_metrics_history
mz_cluster_replica_name_history
mz_cluster_replica_status_history
mz_cluster_replica_statuses
mz_cluster_replica_utilization
mz_cluster_replica_utilization_history
mz_cluster_schedules
mz_cluster_workload_classes
mz_comments
mz_compute_dependencies
mz_compute_error_counts_raw_unified
mz_compute_hydration_statuses
mz_compute_hydration_times
mz_compute_operator_hydration_statuses
mz_compute_operator_hydration_statuses_per_worker
mz_console_cluster_utilization_overview
mz_continual_tasks
mz_frontiers
mz_global_frontiers
mz_history_retention_strategies
mz_hydration_statuses
mz_index_advice
mz_internal_cluster_replicas
mz_kafka_source_tables
mz_license_keys
mz_materialization_dependencies
mz_materialization_lag
mz_materialized_view_refresh_strategies
mz_materialized_view_refreshes
mz_mysql_source_tables
mz_network_policies
mz_network_policy_rules
mz_notices
mz_notices_redacted
mz_object_dependencies
mz_object_fully_qualified_names
mz_object_history
mz_object_lifetimes
mz_object_oid_alias
mz_object_transitive_dependencies
mz_objects_id_namespace_types
mz_optimizer_notices
mz_pending_cluster_replicas
mz_postgres_source_tables
mz_postgres_sources
mz_prepared_statement_history
mz_recent_activity_log
mz_recent_activity_log_redacted
mz_recent_activity_log_thinned
mz_recent_sql_text
mz_recent_sql_text_redacted
mz_session_history
mz_sessions
mz_show_all_my_privileges
mz_show_all_objects
mz_show_all_privileges
mz_show_cluster_privileges
mz_show_cluster_replicas
mz_show_clusters
mz_show_columns
mz_show_connections
mz_show_continual_tasks
mz_show_database_privileges
mz_show_databases
mz_show_default_privileges
mz_show_indexes
mz_show_materialized_views
mz_show_my_cluster_privileges
mz_show_my_database_privileges
mz_show_my_default_privileges
mz_show_my_object_privileges
mz_show_my_role_members
mz_show_my_schema_privileges
mz_show_my_system_privileges
mz_show_network_policies
mz_show_object_privileges
mz_show_role_members
mz_show_roles
mz_show_schema_privileges
mz_show_schemas
mz_show_secrets
mz_show_sinks
mz_show_sources
mz_show_system_privileges
mz_show_tables
mz_show_types
mz_show_views
mz_sink_statistics
mz_sink_statistics_raw
mz_sink_status_history
mz_sink_statuses
mz_source_references
mz_source_statistics
mz_source_statistics_raw
mz_source_statistics_with_history
mz_source_status_history
mz_source_statuses
mz_sql_server_source_tables
mz_sql_text
mz_sql_text_redacted
mz_statement_execution_history
mz_statement_execution_history_redacted
mz_statement_lifecycle_history
mz_storage_shards
mz_storage_usage_by_shard
mz_subscriptions
mz_type_pg_metadata
mz_wallclock_global_lag
mz_wallclock_global_lag_histogram
mz_wallclock_global_lag_histogram_raw
mz_wallclock_global_lag_history
mz_wallclock_global_lag_recent_history
mz_wallclock_lag_history
mz_webhook_sources
pg_attrdef_all_databases
pg_attribute_all_databases
pg_class_all_databases
pg_description_all_databases
pg_namespace_all_databases
pg_type_all_databases