Debian Codegraph @

mysql-test/suite/ndbcluster/information_schema_partitions.result

raw
1 CREATE TABLE t1_rp_by_ldm
2 (a bigint, b bigint, c bigint, d bigint,
3 PRIMARY KEY (a,b,c,d))
4 ENGINE = NDB
5 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
6
7 Expected number of partitions with "FOR_RP_BY_LDM" = 8
8
9 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
10 FROM INFORMATION_SCHEMA.PARTITIONS
11 WHERE table_schema = 'test' AND table_name = 't1_rp_by_ldm'
12 ORDER BY PARTITION_ORDINAL_POSITION;
13 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
14 t1_rp_by_ldm p0 1 AUTO default
15 t1_rp_by_ldm p1 2 AUTO default
16 t1_rp_by_ldm p2 3 AUTO default
17 t1_rp_by_ldm p3 4 AUTO default
18 t1_rp_by_ldm p4 5 AUTO default
19 t1_rp_by_ldm p5 6 AUTO default
20 t1_rp_by_ldm p6 7 AUTO default
21 t1_rp_by_ldm p7 8 AUTO default
22 DROP TABLE t1_rp_by_ldm;
23 CREATE TABLE t1_rp_by_node
24 (a bigint, b bigint, c bigint, d bigint,
25 PRIMARY KEY (a,b,c,d))
26 ENGINE = NDB
27 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
28
29 Expected number of partitions with "FOR_RP_BY_NODE"= 2
30
31 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
32 FROM INFORMATION_SCHEMA.PARTITIONS
33 WHERE table_schema = 'test' AND table_name = 't1_rp_by_node'
34 ORDER BY PARTITION_ORDINAL_POSITION;
35 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
36 t1_rp_by_node p0 1 AUTO default
37 t1_rp_by_node p1 2 AUTO default
38 DROP TABLE t1_rp_by_node;
39 CREATE TABLE t1_ra_by_node
40 (a bigint, b bigint, c bigint, d bigint,
41 PRIMARY KEY (a,b,c,d))
42 ENGINE = NDB
43 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
44
45 Expected number of partitions with "FOR_RA_BY_NODE"= 1
46
47 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
48 FROM INFORMATION_SCHEMA.PARTITIONS
49 WHERE table_schema = 'test' AND table_name = 't1_ra_by_node'
50 ORDER BY PARTITION_ORDINAL_POSITION;
51 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
52 t1_ra_by_node p0 1 AUTO default
53 DROP TABLE t1_ra_by_node;
54 CREATE TABLE t1_ra_by_ldm
55 (a bigint, b bigint, c bigint, d bigint,
56 PRIMARY KEY (a,b,c,d))
57 ENGINE = NDB
58 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM_X_3";
59
60 Expected number of partitions with "FOR_RA_BY_LDM_X_3" = 12
61
62 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
63 FROM INFORMATION_SCHEMA.PARTITIONS
64 WHERE table_schema = 'test' AND table_name = 't1_ra_by_ldm'
65 ORDER BY PARTITION_ORDINAL_POSITION;
66 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
67 t1_ra_by_ldm p0 1 AUTO default
68 t1_ra_by_ldm p1 2 AUTO default
69 t1_ra_by_ldm p2 3 AUTO default
70 t1_ra_by_ldm p3 4 AUTO default
71 t1_ra_by_ldm p4 5 AUTO default
72 t1_ra_by_ldm p5 6 AUTO default
73 t1_ra_by_ldm p6 7 AUTO default
74 t1_ra_by_ldm p7 8 AUTO default
75 t1_ra_by_ldm p8 9 AUTO default
76 t1_ra_by_ldm p9 10 AUTO default
77 t1_ra_by_ldm p10 11 AUTO default
78 t1_ra_by_ldm p11 12 AUTO default
79 ALTER TABLE t1_ra_by_ldm
80 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM_X_2";
81
82 Expected number of partitions with "FOR_RA_BY_LDM_X_2" = 8
83
84 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
85 FROM INFORMATION_SCHEMA.PARTITIONS
86 WHERE table_schema = 'test' AND table_name = 't1_ra_by_ldm'
87 ORDER BY PARTITION_ORDINAL_POSITION;
88 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
89 t1_ra_by_ldm p0 1 AUTO default
90 t1_ra_by_ldm p1 2 AUTO default
91 t1_ra_by_ldm p2 3 AUTO default
92 t1_ra_by_ldm p3 4 AUTO default
93 t1_ra_by_ldm p4 5 AUTO default
94 t1_ra_by_ldm p5 6 AUTO default
95 t1_ra_by_ldm p6 7 AUTO default
96 t1_ra_by_ldm p7 8 AUTO default
97 ALTER TABLE t1_ra_by_ldm
98 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
99
100 Expected number of partitions with "FOR_RA_BY_LDM" = 4
101
102 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
103 FROM INFORMATION_SCHEMA.PARTITIONS
104 WHERE table_schema = 'test' AND table_name = 't1_ra_by_ldm'
105 ORDER BY PARTITION_ORDINAL_POSITION;
106 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
107 t1_ra_by_ldm p0 1 AUTO default
108 t1_ra_by_ldm p1 2 AUTO default
109 t1_ra_by_ldm p2 3 AUTO default
110 t1_ra_by_ldm p3 4 AUTO default
111 ALTER TABLE t1_ra_by_ldm
112 COMMENT = "NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM_X_4";
113
114 Expected number of partitions with "FOR_RA_BY_LDM_X_4" = 16
115
116 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
117 FROM INFORMATION_SCHEMA.PARTITIONS
118 WHERE table_schema = 'test' AND table_name = 't1_ra_by_ldm'
119 ORDER BY PARTITION_ORDINAL_POSITION;
120 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
121 t1_ra_by_ldm p0 1 AUTO default
122 t1_ra_by_ldm p1 2 AUTO default
123 t1_ra_by_ldm p2 3 AUTO default
124 t1_ra_by_ldm p3 4 AUTO default
125 t1_ra_by_ldm p4 5 AUTO default
126 t1_ra_by_ldm p5 6 AUTO default
127 t1_ra_by_ldm p6 7 AUTO default
128 t1_ra_by_ldm p7 8 AUTO default
129 t1_ra_by_ldm p8 9 AUTO default
130 t1_ra_by_ldm p9 10 AUTO default
131 t1_ra_by_ldm p10 11 AUTO default
132 t1_ra_by_ldm p11 12 AUTO default
133 t1_ra_by_ldm p12 13 AUTO default
134 t1_ra_by_ldm p13 14 AUTO default
135 t1_ra_by_ldm p14 15 AUTO default
136 t1_ra_by_ldm p15 16 AUTO default
137 DROP TABLE t1_ra_by_ldm;
138 CREATE TABLE t1_fully_replicated (
139 a char(10) NOT NULL PRIMARY KEY,
140 b int NOT NULL,
141 UNIQUE(a,b),
142 KEY(b, a))
143 ENGINE = NDB
144 COMMENT = 'NDB_TABLE=FULLY_REPLICATED=1';
145
146 Expected number of partitions with "FULLY_REPLICATED" = 8
147
148 SELECT TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, PARTITION_METHOD, NODEGROUP
149 FROM INFORMATION_SCHEMA.PARTITIONS
150 WHERE table_schema = 'test' AND table_name = 't1_fully_replicated'
151 ORDER BY PARTITION_ORDINAL_POSITION;
152 TABLE_NAME PARTITION_NAME PARTITION_ORDINAL_POSITION PARTITION_METHOD NODEGROUP
153 t1_fully_replicated p0 1 AUTO default
154 t1_fully_replicated p1 2 AUTO default
155 t1_fully_replicated p2 3 AUTO default
156 t1_fully_replicated p3 4 AUTO default
157 t1_fully_replicated p4 5 AUTO default
158 t1_fully_replicated p5 6 AUTO default
159 t1_fully_replicated p6 7 AUTO default
160 t1_fully_replicated p7 8 AUTO default
161 DROP TABLE t1_fully_replicated;
162 #
163 # Bug#33643512 Missing check for Thd_ndb in information_schema.partitions
164 # - Run I_S.partition query on new connection
165 #
166 CREATE TABLE t1 (a int primary key) engine = NDB;
167 DROP TABLE t1;