Debian Codegraph @

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

raw
1 Backup restored
2 Restart server 1 to trigger schema synchronization
3 # restart
4 Check that tables can be used
5 SELECT COUNT(*) FROM information_schema.tables
6 WHERE table_schema LIKE 'db%';
7 COUNT(*)
8 100
9 SHOW CREATE TABLE db1.t1;
10 Table Create Table
11 t1 CREATE TABLE `t1` (
12 `col1` int unsigned NOT NULL AUTO_INCREMENT,
13 `col2` varchar(255) DEFAULT NULL,
14 `col3` varchar(255) DEFAULT NULL,
15 `col4` bigint unsigned NOT NULL,
16 `col5` varchar(20) DEFAULT NULL,
17 `col6` tinyint unsigned NOT NULL,
18 `col7` tinyint unsigned DEFAULT NULL,
19 `col8` varchar(255) DEFAULT NULL,
20 `col9` int unsigned DEFAULT NULL,
21 `col10` varchar(255) DEFAULT NULL,
22 `col11` varchar(255) DEFAULT NULL,
23 `col12` varchar(255) DEFAULT NULL,
24 `col13` bigint unsigned DEFAULT NULL,
25 `col14` varchar(255) DEFAULT NULL,
26 `col15` varchar(20) DEFAULT NULL,
27 `col16` bigint unsigned DEFAULT NULL,
28 `col17` decimal(10,5) NOT NULL,
29 `col18` decimal(10,5) NOT NULL,
30 `col19` decimal(10,5) NOT NULL,
31 `col20` float(7,2) NOT NULL,
32 PRIMARY KEY (`col1`)
33 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1
34 ALTER TABLE db1.t50 DROP COLUMN col2;
35 ALTER TABLE db1.t100 DROP COLUMN col20;