forked from MaterializeInc/materialize
-
Notifications
You must be signed in to change notification settings - Fork 0
/
name_resolution.slt
61 lines (48 loc) · 1.85 KB
/
name_resolution.slt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
# 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
# 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');
statement error catalog item 'kafka_conn' already exists
CREATE CONNECTION kafka_conn TO KAFKA (BROKER 'broker');
statement ok
CREATE CONNECTION IF NOT EXISTS kafka_conn TO KAFKA (BROKER 'broker');
statement error materialize.public.not_a_secret is not a secret
CREATE CONNECTION kafka_conn2 TO KAFKA (BROKER 'broker', SASL PASSWORD = SECRET not_a_secret);
statement error unknown catalog item 'not_an_object_at_all'
CREATE CONNECTION kafka_conn2 TO KAFKA (BROKER 'broker', SASL PASSWORD = SECRET not_an_object_at_all);
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
)
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
)