-
Notifications
You must be signed in to change notification settings - Fork 465
/
Copy pathalter.slt
192 lines (143 loc) · 5.71 KB
/
alter.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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
# 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
simple conn=mz_system,user=mz_system
ALTER SYSTEM SET enable_index_options = on;
----
COMPLETE 0
simple conn=mz_system,user=mz_system
ALTER SYSTEM SET enable_rbac_checks TO false;
----
COMPLETE 0
query error must be owner of TABLE mz_catalog.mz_tables
ALTER TABLE mz_tables RENAME TO foo;
query error must be owner of SOURCE mz_internal.mz_storage_shards
ALTER SOURCE mz_internal.mz_storage_shards RENAME TO foo;
simple conn=mz_system,user=mz_system
ALTER TABLE mz_tables RENAME TO foo;
----
db error: ERROR: system item 'mz_catalog.mz_tables' cannot be modified
simple conn=mz_system,user=mz_system
ALTER SOURCE mz_internal.mz_storage_shards RENAME TO foo;
----
db error: ERROR: system item 'mz_internal.mz_storage_shards' cannot be modified
query error Expected one of TIMESTAMP or RETAIN, found SIZE
ALTER SOURCE mz_internal.mz_storage_shards RESET (size);
statement ok
CREATE CONNECTION c TO KAFKA (BROKER 'localhost:9092', SECURITY PROTOCOL PLAINTEXT) WITH (VALIDATE = false);
query TTT
SHOW CONNECTIONS
----
c kafka (empty)
statement ok
ALTER CONNECTION c RENAME TO d;
query TTT
SHOW CONNECTIONS
----
d kafka (empty)
statement ok
CREATE CLUSTER other_cluster SIZE '1', REPLICATION FACTOR 0
query error db error: ERROR: ALTER \.\.\. SET CLUSTER syntax is not available
ALTER MATERIALIZED VIEW does_not_exist SET CLUSTER quickstart
query error db error: ERROR: ALTER \.\.\. SET CLUSTER syntax is not available
ALTER SOURCE does_not_exist SET CLUSTER quickstart
query error db error: ERROR: ALTER \.\.\. SET CLUSTER syntax is not available
ALTER SINK does_not_exist SET CLUSTER quickstart
simple conn=mz_system,user=mz_system
ALTER SYSTEM SET enable_alter_set_cluster = on;
----
COMPLETE 0
statement ok
CREATE VIEW v AS SELECT 1
statement ok
CREATE MATERIALIZED VIEW mv AS SELECT 1
statement ok
ALTER MATERIALIZED VIEW mv SET CLUSTER quickstart
query error db error: ERROR: unknown cluster 'does_not_exist'
ALTER MATERIALIZED VIEW mv SET CLUSTER does_not_exist
query error db error: ERROR: ALTER SET CLUSTER are not supported
ALTER MATERIALIZED VIEW mv SET CLUSTER other_cluster
query error db error: ERROR: ALTER VIEW SET CLUSTER is not supported, for more information consult the documentation at https://materialize\.com/docs/sql/alter\-set\-cluster/
ALTER VIEW mv SET CLUSTER quickstart
query error db error: ERROR: v is a view not a materialized view
ALTER MATERIALIZED VIEW v SET CLUSTER quickstart
query error db error: ERROR: ALTER SINK SET CLUSTER not yet supported, see https://github\.com/MaterializeInc/materialize/discussions/29606 for more details
ALTER SINK v SET CLUSTER quickstart
statement ok
CREATE SOURCE s FROM LOAD GENERATOR COUNTER WITH (RETAIN HISTORY FOR '5m')
query T
SELECT create_sql FROM (SHOW CREATE MATERIALIZED VIEW mv)
----
CREATE MATERIALIZED VIEW "materialize"."public"."mv" IN CLUSTER "quickstart" WITH (REFRESH = ON COMMIT) AS SELECT 1
statement ok
ALTER MATERIALIZED VIEW mv SET (RETAIN HISTORY FOR '1m')
query T
SELECT create_sql FROM (SHOW CREATE MATERIALIZED VIEW mv)
----
CREATE MATERIALIZED VIEW "materialize"."public"."mv" IN CLUSTER "quickstart" WITH (REFRESH = ON COMMIT, RETAIN HISTORY = FOR '1m') AS SELECT 1
statement ok
ALTER MATERIALIZED VIEW mv RESET (RETAIN HISTORY)
query T
SELECT create_sql FROM (SHOW CREATE MATERIALIZED VIEW mv)
----
CREATE MATERIALIZED VIEW "materialize"."public"."mv" IN CLUSTER "quickstart" WITH (REFRESH = ON COMMIT) AS SELECT 1
statement ok
CREATE TABLE t (a INT) WITH (RETAIN HISTORY FOR '1000 hours')
query T
SELECT create_sql FROM (SHOW CREATE TABLE t)
----
CREATE TABLE "materialize"."public"."t" ("a" "pg_catalog"."int4") WITH (RETAIN HISTORY = FOR '1000 hours')
statement ok
CREATE INDEX i ON t(a)
statement ok
ALTER TABLE t SET (RETAIN HISTORY FOR '1m')
query T
SELECT create_sql FROM (SHOW CREATE TABLE t)
----
CREATE TABLE "materialize"."public"."t" ("a" "pg_catalog"."int4") WITH (RETAIN HISTORY = FOR '1m')
statement ok
ALTER TABLE t RESET (RETAIN HISTORY)
query T
SELECT create_sql FROM (SHOW CREATE TABLE t)
----
CREATE TABLE "materialize"."public"."t" ("a" "pg_catalog"."int4")
statement ok
ALTER SOURCE s SET (RETAIN HISTORY FOR '1m')
query T
SELECT create_sql FROM (SHOW CREATE SOURCE s)
----
CREATE SOURCE "materialize"."public"."s" IN CLUSTER "quickstart" FROM LOAD GENERATOR COUNTER EXPOSE PROGRESS AS "materialize"."public"."s_progress" WITH (RETAIN HISTORY = FOR '1m')
statement ok
ALTER SOURCE s RESET (RETAIN HISTORY)
query T
SELECT create_sql FROM (SHOW CREATE SOURCE s)
----
CREATE SOURCE "materialize"."public"."s" IN CLUSTER "quickstart" FROM LOAD GENERATOR COUNTER EXPOSE PROGRESS AS "materialize"."public"."s_progress"
statement ok
ALTER INDEX i SET (RETAIN HISTORY FOR '1m')
query T
SELECT create_sql FROM (SHOW CREATE INDEX i)
----
CREATE INDEX "i" IN CLUSTER "quickstart" ON "materialize"."public"."t" ("a") WITH (RETAIN HISTORY = FOR '1m')
statement ok
ALTER INDEX i SET (RETAIN HISTORY = FOR '1000 hours')
query T
SELECT create_sql FROM (SHOW CREATE INDEX i)
----
CREATE INDEX "i" IN CLUSTER "quickstart" ON "materialize"."public"."t" ("a") WITH (RETAIN HISTORY = FOR '1000 hours')
statement ok
ALTER INDEX i RESET (RETAIN HISTORY)
query T
SELECT create_sql FROM (SHOW CREATE INDEX i)
----
CREATE INDEX "i" IN CLUSTER "quickstart" ON "materialize"."public"."t" ("a")