cockroach/pkg/sql/parser/testdata/resource_group at 9aece209e3dcd682649febb5a8a69199bf0b8c72 · cockroachdb/cockroach · GitHub

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
error
CREATE RESOURCE GROUP my_group
----
at or near "EOF": syntax error
DETAIL: source SQL:
CREATE RESOURCE GROUP my_group
                              ^
HINT: try \h CREATE RESOURCE GROUP

parse
CREATE RESOURCE GROUP my_group WITH (cpu_weight = 100, max_cpu = false)
----
CREATE RESOURCE GROUP my_group WITH (cpu_weight = 100, max_cpu = false)
CREATE RESOURCE GROUP my_group WITH (cpu_weight = (100), max_cpu = (false)) -- fully parenthesized
CREATE RESOURCE GROUP my_group WITH (cpu_weight = _, max_cpu = _) -- literals removed
CREATE RESOURCE GROUP _ WITH (cpu_weight = 100, max_cpu = false) -- identifiers removed

parse
CREATE RESOURCE GROUP IF NOT EXISTS my_group WITH (cpu_weight = 1, max_cpu = true)
----
CREATE RESOURCE GROUP IF NOT EXISTS my_group WITH (cpu_weight = 1, max_cpu = true)
CREATE RESOURCE GROUP IF NOT EXISTS my_group WITH (cpu_weight = (1), max_cpu = (true)) -- fully parenthesized
CREATE RESOURCE GROUP IF NOT EXISTS my_group WITH (cpu_weight = _, max_cpu = _) -- literals removed
CREATE RESOURCE GROUP IF NOT EXISTS _ WITH (cpu_weight = 1, max_cpu = true) -- identifiers removed

parse
CREATE RESOURCE GROUP my_group WITH (bucket_count = 10)
----
CREATE RESOURCE GROUP my_group WITH (bucket_count = 10)
CREATE RESOURCE GROUP my_group WITH (bucket_count = (10)) -- fully parenthesized
CREATE RESOURCE GROUP my_group WITH (bucket_count = _) -- literals removed
CREATE RESOURCE GROUP _ WITH (bucket_count = 10) -- identifiers removed

parse
ALTER RESOURCE GROUP my_group WITH (cpu_weight = 200)
----
ALTER RESOURCE GROUP my_group WITH (cpu_weight = 200)
ALTER RESOURCE GROUP my_group WITH (cpu_weight = (200)) -- fully parenthesized
ALTER RESOURCE GROUP my_group WITH (cpu_weight = _) -- literals removed
ALTER RESOURCE GROUP _ WITH (cpu_weight = 200) -- identifiers removed

parse
ALTER RESOURCE GROUP IF EXISTS my_group WITH (max_cpu = true)
----
ALTER RESOURCE GROUP IF EXISTS my_group WITH (max_cpu = true)
ALTER RESOURCE GROUP IF EXISTS my_group WITH (max_cpu = (true)) -- fully parenthesized
ALTER RESOURCE GROUP IF EXISTS my_group WITH (max_cpu = _) -- literals removed
ALTER RESOURCE GROUP IF EXISTS _ WITH (max_cpu = true) -- identifiers removed

# The no-parens form is rejected; parentheses are required.
error
CREATE RESOURCE GROUP my_group WITH cpu_weight = 100
----
at or near "cpu_weight": syntax error
DETAIL: source SQL:
CREATE RESOURCE GROUP my_group WITH cpu_weight = 100
                                    ^
HINT: try \h CREATE RESOURCE GROUP

error
ALTER RESOURCE GROUP my_group WITH cpu_weight = 200
----
at or near "cpu_weight": syntax error
DETAIL: source SQL:
ALTER RESOURCE GROUP my_group WITH cpu_weight = 200
                                   ^
HINT: try \h ALTER RESOURCE GROUP

parse
DROP RESOURCE GROUP my_group
----
DROP RESOURCE GROUP my_group
DROP RESOURCE GROUP my_group -- fully parenthesized
DROP RESOURCE GROUP my_group -- literals removed
DROP RESOURCE GROUP _ -- identifiers removed

parse
DROP RESOURCE GROUP IF EXISTS my_group
----
DROP RESOURCE GROUP IF EXISTS my_group
DROP RESOURCE GROUP IF EXISTS my_group -- fully parenthesized
DROP RESOURCE GROUP IF EXISTS my_group -- literals removed
DROP RESOURCE GROUP IF EXISTS _ -- identifiers removed

parse
SHOW RESOURCE GROUP my_group
----
SHOW RESOURCE GROUP my_group
SHOW RESOURCE GROUP my_group -- fully parenthesized
SHOW RESOURCE GROUP my_group -- literals removed
SHOW RESOURCE GROUP _ -- identifiers removed

parse
SHOW RESOURCE GROUPS
----
SHOW RESOURCE GROUPS
SHOW RESOURCE GROUPS -- fully parenthesized
SHOW RESOURCE GROUPS -- literals removed
SHOW RESOURCE GROUPS -- identifiers removed