-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathcreate-sequence.sql
176 lines (151 loc) · 4.84 KB
/
create-sequence.sql
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
EXPLAIN CREATE SEQUENCE seq1;
-- error 42601: syntax error: Cannot EXPLAIN CREATE SEQUENCE
CREATE SEQUENCE seq1;
EXPLAIN VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- EXPLAIN: VALUES (COL1 INTEGER) = ROW(NEXT VALUE FOR SEQ1)
CREATE SEQUENCE seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 1
-- COL1: 2
CREATE SEQUENCE foo.seq1;
-- error 3F000: invalid schema name: FOO
CREATE SEQUENCE public.seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR public.seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 1
-- COL1: 2
CREATE SCHEMA foo;
CREATE SEQUENCE foo.seq1;
-- msg: CREATE SCHEMA 1
-- msg: CREATE SEQUENCE 1
VALUES NEXT VALUE FOR seq1;
-- error 42P01: no such sequence: ":memory:".PUBLIC.SEQ1
CREATE SEQUENCE seq1;
CREATE SEQUENCE seq2;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq2;
-- msg: CREATE SEQUENCE 1
-- msg: CREATE SEQUENCE 1
-- COL1: 1
-- COL1: 1
CREATE SEQUENCE seq1 START WITH 51;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 51
-- COL1: 52
CREATE SEQUENCE seq1 INCREMENT BY 2;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 1
-- COL1: 3
CREATE SEQUENCE seq1 INCREMENT BY 2;
VALUES NEXT VALUE FOR seq1, NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 1
-- COL1: 3
CREATE SEQUENCE seq1 INCREMENT BY 2 START WITH 17;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 17 COL2: 19
CREATE SEQUENCE seq1 INCREMENT BY 2 MINVALUE 17;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 17 COL2: 19
CREATE SEQUENCE seq1 INCREMENT BY 3 MINVALUE 17 START WITH 24;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 24 COL2: 27
CREATE SEQUENCE seq1 START WITH 17 INCREMENT BY -2;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 17 COL2: 15
CREATE SEQUENCE seq1 INCREMENT BY -2 MAXVALUE 50;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 50 COL2: 48
CREATE SEQUENCE seq1 START WITH 17 INCREMENT BY -2 MAXVALUE 50;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 17 COL2: 15
CREATE SEQUENCE seq1 START WITH 10 INCREMENT BY 5 MAXVALUE 20 CYCLE;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 10 COL2: 15
-- COL1: 20 COL2: 1
-- COL1: 6 COL2: 11
CREATE SEQUENCE seq1 MINVALUE 10 INCREMENT BY 5 MAXVALUE 20 CYCLE;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 10 COL2: 15
-- COL1: 20 COL2: 10
-- COL1: 15 COL2: 20
CREATE SEQUENCE seq1 MINVALUE 5 INCREMENT BY 5 MAXVALUE 20 CYCLE START WITH 7;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 7 COL2: 12
-- COL1: 17 COL2: 5
-- COL1: 10 COL2: 15
CREATE SEQUENCE seq1 START WITH 10 INCREMENT BY 5 MAXVALUE 20 NO CYCLE;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 10
-- COL1: 15
-- COL1: 20
-- error 2200H: sequence generator limit exceeded: PUBLIC.SEQ1
CREATE SEQUENCE seq1 START WITH 30 INCREMENT BY -5 MINVALUE 20 NO CYCLE;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 30
-- COL1: 25
-- COL1: 20
-- error 2200H: sequence generator limit exceeded: PUBLIC.SEQ1
CREATE SEQUENCE seq1 START WITH 10 INCREMENT BY 5 MAXVALUE 20;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 10
-- COL1: 15
-- COL1: 20
-- error 2200H: sequence generator limit exceeded: PUBLIC.SEQ1
CREATE SEQUENCE seq1 START WITH 30 INCREMENT BY -5 MINVALUE 20;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
VALUES NEXT VALUE FOR seq1;
-- msg: CREATE SEQUENCE 1
-- COL1: 30
-- COL1: 25
-- COL1: 20
-- error 2200H: sequence generator limit exceeded: PUBLIC.SEQ1
CREATE SEQUENCE seq1 START WITH 10 INCREMENT BY 5 NO MAXVALUE;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 10 COL2: 15
-- COL1: 20 COL2: 25
CREATE SEQUENCE seq1 START WITH 10 INCREMENT BY -5 NO MINVALUE;
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
VALUES ROW(NEXT VALUE FOR seq1, NEXT VALUE FOR seq1);
-- msg: CREATE SEQUENCE 1
-- COL1: 10 COL2: 5
-- COL1: 0 COL2: -5