Debian Codegraph @

mysql-test/suite/ndbcluster/partition_basic.result

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