# 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

simple conn=mz_system,user=mz_system
ALTER SYSTEM SET enable_connection_validation_syntax TO true;
----
COMPLETE 0

# over qualified objects should return an error
query error qualified name did not have between 1 and 3 components
SELECT * FROM universe.db.schema.foo

# over qualified types should return an error
query error qualified name did not have between 1 and 3 components
SELECT 'true'::universe.database.schema.bool

# Secret values must refer to secrets
statement ok
CREATE TABLE not_a_secret (a int);

statement ok
CREATE CONNECTION kafka_conn TO KAFKA (BROKER 'broker', SECURITY PROTOCOL PLAINTEXT) WITH (VALIDATE = false);

statement error connection "materialize.public.kafka_conn" already exists
CREATE CONNECTION kafka_conn TO KAFKA (BROKER 'broker', SECURITY PROTOCOL PLAINTEXT) WITH (VALIDATE = false);

statement ok
CREATE CONNECTION IF NOT EXISTS kafka_conn TO KAFKA (BROKER 'broker', SECURITY PROTOCOL PLAINTEXT) WITH (VALIDATE = false);

statement error materialize.public.not_a_secret is not a secret
CREATE CONNECTION kafka_conn2 TO KAFKA (BROKER 'broker', SECURITY PROTOCOL PLAINTEXT, SASL PASSWORD = SECRET not_a_secret) WITH (VALIDATE = false);

statement error unknown catalog item 'not_an_object_at_all'
CREATE CONNECTION kafka_conn2 TO KAFKA (BROKER 'broker', SECURITY PROTOCOL PLAINTEXT, SASL PASSWORD = SECRET not_an_object_at_all) WITH (VALIDATE = false);

statement ok
CREATE SECRET pgpass AS 'postgres'

statement error unknown catalog item 'not_an_object_at_all'
CREATE CONNECTION pg TO POSTGRES (
  HOST postgres,
  DATABASE postgres,
  USER postgres,
  PASSWORD SECRET pgpass,
  SSL MODE require,
  SSH TUNNEL not_an_object_at_all
 ) WITH (VALIDATE = false)

statement ok
CREATE TABLE object_reference (a int);

# It's okay if idents for string options refer to objects.
statement ok
CREATE CONNECTION pg TO POSTGRES (
  HOST object_reference,
  DATABASE postgres,
  USER postgres
) WITH (VALIDATE = false)