| 1 |
set new=on; |
| 2 |
Warnings: |
| 3 |
Warning 1287 '@@new' is deprecated and will be removed in a future release. |
| 4 |
CREATE TABLE `t1_c` ( |
| 5 |
`capgoaledatta` smallint(5) unsigned NOT NULL auto_increment, |
| 6 |
`goaledatta` char(2) NOT NULL default '', |
| 7 |
`maturegarbagefa` varchar(32) NOT NULL default '', |
| 8 |
PRIMARY KEY (`capgoaledatta`,`goaledatta`,`maturegarbagefa`) |
| 9 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 10 |
Warnings: |
| 11 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 12 |
INSERT INTO `t1_c` VALUES (2,'3','q3plus.qt'),(4,'4','q3plus.qt'),(1,'3','q3.net'),(3,'4','q3.net'),(3,'20','threetrees.qt'); |
| 13 |
CREATE TABLE `t2_c` ( |
| 14 |
`capgotod` smallint(5) unsigned NOT NULL auto_increment, |
| 15 |
`gotod` smallint(5) unsigned NOT NULL default '0', |
| 16 |
`goaledatta` char(2) default NULL, |
| 17 |
`maturegarbagefa` varchar(32) default NULL, |
| 18 |
`descrpooppo` varchar(64) default NULL, |
| 19 |
`svcutonsa` varchar(64) NOT NULL default '', |
| 20 |
PRIMARY KEY (`capgotod`), |
| 21 |
KEY `i_quadaddsvr` (`gotod`) |
| 22 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 23 |
Warnings: |
| 24 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 25 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 26 |
INSERT INTO `t2_c` VALUES (5,4,'','q3.net','addavp:MK_CASELECTOR=1','postorod rattoaa'),(2,1,'4','','addavp:MK_BRANDTAD=345','REDS Brandtad'),(3,2,'4','q3.net','execorder','fixedRatediPO REDS'),(1,1,'3','','addavp:MK_BRANDTAD=123','TEST Brandtad'),(6,5,'','told.q3.net','addavp:MK_BRANDTAD=123','Brandtad Toldzone'),(4,3,'3','q3.net','addavp:MK_POOLHINT=2','ratedi PO TEST'); |
| 27 |
CREATE TABLE `t3_c` ( |
| 28 |
`CapGoaledatta` smallint(5) unsigned NOT NULL default '0', |
| 29 |
`capgotod` smallint(5) unsigned NOT NULL default '0', |
| 30 |
PRIMARY KEY (`capgotod`,`CapGoaledatta`) |
| 31 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 32 |
Warnings: |
| 33 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 34 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 35 |
INSERT INTO `t3_c` VALUES (5,3),(2,4),(5,4),(1,3); |
| 36 |
CREATE TABLE `t4_c` ( |
| 37 |
`capfa` bigint(20) unsigned NOT NULL auto_increment, |
| 38 |
`realm` varchar(32) NOT NULL default '', |
| 39 |
`authpwchap` varchar(32) default NULL, |
| 40 |
`fa` varchar(32) NOT NULL default '', |
| 41 |
`payyingatta` tinyint(4) NOT NULL default '0', |
| 42 |
`status` char(1) default NULL, |
| 43 |
PRIMARY KEY (`fa`,`realm`), |
| 44 |
KEY `capfa` (`capfa`), |
| 45 |
KEY `i_quadentity` (`fa`,`realm`) |
| 46 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 47 |
Warnings: |
| 48 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 49 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 50 |
INSERT INTO `t4_c` VALUES (18,'john.smith','q3.net','dessjohn.smith',0,NULL),(21,'quad_katt_with_brandtad','q3.net','acne',0,NULL),(22,'quad_katt_carattoaa','q3.net','acne',0,NULL),(26,'436462612809','sqasdt.q3.net','N/A',0,'6'),(19,'john','smith.qt','dessjohn',0,NULL),(33,'436643196120','sqasdt.q3.net','N/A',1,'6'),(28,'436642900019','sqasdt.q3.net','N/A',0,'6'),(30,'436462900209','sqasdt.q3.net','N/A',0,'6'),(16,'436640006666','sqasdt.q3.net','',0,NULL),(19,'dette','el-redun.com','dessdette',0,NULL),(12,'quad_kattPP','q3.net','acne',2,NULL),(14,'436640008888','sqasdt.q3.net','',0,NULL),(29,'463624900028','sqasdt.q3.net','N/A',0,'6'),(15,'436640099099','sqasdt.q3.net','',0,NULL),(13,'pap','q3plus.qt','acne',1,NULL),(19,'436642612091','sqasdt.q3.net','N/A',0,'6'),(12,'quad_katt','q3.net','acne',0,NULL),(11,'quad_kattVK','q3.net','acne',1,NULL),(32,'463641969502','sqasdt.q3.net','N/A',1,'6'),(20,'joe','q3.net','joedesswd',0,NULL),(29,'436642900034','sqasdt.q3.net','N/A',0,'6'),(25,'contind','armerde.qt','acne',1,NULL); |
| 51 |
CREATE TABLE `t5_c` ( |
| 52 |
`capfa` bigint(20) unsigned NOT NULL default '0', |
| 53 |
`gotod` smallint(5) unsigned NOT NULL default '0', |
| 54 |
`orderutonsa` varchar(64) NOT NULL default '', |
| 55 |
PRIMARY KEY (`capfa`,`gotod`,`orderutonsa`) |
| 56 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 57 |
Warnings: |
| 58 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 59 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 60 |
INSERT INTO `t5_c` VALUES (21,2,''),(21,1,''),(22,4,''); |
| 61 |
CREATE TABLE `t6_c` ( |
| 62 |
`capfa_parent` bigint(20) unsigned NOT NULL default '0', |
| 63 |
`capfa_child` bigint(20) unsigned NOT NULL default '0', |
| 64 |
`relatta` smallint(5) unsigned NOT NULL default '0', |
| 65 |
PRIMARY KEY (`capfa_child`,`capfa_parent`,`relatta`) |
| 66 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 67 |
Warnings: |
| 68 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 69 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 70 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 71 |
INSERT INTO `t6_c` VALUES (15,16,0),(19,20,0),(18326932092909551615,30,0),(26,29,0),(18326932092909551615,29,0),(19,18,0),(26,28,0),(12,14,0); |
| 72 |
CREATE TABLE `t7_c` ( |
| 73 |
`dardpo` char(15) NOT NULL default '', |
| 74 |
`dardtestard` tinyint(3) unsigned NOT NULL default '0', |
| 75 |
`FastFA` char(5) NOT NULL default '', |
| 76 |
`FastCode` char(6) NOT NULL default '', |
| 77 |
`Fastca` char(1) NOT NULL default '', |
| 78 |
`Fastmag` char(1) NOT NULL default '', |
| 79 |
`Beareratta` char(2) NOT NULL default '', |
| 80 |
PRIMARY KEY (`dardpo`,`dardtestard`) |
| 81 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 82 |
Warnings: |
| 83 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 84 |
INSERT INTO `t7_c` VALUES ('2.6.2.4',24,'CECHP','54545','0','0','5'),('2.2.5.4',26,'CANFA','33223','1','1','4'),('4.3.2.4',28,'ITALD','54222','1','0','5'),('129..0.0.eins',28,'G','99999','1','1','5'),('1.1.1.1',24,'AUTPT','32323','0','1','3'); |
| 85 |
CREATE TABLE `t8_c` ( |
| 86 |
`kattjame` varchar(32) NOT NULL default '', |
| 87 |
`realm` varchar(32) NOT NULL default '', |
| 88 |
`realm_entered` varchar(32) NOT NULL default '', |
| 89 |
`maturegarbagefa` varchar(32) NOT NULL default '', |
| 90 |
`hunderaaarbagefa_parent` varchar(32) NOT NULL default '', |
| 91 |
`kattjame_entered` varchar(32) NOT NULL default '', |
| 92 |
`hunderaaarbagefa` varchar(32) NOT NULL default '', |
| 93 |
`gest` varchar(16) default NULL, |
| 94 |
`hassetino` varchar(16) NOT NULL default '', |
| 95 |
`aaaproxysessfa` varchar(255) default NULL, |
| 96 |
`autologonallowed` char(1) default NULL, |
| 97 |
`squardporoot` varchar(15) NOT NULL default '', |
| 98 |
`naspo` varchar(15) default NULL, |
| 99 |
`beareratta` char(2) default NULL, |
| 100 |
`fastCode` varchar(6) default NULL, |
| 101 |
`fastFA` varchar(5) default NULL, |
| 102 |
`fastca` char(1) default NULL, |
| 103 |
`fastmag` char(1) default NULL, |
| 104 |
`lastupdate` datetime default NULL, |
| 105 |
`hassetistart` datetime NOT NULL, |
| 106 |
`accthassetitime` int(10) unsigned default NULL, |
| 107 |
`acctoutputoctets` bigint(20) unsigned default NULL, |
| 108 |
`acctinputoctets` bigint(20) unsigned default NULL, |
| 109 |
PRIMARY KEY (`kattjame`,`hunderaaarbagefa`,`hassetistart`,`hassetino`), |
| 110 |
KEY `squardporoot` (`squardporoot`) |
| 111 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 112 |
Warnings: |
| 113 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 114 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 115 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 116 |
INSERT INTO `t8_c` VALUES ('4tt45345235','pap','q3plus.qt','q3plus.qt','q3.net','436643196120','436643196929','8956234534568968','5524595699','uxasmt21.net.acne.qt/481889229462692422','','1.1.1.1','2.2.4.6','4','86989','34','x','x','2012-03-12 12:55:34','2012-12-05 11:20:04',3223433,3369,9565),('4545435545','john','q3.net','q3.net','acne.li','436643196120','436643196929','45345234568968','995696699','uxasmt21.net.acne.qt/481889229462692423','','1.1.1.1','2.2.9.8','2','86989','34','x','x','2012-03-12 11:35:03','2012-12-05 08:50:04',8821923,169,3565),('versteckter_q3net_katt','joe','q3.net','elredun.com','q3.net','436643196120','436643196939','91341234568968','695595699','uxasmt21.net.acne.qt/481889229462692421','','1.1.1.1','2.5.2.5','3','86989','34','x','x','2012-03-12 18:35:04','2012-12-05 12:35:04',1923123,9569,6565); |
| 117 |
CREATE TABLE `t9_c` ( |
| 118 |
`kattjame` varchar(32) NOT NULL default '', |
| 119 |
`kattjame_entered` varchar(32) NOT NULL default '', |
| 120 |
`realm` varchar(32) NOT NULL default '', |
| 121 |
`realm_entered` varchar(32) NOT NULL default '', |
| 122 |
`maturegarbagefa` varchar(32) NOT NULL default '', |
| 123 |
`hunderaaarbagefa` varchar(32) NOT NULL default '', |
| 124 |
`hunderaaarbagefa_parent` varchar(32) NOT NULL default '', |
| 125 |
`gest` varchar(16) default NULL, |
| 126 |
`hassetino` varchar(16) NOT NULL default '', |
| 127 |
`squardporoot` varchar(15) NOT NULL default '', |
| 128 |
`naspo` varchar(15) default NULL, |
| 129 |
`beareratta` char(2) default NULL, |
| 130 |
`fastCode` varchar(6) default NULL, |
| 131 |
`fastFA` varchar(5) default NULL, |
| 132 |
`fastca` char(1) default NULL, |
| 133 |
`fastmag` char(1) default NULL, |
| 134 |
`lastupdate` datetime default NULL, |
| 135 |
`hassetistart` datetime NOT NULL, |
| 136 |
`accthassetitime` int(10) unsigned default NULL, |
| 137 |
`actcoutpuocttets` bigint(20) unsigned default NULL, |
| 138 |
`actinputocctets` bigint(20) unsigned default NULL, |
| 139 |
`terminateraste` tinyint(3) unsigned default NULL, |
| 140 |
PRIMARY KEY (`kattjame`,`hunderaaarbagefa`,`hassetistart`,`hassetino`) |
| 141 |
) ENGINE=ndbcluster DEFAULT CHARSET=latin1; |
| 142 |
Warnings: |
| 143 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 144 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 145 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 146 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 147 |
INSERT INTO `t9_c` VALUES ('3g4jh8gar2t','joe','q3.net','elredun.com','q3.net','436643316120','436643316939','91341234568968','695595699','1.1.1.1','2.2.6.2','3','86989','34','x','x','2012-03-12 18:35:04','2012-12-05 12:35:04',3123123,9569,6565,1),('4tt45345235','pap','q3plus.qt','q3plus.qt','q3.net','436643316120','436643316939','8956234534568968','5254595969','1.1.1.1','8.6.2.2','4','86989','34','x','x','2012-03-12 12:55:34','2012-12-05 11:20:04',3223433,3369,9565,2),('4545435545','john','q3.net','q3.net','acne.li','436643316120','436643316939','45345234568968','995696699','1.1.1.1','2.9.9.2','2','86998','34','x','x','2012-03-12 11:35:03','2012-12-05 08:50:04',8823123,169,3565,3); |
| 148 |
create table t1 engine=myisam as select * from t1_c; |
| 149 |
create table t2 engine=myisam as select * from t2_c; |
| 150 |
create table t3 engine=myisam as select * from t3_c; |
| 151 |
create table t4 engine=myisam as select * from t4_c; |
| 152 |
create table t5 engine=myisam as select * from t5_c; |
| 153 |
create table t6 engine=myisam as select * from t6_c; |
| 154 |
create table t7 engine=myisam as select * from t7_c; |
| 155 |
create table t8 engine=myisam as select * from t8_c; |
| 156 |
create table t9 engine=myisam as select * from t9_c; |
| 157 |
drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; |
| 158 |
select count(*) from t1; |
| 159 |
count(*) |
| 160 |
5 |
| 161 |
select count(*) from t1_c; |
| 162 |
count(*) |
| 163 |
5 |
| 164 |
select count(*) |
| 165 |
from (select * from t1 union |
| 166 |
select * from t1_c) a; |
| 167 |
count(*) |
| 168 |
5 |
| 169 |
select count(*) from t2; |
| 170 |
count(*) |
| 171 |
6 |
| 172 |
select count(*) from t2_c; |
| 173 |
count(*) |
| 174 |
6 |
| 175 |
select count(*) |
| 176 |
from (select * from t2 union |
| 177 |
select * from t2_c) a; |
| 178 |
count(*) |
| 179 |
6 |
| 180 |
select count(*) from t3; |
| 181 |
count(*) |
| 182 |
4 |
| 183 |
select count(*) from t3_c; |
| 184 |
count(*) |
| 185 |
4 |
| 186 |
select count(*) |
| 187 |
from (select * from t3 union |
| 188 |
select * from t3_c) a; |
| 189 |
count(*) |
| 190 |
4 |
| 191 |
select count(*) from t4; |
| 192 |
count(*) |
| 193 |
22 |
| 194 |
select count(*) from t4_c; |
| 195 |
count(*) |
| 196 |
22 |
| 197 |
select count(*) |
| 198 |
from (select * from t4 union |
| 199 |
select * from t4_c) a; |
| 200 |
count(*) |
| 201 |
22 |
| 202 |
select count(*) from t5; |
| 203 |
count(*) |
| 204 |
3 |
| 205 |
select count(*) from t5_c; |
| 206 |
count(*) |
| 207 |
3 |
| 208 |
select count(*) |
| 209 |
from (select * from t5 union |
| 210 |
select * from t5_c) a; |
| 211 |
count(*) |
| 212 |
3 |
| 213 |
select count(*) from t6; |
| 214 |
count(*) |
| 215 |
8 |
| 216 |
select count(*) from t6_c; |
| 217 |
count(*) |
| 218 |
8 |
| 219 |
select count(*) |
| 220 |
from (select * from t6 union |
| 221 |
select * from t6_c) a; |
| 222 |
count(*) |
| 223 |
8 |
| 224 |
select count(*) from t7; |
| 225 |
count(*) |
| 226 |
5 |
| 227 |
select count(*) from t7_c; |
| 228 |
count(*) |
| 229 |
5 |
| 230 |
select count(*) |
| 231 |
from (select * from t7 union |
| 232 |
select * from t7_c) a; |
| 233 |
count(*) |
| 234 |
5 |
| 235 |
select count(*) from t8; |
| 236 |
count(*) |
| 237 |
3 |
| 238 |
select count(*) from t8_c; |
| 239 |
count(*) |
| 240 |
3 |
| 241 |
select count(*) |
| 242 |
from (select * from t8 union |
| 243 |
select * from t8_c) a; |
| 244 |
count(*) |
| 245 |
3 |
| 246 |
select count(*) from t9; |
| 247 |
count(*) |
| 248 |
3 |
| 249 |
select count(*) from t9_c; |
| 250 |
count(*) |
| 251 |
3 |
| 252 |
select count(*) |
| 253 |
from (select * from t9 union |
| 254 |
select * from t9_c) a; |
| 255 |
count(*) |
| 256 |
3 |
| 257 |
ALTER TABLE t1_c |
| 258 |
PARTITION BY RANGE (`capgoaledatta`) |
| 259 |
(PARTITION p0 VALUES LESS THAN MAXVALUE); |
| 260 |
ALTER TABLE t2_c |
| 261 |
PARTITION BY LIST(`capgotod`) |
| 262 |
(PARTITION p0 VALUES IN (0,1,2,3,4,5,6)); |
| 263 |
ALTER TABLE t3_c |
| 264 |
PARTITION BY HASH (`CapGoaledatta`); |
| 265 |
ALTER TABLE t5_c |
| 266 |
PARTITION BY HASH (`capfa`) |
| 267 |
PARTITIONS 4; |
| 268 |
ALTER TABLE t6_c |
| 269 |
PARTITION BY LINEAR HASH (`relatta`) |
| 270 |
PARTITIONS 4; |
| 271 |
ALTER TABLE t7_c |
| 272 |
PARTITION BY LINEAR KEY (`dardtestard`); |
| 273 |
drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; |
| 274 |
select count(*) from t1; |
| 275 |
count(*) |
| 276 |
5 |
| 277 |
select count(*) from t1_c; |
| 278 |
count(*) |
| 279 |
5 |
| 280 |
select count(*) |
| 281 |
from (select * from t1 union |
| 282 |
select * from t1_c) a; |
| 283 |
count(*) |
| 284 |
5 |
| 285 |
select count(*) from t2; |
| 286 |
count(*) |
| 287 |
6 |
| 288 |
select count(*) from t2_c; |
| 289 |
count(*) |
| 290 |
6 |
| 291 |
select count(*) |
| 292 |
from (select * from t2 union |
| 293 |
select * from t2_c) a; |
| 294 |
count(*) |
| 295 |
6 |
| 296 |
select count(*) from t3; |
| 297 |
count(*) |
| 298 |
4 |
| 299 |
select count(*) from t3_c; |
| 300 |
count(*) |
| 301 |
4 |
| 302 |
select count(*) |
| 303 |
from (select * from t3 union |
| 304 |
select * from t3_c) a; |
| 305 |
count(*) |
| 306 |
4 |
| 307 |
select count(*) from t4; |
| 308 |
count(*) |
| 309 |
22 |
| 310 |
select count(*) from t4_c; |
| 311 |
count(*) |
| 312 |
22 |
| 313 |
select count(*) |
| 314 |
from (select * from t4 union |
| 315 |
select * from t4_c) a; |
| 316 |
count(*) |
| 317 |
22 |
| 318 |
select count(*) from t5; |
| 319 |
count(*) |
| 320 |
3 |
| 321 |
select count(*) from t5_c; |
| 322 |
count(*) |
| 323 |
3 |
| 324 |
select count(*) |
| 325 |
from (select * from t5 union |
| 326 |
select * from t5_c) a; |
| 327 |
count(*) |
| 328 |
3 |
| 329 |
select count(*) from t6; |
| 330 |
count(*) |
| 331 |
8 |
| 332 |
select count(*) from t6_c; |
| 333 |
count(*) |
| 334 |
8 |
| 335 |
select count(*) |
| 336 |
from (select * from t6 union |
| 337 |
select * from t6_c) a; |
| 338 |
count(*) |
| 339 |
8 |
| 340 |
select count(*) from t7; |
| 341 |
count(*) |
| 342 |
5 |
| 343 |
select count(*) from t7_c; |
| 344 |
count(*) |
| 345 |
5 |
| 346 |
select count(*) |
| 347 |
from (select * from t7 union |
| 348 |
select * from t7_c) a; |
| 349 |
count(*) |
| 350 |
5 |
| 351 |
select count(*) from t8; |
| 352 |
count(*) |
| 353 |
3 |
| 354 |
select count(*) from t8_c; |
| 355 |
count(*) |
| 356 |
3 |
| 357 |
select count(*) |
| 358 |
from (select * from t8 union |
| 359 |
select * from t8_c) a; |
| 360 |
count(*) |
| 361 |
3 |
| 362 |
select count(*) from t9; |
| 363 |
count(*) |
| 364 |
3 |
| 365 |
select count(*) from t9_c; |
| 366 |
count(*) |
| 367 |
3 |
| 368 |
select count(*) |
| 369 |
from (select * from t9 union |
| 370 |
select * from t9_c) a; |
| 371 |
count(*) |
| 372 |
3 |
| 373 |
drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; |
| 374 |
select count(*) from t1; |
| 375 |
count(*) |
| 376 |
5 |
| 377 |
select count(*) from t1_c; |
| 378 |
count(*) |
| 379 |
5 |
| 380 |
select count(*) |
| 381 |
from (select * from t1 union |
| 382 |
select * from t1_c) a; |
| 383 |
count(*) |
| 384 |
5 |
| 385 |
select count(*) from t2; |
| 386 |
count(*) |
| 387 |
6 |
| 388 |
select count(*) from t2_c; |
| 389 |
count(*) |
| 390 |
6 |
| 391 |
select count(*) |
| 392 |
from (select * from t2 union |
| 393 |
select * from t2_c) a; |
| 394 |
count(*) |
| 395 |
6 |
| 396 |
select count(*) from t3; |
| 397 |
count(*) |
| 398 |
4 |
| 399 |
select count(*) from t3_c; |
| 400 |
count(*) |
| 401 |
4 |
| 402 |
select count(*) |
| 403 |
from (select * from t3 union |
| 404 |
select * from t3_c) a; |
| 405 |
count(*) |
| 406 |
4 |
| 407 |
select count(*) from t4; |
| 408 |
count(*) |
| 409 |
22 |
| 410 |
select count(*) from t4_c; |
| 411 |
count(*) |
| 412 |
22 |
| 413 |
select count(*) |
| 414 |
from (select * from t4 union |
| 415 |
select * from t4_c) a; |
| 416 |
count(*) |
| 417 |
22 |
| 418 |
select count(*) from t5; |
| 419 |
count(*) |
| 420 |
3 |
| 421 |
select count(*) from t5_c; |
| 422 |
count(*) |
| 423 |
3 |
| 424 |
select count(*) |
| 425 |
from (select * from t5 union |
| 426 |
select * from t5_c) a; |
| 427 |
count(*) |
| 428 |
3 |
| 429 |
select count(*) from t6; |
| 430 |
count(*) |
| 431 |
8 |
| 432 |
select count(*) from t6_c; |
| 433 |
count(*) |
| 434 |
8 |
| 435 |
select count(*) |
| 436 |
from (select * from t6 union |
| 437 |
select * from t6_c) a; |
| 438 |
count(*) |
| 439 |
8 |
| 440 |
select count(*) from t7; |
| 441 |
count(*) |
| 442 |
5 |
| 443 |
select count(*) from t7_c; |
| 444 |
count(*) |
| 445 |
5 |
| 446 |
select count(*) |
| 447 |
from (select * from t7 union |
| 448 |
select * from t7_c) a; |
| 449 |
count(*) |
| 450 |
5 |
| 451 |
select count(*) from t8; |
| 452 |
count(*) |
| 453 |
3 |
| 454 |
select count(*) from t8_c; |
| 455 |
count(*) |
| 456 |
3 |
| 457 |
select count(*) |
| 458 |
from (select * from t8 union |
| 459 |
select * from t8_c) a; |
| 460 |
count(*) |
| 461 |
3 |
| 462 |
select count(*) from t9; |
| 463 |
count(*) |
| 464 |
3 |
| 465 |
select count(*) from t9_c; |
| 466 |
count(*) |
| 467 |
3 |
| 468 |
select count(*) |
| 469 |
from (select * from t9 union |
| 470 |
select * from t9_c) a; |
| 471 |
count(*) |
| 472 |
3 |
| 473 |
drop table t1_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; |
| 474 |
NOTE! Support for --ndb-nodegroup-map=<string> has been removed |
| 475 |
XXXX-XX-XX XX:XX:XX ERROR: Create table `test/def/t2_c` failed: 721: Schema object with given name already exists |
| 476 |
XXXX-XX-XX XX:XX:XX ERROR: Restore: Failed to restore table: `test/def/t2_c` ... Exiting |
| 477 |
drop table t2_c; |
| 478 |
drop table t1,t2,t3,t4,t5,t6,t7,t8,t9; |
| 479 |
520093696,<the_backup_id> |