Debian Codegraph @

mysql-test/suite/ndbcluster/partition_basic.test

raw
1 --source include/have_ndb.inc
2
3 #
4 # Partition by key, basic.
5 #
6 CREATE TABLE t1 (a int, b int, c int, d int, PRIMARY KEY(a,b,c))
7 ENGINE = NDB
8 PARTITION BY KEY (a,b);
9
10 insert into t1 values (1,1,1,1);
11 select * from t1;
12 update t1 set d = 2 where a = 1 and b = 1 and c = 1;
13 select * from t1;
14 delete from t1;
15 select * from t1;
16 drop table t1;
17
18
19 #
20 # Partition by hash, basic.
21 #
22 CREATE TABLE t1 (
23 ol_o_id int NOT NULL,
24 ol_d_id int NOT NULL,
25 ol_w_id int NOT NULL,
26 ol_number int NOT NULL,
27 ol_tmp int,
28 PRIMARY KEY (ol_w_id, ol_d_id, ol_o_id, ol_number)
29 ) ENGINE=NDB
30 PARTITION BY HASH (ol_w_id);
31
32 insert into t1 values (1,0,0,0,0),(1,0,0,1,0),(1,0,0,2,0),(1,1,0,0,0),(1,1,0,1,0);
33 insert into t1 values (2,0,0,0,0),(4,0,0,0,0),(4,0,0,1,0);
34 insert into t1 values (0,1,1,4,0),(0,1,1,5,0); # Only rows affected.
35
36 SELECT * FROM t1 WHERE ol_w_id = 1 AND ol_d_id = 1 AND ol_o_id = 0;
37 SELECT SUM(ol_number) FROM t1 WHERE ol_o_id = 0 AND ol_w_id = 1 AND ol_d_id = 1;
38
39 drop table t1;
40
41
42 #
43 # Partition by list, basic.
44 #
45 CREATE TABLE t1 ( f_int1 INTEGER NOT NULL, f_int2 INTEGER NOT NULL,
46 f_char1 CHAR(10),
47 f_char2 CHAR(10), f_charbig VARCHAR(1000),
48 PRIMARY KEY (f_int1,f_int2))
49 ENGINE = NDB
50 PARTITION BY LIST(MOD(f_int1 + f_int2,4))
51 (PARTITION part_3 VALUES IN (-3),
52 PARTITION part_2 VALUES IN (-2),
53 PARTITION part_1 VALUES IN (-1),
54 PARTITION part0 VALUES IN (0),
55 PARTITION part1 VALUES IN (1),
56 PARTITION part2 VALUES IN (2),
57 PARTITION part3 VALUES IN (3,4,5));
58
59 INSERT INTO t1 SET f_int1 = -2, f_int2 = 20, f_char1 = '20', f_char2 = '20', f_charbig = '===20===';
60 INSERT INTO t1 SET f_int1 = 1, f_int2 = 1, f_char1 = '1', f_char2 = '1', f_charbig = '===1===';
61 INSERT INTO t1 SET f_int1 = 2, f_int2 = 1, f_char1 = '1', f_char2 = '1', f_charbig = '===1===';
62 INSERT INTO t1 SET f_int1 = 3, f_int2 = 1, f_char1 = '1', f_char2 = '1', f_charbig = '===1===';
63 INSERT INTO t1 SET f_int1 = 4, f_int2 = 1, f_char1 = '1', f_char2 = '1', f_charbig = '===1===';
64 INSERT INTO t1 SET f_int1 = 5, f_int2 = 1, f_char1 = '1', f_char2 = '1', f_charbig = '===1===';
65 INSERT INTO t1 SET f_int1 = 20, f_int2 = 1, f_char1 = '1', f_char2 = '1', f_charbig = '===1===';
66
67 SELECT * FROM t1 ORDER BY f_int1;
68 DROP TABLE t1;
69
70 #
71 # Partition by range, basic.
72 #
73 CREATE TABLE t1 (
74 a int not null,
75 b int not null,
76 c int not null,
77 primary key(a,b),
78 index (a))
79 engine = ndb
80 partition by range (a)
81 partitions 3
82 (partition x1 values less than (5),
83 partition x2 values less than (10),
84 partition x3 values less than (20));
85
86 # Simple insert and verify test
87 INSERT into t1 values (1, 1, 1);
88 INSERT into t1 values (6, 1, 1);
89 INSERT into t1 values (10, 1, 1);
90 INSERT into t1 values (15, 1, 1);
91
92 select * from t1 order by a;
93 drop table t1;