oceanbase

1
drop tablegroup if exists show_create_tg_0;
2
create tablegroup show_create_tg_0;
3
show create tablegroup show_create_tg_0;
4
Tablegroup	Create Tablegroup
5
show_create_tg_0	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_0`  SHARDING = 'ADAPTIVE'
6
drop tablegroup if exists show_create_tg_0;
7
drop tablegroup if exists show_create_tg_1;
8
create tablegroup show_create_tg_1 partition by hash partitions 2;
9
Warnings:
10
Warning	1235	create tablegroup with partition not supported
11
show create tablegroup show_create_tg_1;
12
Tablegroup	Create Tablegroup
13
show_create_tg_1	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_1`  SHARDING = 'ADAPTIVE'
14
drop tablegroup if exists show_create_tg_1;
15
drop tablegroup if exists show_create_tg_2;
16
create tablegroup show_create_tg_2 partition by key 2 partitions 2;
17
Warnings:
18
Warning	1235	create tablegroup with partition not supported
19
show create tablegroup show_create_tg_2;
20
Tablegroup	Create Tablegroup
21
show_create_tg_2	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_2`  SHARDING = 'ADAPTIVE'
22
drop tablegroup if exists show_create_tg_2;
23
drop tablegroup if exists show_create_tg_3;
24
create tablegroup show_create_tg_3 partition by range (partition p0 values less than (100), partition p1 values less than (200), partition p2 values less than (MAXVALUE));
25
Warnings:
26
Warning	1235	create tablegroup with partition not supported
27
show create tablegroup show_create_tg_3;
28
Tablegroup	Create Tablegroup
29
show_create_tg_3	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_3`  SHARDING = 'ADAPTIVE'
30
drop tablegroup if exists show_create_tg_3;
31
drop tablegroup if exists show_create_tg_4;
32
create tablegroup show_create_tg_4 partition by range columns 2 (partition p0 values less than (1, '100'), partition p1 values less than (2, '200'), partition p2 values less than (MAXVALUE, MAXVALUE));
33
Warnings:
34
Warning	1235	create tablegroup with partition not supported
35
show create tablegroup show_create_tg_4;
36
Tablegroup	Create Tablegroup
37
show_create_tg_4	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_4`  SHARDING = 'ADAPTIVE'
38
drop tablegroup if exists show_create_tg_4;
39
drop tablegroup if exists show_create_tg_5;
40
create tablegroup show_create_tg_5 partition by list (partition p0 values in (0, 1), partition p1 values in (2, 3), partition p3 values in (DEFAULT));
41
Warnings:
42
Warning	1235	create tablegroup with partition not supported
43
show create tablegroup show_create_tg_5;
44
Tablegroup	Create Tablegroup
45
show_create_tg_5	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_5`  SHARDING = 'ADAPTIVE'
46
drop tablegroup if exists show_create_tg_5;
47
drop tablegroup if exists show_create_tg_6;
48
create tablegroup show_create_tg_6 partition by list columns 2 (partition p0 values in (('00', 0), ('01', 1)), partition p1 values in (('02', 2), ('03', 3)), partition p3 values in (DEFAULT));
49
Warnings:
50
Warning	1235	create tablegroup with partition not supported
51
show create tablegroup show_create_tg_6;
52
Tablegroup	Create Tablegroup
53
show_create_tg_6	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_6`  SHARDING = 'ADAPTIVE'
54
drop tablegroup if exists show_create_tg_6;
55
drop tablegroup if exists show_create_tg_7;
56
create tablegroup show_create_tg_7 partition by hash subpartition by range subpartition template (subpartition p0 values less than (100), subpartition p1 values less than (200), subpartition p2 values less than (MAXVALUE)) partitions 2;
57
Warnings:
58
Warning	1235	create tablegroup with partition not supported
59
show create tablegroup show_create_tg_7;
60
Tablegroup	Create Tablegroup
61
show_create_tg_7	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_7`  SHARDING = 'ADAPTIVE'
62
drop tablegroup if exists show_create_tg_7;
63
drop tablegroup if exists show_create_tg_8;
64
create tablegroup show_create_tg_8 partition by hash subpartition by range columns 2 subpartition template (subpartition p0 values less than (1, '100'), subpartition p1 values less than (2, '200'), subpartition p2 values less than (MAXVALUE, MAXVALUE)) partitions 2;
65
Warnings:
66
Warning	1235	create tablegroup with partition not supported
67
show create tablegroup show_create_tg_8;
68
Tablegroup	Create Tablegroup
69
show_create_tg_8	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_8`  SHARDING = 'ADAPTIVE'
70
drop tablegroup if exists show_create_tg_8;
71
drop tablegroup if exists show_create_tg_9;
72
create tablegroup show_create_tg_9 partition by hash subpartition by list subpartition template (subpartition p0 values in (0, 1), subpartition p1 values in (2, 3), subpartition p3 values in (DEFAULT)) partitions 2;
73
Warnings:
74
Warning	1235	create tablegroup with partition not supported
75
show create tablegroup show_create_tg_9;
76
Tablegroup	Create Tablegroup
77
show_create_tg_9	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_9`  SHARDING = 'ADAPTIVE'
78
drop tablegroup if exists show_create_tg_9;
79
drop tablegroup if exists show_create_tg_10;
80
create tablegroup show_create_tg_10 partition by hash subpartition by list columns 2 subpartition template (subpartition p0 values in (('00', 0), ('01', 1)), subpartition p1 values in (('02', 2), ('03', 3)), subpartition p3 values in (DEFAULT)) partitions 2;
81
Warnings:
82
Warning	1235	create tablegroup with partition not supported
83
show create tablegroup show_create_tg_10;
84
Tablegroup	Create Tablegroup
85
show_create_tg_10	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_10`  SHARDING = 'ADAPTIVE'
86
drop tablegroup if exists show_create_tg_10;
87
drop tablegroup if exists show_create_tg_11;
88
create tablegroup show_create_tg_11 partition by key 2 subpartition by range subpartition template (subpartition p0 values less than (100), subpartition p1 values less than (200), subpartition p2 values less than (MAXVALUE)) partitions 2;
89
Warnings:
90
Warning	1235	create tablegroup with partition not supported
91
show create tablegroup show_create_tg_11;
92
Tablegroup	Create Tablegroup
93
show_create_tg_11	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_11`  SHARDING = 'ADAPTIVE'
94
drop tablegroup if exists show_create_tg_11;
95
drop tablegroup if exists show_create_tg_12;
96
create tablegroup show_create_tg_12 partition by key 2 subpartition by range columns 2 subpartition template (subpartition p0 values less than (1, '100'), subpartition p1 values less than (2, '200'), subpartition p2 values less than (MAXVALUE, MAXVALUE)) partitions 2;
97
Warnings:
98
Warning	1235	create tablegroup with partition not supported
99
show create tablegroup show_create_tg_12;
100
Tablegroup	Create Tablegroup
101
show_create_tg_12	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_12`  SHARDING = 'ADAPTIVE'
102
drop tablegroup if exists show_create_tg_12;
103
drop tablegroup if exists show_create_tg_13;
104
create tablegroup show_create_tg_13 partition by key 2 subpartition by list subpartition template (subpartition p0 values in (0, 1), subpartition p1 values in (2, 3), subpartition p3 values in (DEFAULT)) partitions 2;
105
Warnings:
106
Warning	1235	create tablegroup with partition not supported
107
show create tablegroup show_create_tg_13;
108
Tablegroup	Create Tablegroup
109
show_create_tg_13	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_13`  SHARDING = 'ADAPTIVE'
110
drop tablegroup if exists show_create_tg_13;
111
drop tablegroup if exists show_create_tg_14;
112
create tablegroup show_create_tg_14 partition by key 2 subpartition by list columns 2 subpartition template (subpartition p0 values in (('00', 0), ('01', 1)), subpartition p1 values in (('02', 2), ('03', 3)), subpartition p3 values in (DEFAULT)) partitions 2;
113
Warnings:
114
Warning	1235	create tablegroup with partition not supported
115
show create tablegroup show_create_tg_14;
116
Tablegroup	Create Tablegroup
117
show_create_tg_14	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_14`  SHARDING = 'ADAPTIVE'
118
drop tablegroup if exists show_create_tg_14;
119
drop tablegroup if exists show_create_tg_15;
120
create tablegroup show_create_tg_15 partition by range subpartition by hash subpartitions 2 (partition p0 values less than (100), partition p1 values less than (200), partition p2 values less than (MAXVALUE));
121
Warnings:
122
Warning	1235	create tablegroup with partition not supported
123
show create tablegroup show_create_tg_15;
124
Tablegroup	Create Tablegroup
125
show_create_tg_15	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_15`  SHARDING = 'ADAPTIVE'
126
drop tablegroup if exists show_create_tg_15;
127
drop tablegroup if exists show_create_tg_16;
128
create tablegroup show_create_tg_16 partition by range subpartition by key 2 subpartitions 2 (partition p0 values less than (100), partition p1 values less than (200), partition p2 values less than (MAXVALUE));
129
Warnings:
130
Warning	1235	create tablegroup with partition not supported
131
show create tablegroup show_create_tg_16;
132
Tablegroup	Create Tablegroup
133
show_create_tg_16	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_16`  SHARDING = 'ADAPTIVE'
134
drop tablegroup if exists show_create_tg_16;
135
drop tablegroup if exists show_create_tg_17;
136
create tablegroup show_create_tg_17 partition by range subpartition by list subpartition template (subpartition p0 values in (0, 1), subpartition p1 values in (2, 3), subpartition p3 values in (DEFAULT)) (partition p0 values less than (100), partition p1 values less than (200), partition p2 values less than (MAXVALUE));
137
Warnings:
138
Warning	1235	create tablegroup with partition not supported
139
show create tablegroup show_create_tg_17;
140
Tablegroup	Create Tablegroup
141
show_create_tg_17	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_17`  SHARDING = 'ADAPTIVE'
142
drop tablegroup if exists show_create_tg_17;
143
drop tablegroup if exists show_create_tg_18;
144
create tablegroup show_create_tg_18 partition by range subpartition by list columns 2 subpartition template (subpartition p0 values in (('00', 0), ('01', 1)), subpartition p1 values in (('02', 2), ('03', 3)), subpartition p3 values in (DEFAULT)) (partition p0 values less than (100), partition p1 values less than (200), partition p2 values less than (MAXVALUE));
145
Warnings:
146
Warning	1235	create tablegroup with partition not supported
147
show create tablegroup show_create_tg_18;
148
Tablegroup	Create Tablegroup
149
show_create_tg_18	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_18`  SHARDING = 'ADAPTIVE'
150
drop tablegroup if exists show_create_tg_18;
151
drop tablegroup if exists show_create_tg_19;
152
create tablegroup show_create_tg_19 partition by range columns 2 subpartition by hash subpartitions 2 (partition p0 values less than (1, '100'), partition p1 values less than (2, '200'), partition p2 values less than (MAXVALUE, MAXVALUE));
153
Warnings:
154
Warning	1235	create tablegroup with partition not supported
155
show create tablegroup show_create_tg_19;
156
Tablegroup	Create Tablegroup
157
show_create_tg_19	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_19`  SHARDING = 'ADAPTIVE'
158
drop tablegroup if exists show_create_tg_19;
159
drop tablegroup if exists show_create_tg_20;
160
create tablegroup show_create_tg_20 partition by range columns 2 subpartition by key 2 subpartitions 2 (partition p0 values less than (1, '100'), partition p1 values less than (2, '200'), partition p2 values less than (MAXVALUE, MAXVALUE));
161
Warnings:
162
Warning	1235	create tablegroup with partition not supported
163
show create tablegroup show_create_tg_20;
164
Tablegroup	Create Tablegroup
165
show_create_tg_20	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_20`  SHARDING = 'ADAPTIVE'
166
drop tablegroup if exists show_create_tg_20;
167
drop tablegroup if exists show_create_tg_21;
168
create tablegroup show_create_tg_21 partition by range columns 2 subpartition by list subpartition template (subpartition p0 values in (0, 1), subpartition p1 values in (2, 3), subpartition p3 values in (DEFAULT)) (partition p0 values less than (1, '100'), partition p1 values less than (2, '200'), partition p2 values less than (MAXVALUE, MAXVALUE));
169
Warnings:
170
Warning	1235	create tablegroup with partition not supported
171
show create tablegroup show_create_tg_21;
172
Tablegroup	Create Tablegroup
173
show_create_tg_21	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_21`  SHARDING = 'ADAPTIVE'
174
drop tablegroup if exists show_create_tg_21;
175
drop tablegroup if exists show_create_tg_22;
176
create tablegroup show_create_tg_22 partition by range columns 2 subpartition by list columns 2 subpartition template (subpartition p0 values in (('00', 0), ('01', 1)), subpartition p1 values in (('02', 2), ('03', 3)), subpartition p3 values in (DEFAULT)) (partition p0 values less than (1, '100'), partition p1 values less than (2, '200'), partition p2 values less than (MAXVALUE, MAXVALUE));
177
Warnings:
178
Warning	1235	create tablegroup with partition not supported
179
show create tablegroup show_create_tg_22;
180
Tablegroup	Create Tablegroup
181
show_create_tg_22	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_22`  SHARDING = 'ADAPTIVE'
182
drop tablegroup if exists show_create_tg_22;
183
drop tablegroup if exists show_create_tg_23;
184
create tablegroup show_create_tg_23 partition by list subpartition by hash subpartitions 2 (partition p0 values in (0, 1), partition p1 values in (2, 3), partition p3 values in (DEFAULT));
185
Warnings:
186
Warning	1235	create tablegroup with partition not supported
187
show create tablegroup show_create_tg_23;
188
Tablegroup	Create Tablegroup
189
show_create_tg_23	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_23`  SHARDING = 'ADAPTIVE'
190
drop tablegroup if exists show_create_tg_23;
191
drop tablegroup if exists show_create_tg_24;
192
create tablegroup show_create_tg_24 partition by list subpartition by key 2 subpartitions 2 (partition p0 values in (0, 1), partition p1 values in (2, 3), partition p3 values in (DEFAULT));
193
Warnings:
194
Warning	1235	create tablegroup with partition not supported
195
show create tablegroup show_create_tg_24;
196
Tablegroup	Create Tablegroup
197
show_create_tg_24	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_24`  SHARDING = 'ADAPTIVE'
198
drop tablegroup if exists show_create_tg_24;
199
drop tablegroup if exists show_create_tg_25;
200
create tablegroup show_create_tg_25 partition by list subpartition by range subpartition template (subpartition p0 values less than (100), subpartition p1 values less than (200), subpartition p2 values less than (MAXVALUE)) (partition p0 values in (0, 1), partition p1 values in (2, 3), partition p3 values in (DEFAULT));
201
Warnings:
202
Warning	1235	create tablegroup with partition not supported
203
show create tablegroup show_create_tg_25;
204
Tablegroup	Create Tablegroup
205
show_create_tg_25	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_25`  SHARDING = 'ADAPTIVE'
206
drop tablegroup if exists show_create_tg_25;
207
drop tablegroup if exists show_create_tg_26;
208
create tablegroup show_create_tg_26 partition by list subpartition by range columns 2 subpartition template (subpartition p0 values less than (1, '100'), subpartition p1 values less than (2, '200'), subpartition p2 values less than (MAXVALUE, MAXVALUE)) (partition p0 values in (0, 1), partition p1 values in (2, 3), partition p3 values in (DEFAULT));
209
Warnings:
210
Warning	1235	create tablegroup with partition not supported
211
drop tablegroup if exists show_create_tg_26;
212
drop tablegroup if exists show_create_tg_27;
213
create tablegroup show_create_tg_27 partition by list columns 2 subpartition by hash subpartitions 2 (partition p0 values in (('00', 0), ('01', 1)), partition p1 values in (('02', 2), ('03', 3)), partition p3 values in (DEFAULT));
214
Warnings:
215
Warning	1235	create tablegroup with partition not supported
216
show create tablegroup show_create_tg_27;
217
Tablegroup	Create Tablegroup
218
show_create_tg_27	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_27`  SHARDING = 'ADAPTIVE'
219
drop tablegroup if exists show_create_tg_27;
220
drop tablegroup if exists show_create_tg_28;
221
create tablegroup show_create_tg_28 partition by list columns 2 subpartition by key 2 subpartitions 2 (partition p0 values in (('00', 0), ('01', 1)), partition p1 values in (('02', 2), ('03', 3)), partition p3 values in (DEFAULT));
222
Warnings:
223
Warning	1235	create tablegroup with partition not supported
224
show create tablegroup show_create_tg_28;
225
Tablegroup	Create Tablegroup
226
show_create_tg_28	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_28`  SHARDING = 'ADAPTIVE'
227
drop tablegroup if exists show_create_tg_28;
228
drop tablegroup if exists show_create_tg_29;
229
create tablegroup show_create_tg_29 partition by list columns 2 subpartition by range subpartition template (subpartition p0 values less than (100), subpartition p1 values less than (200), subpartition p2 values less than (MAXVALUE)) (partition p0 values in (('00', 0), ('01', 1)), partition p1 values in (('02', 2), ('03', 3)), partition p3 values in (DEFAULT));
230
Warnings:
231
Warning	1235	create tablegroup with partition not supported
232
show create tablegroup show_create_tg_29;
233
Tablegroup	Create Tablegroup
234
show_create_tg_29	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_29`  SHARDING = 'ADAPTIVE'
235
drop tablegroup if exists show_create_tg_29;
236
drop tablegroup if exists show_create_tg_30;
237
create tablegroup show_create_tg_30 partition by list columns 2 subpartition by range columns 2 subpartition template (subpartition p0 values less than (1, '100'), subpartition p1 values less than (2, '200'), subpartition p2 values less than (MAXVALUE, MAXVALUE)) (partition p0 values in (('00', 0), ('01', 1)), partition p1 values in (('02', 2), ('03', 3)), partition p3 values in (DEFAULT));
238
Warnings:
239
Warning	1235	create tablegroup with partition not supported
240
show create tablegroup show_create_tg_30;
241
Tablegroup	Create Tablegroup
242
show_create_tg_30	CREATE TABLEGROUP IF NOT EXISTS `show_create_tg_30`  SHARDING = 'ADAPTIVE'
243
drop tablegroup if exists show_create_tg_30;
244