1
1
drop table if exists t1;
2
CREATE TABLE t1 (a INTEGER NOT NULL, PRIMARY KEY (a));
3
INSERT INTO t1 VALUES (1),(1);
4
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
6
CREATE TABLE t1 (a INTEGER NOT NULL, PRIMARY KEY (a))
7
PARTITION BY KEY (a) PARTITIONS 2;
8
INSERT INTO t1 VALUES (1),(1);
9
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
2
11
CREATE TABLE t1 (a INT)
3
12
PARTITION BY HASH (a)
4
13
( PARTITION p0 ENGINE=MyISAM,
190
199
(partition x1 values in (4,6),
191
200
partition x2 values in (5,7));
192
201
ERROR HY000: Only LIST PARTITIONING can use VALUES IN in partition definition
193
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
194
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
202
subpartition by key (b);
203
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
204
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
205
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
213
subpartition by key (a, b);
214
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
215
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
216
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
224
subpartition by hash (a+b);
225
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
226
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
227
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
235
subpartition by key (b);
236
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
237
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
238
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
246
subpartition by key (a, b);
247
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
248
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
249
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
257
subpartition by hash (a+b);
258
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
259
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
260
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
202
select load_file('$MYSQLD_DATADIR/test/t1.par');
203
load_file('$MYSQLD_DATADIR/test/t1.par')
211
subpartition by key (b);
212
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
213
select load_file('$MYSQLD_DATADIR/test/t1.par');
214
load_file('$MYSQLD_DATADIR/test/t1.par')
222
subpartition by key (a, b);
223
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
224
select load_file('$MYSQLD_DATADIR/test/t1.par');
225
load_file('$MYSQLD_DATADIR/test/t1.par')
233
subpartition by hash (a+b);
234
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
235
select load_file('$MYSQLD_DATADIR/test/t1.par');
236
load_file('$MYSQLD_DATADIR/test/t1.par')
244
subpartition by key (b);
245
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
246
select load_file('$MYSQLD_DATADIR/test/t1.par');
247
load_file('$MYSQLD_DATADIR/test/t1.par')
255
subpartition by key (a, b);
256
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
257
select load_file('$MYSQLD_DATADIR/test/t1.par');
258
load_file('$MYSQLD_DATADIR/test/t1.par')
266
subpartition by hash (a+b);
267
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
268
select load_file('$MYSQLD_DATADIR/test/t1.par');
269
load_file('$MYSQLD_DATADIR/test/t1.par')
262
271
CREATE TABLE t1 (
277
286
(partition x1 (subpartition x11, subpartition x12),
278
287
partition x2 (subpartition x21, subpartition x22));
279
288
ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
280
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
281
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
289
select load_file('$MYSQLD_DATADIR/test/t1.par');
290
load_file('$MYSQLD_DATADIR/test/t1.par')
283
292
CREATE TABLE t1 (
302
311
(partition x1 values less than (1) (subpartition x11, subpartition x12),
303
312
partition x2 values less than (2) (subpartition x21, subpartition x22));
304
313
ERROR HY000: Field in list of fields for partition function not found in table
305
select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par');
306
load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par')
314
select load_file('$MYSQLD_DATADIR/test/t1.par');
315
load_file('$MYSQLD_DATADIR/test/t1.par')
308
317
CREATE TABLE t1 (