| 1 |
CREATE TABLE t1 (a int, b int, c int, PRIMARY KEY(a,b)) |
| 2 |
ENGINE = NDB |
| 3 |
PARTITION BY KEY (a); |
| 4 |
insert into t1 values |
| 5 |
(1,1,3),(1,2,3),(1,3,3),(1,4,3),(1,5,3),(1,6,3), |
| 6 |
(1,7,3),(1,8,3),(1,9,3),(1,10,3),(1,11,3),(1,12,3); |
| 7 |
select * from t1 order by b; |
| 8 |
a b c |
| 9 |
1 1 3 |
| 10 |
1 2 3 |
| 11 |
1 3 3 |
| 12 |
1 4 3 |
| 13 |
1 5 3 |
| 14 |
1 6 3 |
| 15 |
1 7 3 |
| 16 |
1 8 3 |
| 17 |
1 9 3 |
| 18 |
1 10 3 |
| 19 |
1 11 3 |
| 20 |
1 12 3 |
| 21 |
Checking MAX_ROWS is unchanged |
| 22 |
drop table t1; |
| 23 |
Checking MAX_ROWS is unchanged |
| 24 |
select * from t1 order by b; |
| 25 |
a b c |
| 26 |
1 1 3 |
| 27 |
1 2 3 |
| 28 |
1 3 3 |
| 29 |
1 4 3 |
| 30 |
1 5 3 |
| 31 |
1 6 3 |
| 32 |
1 7 3 |
| 33 |
1 8 3 |
| 34 |
1 9 3 |
| 35 |
1 10 3 |
| 36 |
1 11 3 |
| 37 |
1 12 3 |
| 38 |
ALTER TABLE t1 algorithm=inplace, REORGANIZE PARTITION; |
| 39 |
DROP TABLE t1; |