Debian Codegraph @

mysql-test/suite/ndb/r/ndb_bug22904640.result

raw
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;