Debian Codegraph @

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

raw
1 Backup restored
2 Restart server 1 to trigger schema synchronization
3 # restart
4 SHOW TABLES;
5 Tables_in_test
6 t1
7 t2
8 t3
9 t4
10 t5
11 SHOW CREATE TABLE t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `a` int NOT NULL,
15 `b` varchar(255) DEFAULT NULL,
16 PRIMARY KEY (`a`)
17 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
18 SELECT * FROM t1;
19 a b
20 1 a
21 2 bb
22 3 ccc
23 SHOW CREATE TABLE t2;
24 Table Create Table
25 t2 CREATE TABLE `t2` (
26 `c1` int NOT NULL AUTO_INCREMENT,
27 `c2` int unsigned NOT NULL,
28 `c3` float DEFAULT NULL,
29 `c4` varchar(255) DEFAULT NULL,
30 `c5` time DEFAULT NULL,
31 `c6` date DEFAULT NULL,
32 `c7` datetime DEFAULT NULL,
33 `c8` blob,
34 `c9` char(30) DEFAULT NULL,
35 `c10` varbinary(255) DEFAULT NULL,
36 PRIMARY KEY (`c1`),
37 UNIQUE KEY `xc2` (`c2`)
38 ) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
39 SELECT * FROM t2;
40 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10
41 1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b c d
42 SHOW CREATE TABLE t3;
43 Table Create Table
44 t3 CREATE TABLE `t3` (
45 `c1` int NOT NULL,
46 `c2` int GENERATED ALWAYS AS ((`c1` * `c1`)) VIRTUAL,
47 PRIMARY KEY (`c1`)
48 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
49 INSERT INTO t3(c1) VALUES(14);
50 SELECT * FROM t3;
51 c1 c2
52 14 196
53 2 4
54 SHOW CREATE TABLE t4;
55 Table Create Table
56 t4 CREATE TABLE `t4` (
57 `c1` int NOT NULL AUTO_INCREMENT,
58 `c2` varchar(100) DEFAULT NULL,
59 `c3` varchar(100) DEFAULT NULL,
60 PRIMARY KEY (`c1`)
61 ) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='NDB_TABLE=READ_BACKUP=0,PARTITION_BALANCE=FOR_RP_BY_NODE'
62 SELECT * FROM t4;
63 c1 c2 c3
64 1 a a
65 SHOW CREATE TABLE t5;
66 Table Create Table
67 t5 CREATE TABLE `t5` (
68 `a` int NOT NULL,
69 `b` varchar(255) DEFAULT NULL,
70 PRIMARY KEY (`a`)
71 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
72 SELECT * FROM t5;
73 a b
74 1 Lipstick on a pig
75 SELECT
76 RPAD(CONCAT(database_name, '.', table_name),30,' ') 'table',
77 extra_metadata_version,
78 LENGTH(extra_metadata) len,
79 IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.mysqld_version_id'), NULL) mysqld_version_id,
80 IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.dd_version'), NULL) dd_version,
81 IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.sdi_version'), NULL) sdi_version
82 FROM ndbinfo.dictionary_tables
83 ORDER BY 1,2;
84 table extra_metadata_version len mysqld_version_id dd_version sdi_version
85 mysql.NDB$BLOB_#_# NULL NULL NULL NULL NULL
86 mysql.ndb_apply_status FRM 8716 NULL NULL NULL
87 mysql.ndb_index_stat_head NULL NULL NULL NULL NULL
88 mysql.ndb_index_stat_sample NULL NULL NULL NULL NULL
89 mysql.ndb_schema FRM 8810 NULL NULL NULL
90 mysql.ndb_schema_result NULL NULL NULL NULL NULL
91 mysql.ndb_sql_metadata NULL NULL NULL NULL NULL
92 test.NDB$BLOB_#_# NULL NULL NULL NULL NULL
93 test.t1 SDI 4726 80018 80017 80016
94 test.t2 SDI 11176 80018 80017 80016
95 test.t3 SDI 4747 80018 80017 80016
96 test.t4 SDI 5505 80018 80017 80016
97 test.t5 SDI 4781 80018 80017 80016
98 DROP TABLE t1, t2, t3, t4, t5;
99 ALTER TABLESPACE ts1
100 DROP DATAFILE 'ts1_datafile.dat';
101 DROP TABLESPACE ts1;
102 DROP LOGFILE GROUP lg1
103 ENGINE NDB;