oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: bin.lb
5
# owner group: SQL2
6
# tags: ddl
7
# description:
8
#
9
## max supported primary key column count 64 - 7 = 57
10

11
--disable_query_log
12
--disable_warnings
13
drop table if exists t1;
14
--enable_warnings
15
--disable_warnings
16
drop table if exists t2;
17
--enable_warnings
18
--enable_query_log
19
create table t1 (
20
    c1 int,
21
    c2 int,
22
    c3 int,
23
    c4 int,
24
    c5 int,
25
    c6 int,
26
    c7 int,
27
    c8 int,
28
    c9 int,
29
    c10 int,
30
    c11 int,
31
    c12 int,
32
    c13 int,
33
    c14 int,
34
    c15 int,
35
    c16 int,
36
    c17 int,
37
    c18 int,
38
    c19 int,
39
    c20 int,
40
    c21 int,
41
    c22 int,
42
    c23 int,
43
    c24 int,
44
    c25 int,
45
    c26 int,
46
    c27 int,
47
    c28 int,
48
    c29 int,
49
    c30 int,
50
    c31 int,
51
    c32 int,
52
    c33 int,
53
    c34 int,
54
    c35 int,
55
    c36 int,
56
    c37 int,
57
    c38 int,
58
    c39 int,
59
    c40 int,
60
    c41 int,
61
    c42 int,
62
    c43 int,
63
    c44 int,
64
    c45 int,
65
    c46 int,
66
    c47 int,
67
    c48 int,
68
    c49 int,
69
    c50 int,
70
    c51 int,
71
    c52 int,
72
    c53 int,
73
    c54 int,
74
    c55 int,
75
    c56 int,
76
    c57 int,
77
    c58 int,
78
    c59 int,
79
    c60 int,
80
    c61 int,
81
    c62 int,
82
    c63 int,
83
    c64 int,
84
    c65 int,
85
    c66 int,
86
    c67 int,
87
    c68 int,
88
    c69 int,
89
    c70 int,
90
    c71 int,
91
    c72 int,
92
    c73 int,
93
    c74 int,
94
    c75 int,
95
    c76 int,
96
    c77 int,
97
    c78 int,
98
    c79 int,
99
    c80 int,
100

101
    primary key(
102
        c1,
103
        c2,
104
        c3,
105
        c4,
106
        c5,
107
        c6,
108
        c7,
109
        c8,
110
        c9,
111
        c10,
112
        c11,
113
        c12,
114
        c13,
115
        c14,
116
        c15,
117
        c16,
118
        c17,
119
        c18,
120
        c19,
121
        c20,
122
        c21,
123
        c22,
124
        c23,
125
        c24,
126
        c25,
127
        c26,
128
        c27,
129
        c28,
130
        c29,
131
        c30,
132
        c31,
133
        c32,
134
        c33,
135
        c34,
136
        c35,
137
        c36,
138
        c37,
139
        c38,
140
        c39,
141
        c40,
142
        c41,
143
        c42,
144
        c43,
145
        c44,
146
        c45,
147
        c46,
148
        c47,
149
        c48,
150
        c49,
151
        c50,
152
        c51,
153
        c52,
154
        c53,
155
        c54,
156
        c55,
157
        c56,
158
        c57
159
        )
160
        );
161

162
create table t2 (
163
    c1 int,
164
    c2 int,
165
    c3 int,
166
    c4 int,
167
    c5 int,
168
    c6 int,
169
    c7 int,
170
    c8 int,
171
    c9 int,
172
    c10 int,
173
    c11 int,
174
    c12 int,
175
    c13 int,
176
    c14 int,
177
    c15 int,
178
    c16 int,
179
    c17 int,
180
    c18 int,
181
    c19 int,
182
    c20 int,
183
    c21 int,
184
    c22 int,
185
    c23 int,
186
    c24 int,
187
    c25 int,
188
    c26 int,
189
    c27 int,
190
    c28 int,
191
    c29 int,
192
    c30 int,
193
    c31 int,
194
    c32 int,
195
    c33 int,
196
    c34 int,
197
    c35 int,
198
    c36 int,
199
    c37 int,
200
    c38 int,
201
    c39 int,
202
    c40 int,
203
    c41 int,
204
    c42 int,
205
    c43 int,
206
    c44 int,
207
    c45 int,
208
    c46 int,
209
    c47 int,
210
    c48 int,
211
    c49 int,
212
    c50 int,
213
    c51 int,
214
    c52 int,
215
    c53 int,
216
    c54 int,
217
    c55 int,
218
    c56 int,
219
    c57 int,
220
    c58 int,
221
    c59 int,
222
    c60 int,
223
    c61 int,
224
    c62 int,
225
    c63 int,
226
    c64 int,
227
    c65 int,
228
    c66 int,
229
    c67 int,
230
    c68 int,
231
    c69 int,
232
    c70 int,
233
    c71 int,
234
    c72 int,
235
    c73 int,
236
    c74 int,
237
    c75 int,
238
    c76 int,
239
    c77 int,
240
    c78 int,
241
    c79 int,
242
    c80 int,
243

244
    primary key(
245
        c1,
246
        c2,
247
        c3,
248
        c4,
249
        c5,
250
        c6,
251
        c7,
252
        c8,
253
        c9,
254
        c10,
255
        c11,
256
        c12,
257
        c13,
258
        c14,
259
        c15,
260
        c16,
261
        c17,
262
        c18,
263
        c19,
264
        c20,
265
        c21,
266
        c22,
267
        c23,
268
        c24,
269
        c25,
270
        c26,
271
        c27,
272
        c28,
273
        c29,
274
        c30,
275
        c31,
276
        c32,
277
        c33,
278
        c34,
279
        c35,
280
        c36,
281
        c37,
282
        c38,
283
        c39,
284
        c40,
285
        c41,
286
        c42,
287
        c43,
288
        c44,
289
        c45,
290
        c46,
291
        c47,
292
        c48,
293
        c49,
294
        c50,
295
        c51,
296
        c52,
297
        c53,
298
        c54,
299
        c55,
300
        c56,
301
        c57,
302
        c58
303
        )
304
        );
305

306
create index i1 on t1 (c80);
307

308
--disable_query_log
309
--disable_warnings
310
drop table if exists t1;
311
--enable_warnings
312
--disable_warnings
313
drop table if exists t2;
314
--enable_warnings
315
--enable_query_log
316