1
-- source include/have_partition.inc
3
DROP TABLE IF EXISTS t1;
7
--echo # Bug#13357766: ASSERT IN HANDLER::HA_CREATE
11
PARTITION BY KEY(a) PARTITIONS 3;
12
ALTER TABLE t1 REPAIR PARTITION p2,p3,p1;
13
ALTER TABLE t1 ORDER BY a;
17
--echo # Bug#11764110/bug#56909: REORGANIZE PARTITION is allowed on
18
--echo # HASH/KEY partitioned tables
20
CREATE TABLE t1 (a INT PRIMARY KEY)
24
INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11);
25
INSERT INTO t1 VALUES (12), (13), (14), (15), (16), (17), (18), (19), (20);
26
--echo # This changes from auto partitioned to manual partitioned
27
ALTER TABLE t1 REORGANIZE PARTITION p0 INTO (PARTITION pHidden);
29
ALTER TABLE t1 ADD PARTITION PARTITIONS 1;
30
ALTER TABLE t1 ADD PARTITION
32
ALTER TABLE t1 ADD PARTITION
34
ALTER TABLE t1 ADD PARTITION
36
--error ER_SAME_NAME_PARTITION
37
ALTER TABLE t1 ADD PARTITION PARTITIONS 1;
39
ALTER TABLE t1 REBUILD PARTITION all;
40
ALTER TABLE t1 REBUILD PARTITION pNamed1,p5;
41
ALTER TABLE t1 COALESCE PARTITION 1;
42
ALTER TABLE t1 COALESCE PARTITION 2;
47
# Bug 40389: REORGANIZE PARTITION crashes when only using one partition
49
CREATE TABLE t1 (a INT PRIMARY KEY)
53
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
54
ALTER TABLE t1 REORGANIZE PARTITION;
58
# Bug 21143: mysqld hang when error in number of subparts in
61
create table t1 (a int)
62
partition by range (a)
63
subpartition by key (a)
64
(partition p0 values less than (10) (subpartition sp00, subpartition sp01),
65
partition p1 values less than (20) (subpartition sp10, subpartition sp11));
67
-- error ER_PARTITION_WRONG_NO_SUBPART_ERROR
68
alter table t1 reorganize partition p0 into
69
(partition p0 values less than (10) (subpartition sp00,
70
subpartition sp01, subpartition sp02));
73
CREATE TABLE t1 (f_date DATE, f_varchar VARCHAR(30))
74
PARTITION BY HASH(YEAR(f_date)) PARTITIONS 2;
76
let $MYSQLD_DATADIR= `select @@datadir`;
77
-- file_exists $MYSQLD_DATADIR/test/t1#P#p0.MYD
78
-- file_exists $MYSQLD_DATADIR/test/t1#P#p0.MYI
79
-- file_exists $MYSQLD_DATADIR/test/t1#P#p1.MYD
80
-- file_exists $MYSQLD_DATADIR/test/t1#P#p1.MYI
81
-- file_exists $MYSQLD_DATADIR/test/t1.frm
82
-- file_exists $MYSQLD_DATADIR/test/t1.par
83
ALTER TABLE t1 COALESCE PARTITION 1;
85
-- file_exists $MYSQLD_DATADIR/test/t1#P#p0.MYD
86
-- file_exists $MYSQLD_DATADIR/test/t1#P#p0.MYI
87
-- file_exists $MYSQLD_DATADIR/test/t1.frm
88
-- file_exists $MYSQLD_DATADIR/test/t1.par
91
# Bug 20767: REORGANIZE partition crashes
93
create table t1 (a int)
95
subpartition by hash (a)
96
(partition p11 values in (1,2),
97
partition p12 values in (3,4));
99
alter table t1 REORGANIZE partition p11, p12 INTO
100
(partition p1 values in (1,2,3,4));
102
alter table t1 REORGANIZE partition p1 INTO
103
(partition p11 values in (1,2),
104
partition p12 values in (3,4));
108
# Verification tests for bug#14326
110
CREATE TABLE t1 (a INT)
111
/*!50100 PARTITION BY HASH (a)
116
SHOW CREATE TABLE t1;
118
CREATE TABLE t1 (a INT)
119
/*!50100 PARTITION BY HASH (a)
120
-- with a single line comment embedded
122
SHOW CREATE TABLE t1;
124
CREATE TABLE t1 (a INT)
125
/*!50100 PARTITION BY HASH (a)
127
SHOW CREATE TABLE t1;
129
CREATE TABLE t1 (a INT) /*!50100 PARTITION BY HASH (a) PARTITIONS 5 */;
130
SHOW CREATE TABLE t1;