Debian Codegraph @

mysql-test/suite/ndb/t/ndb_metadata_upgrade_80_minor.test

raw
1 --source include/have_multi_ndb.inc
2 --source suite/ndb/include/backup_restore_setup.inc
3
4 #
5 # The backup being restored was created using the following commands in 8.0.18:
6 #
7 # CREATE TABLE t1 (
8 # a INT PRIMARY KEY,
9 # b VARCHAR(255)
10 # ) ENGINE NDB;
11 # INSERT INTO t1 VALUES
12 # (1, 'a'),
13 # (2, 'bb'),
14 # (3, 'ccc');
15 #
16 # CREATE TABLE t2 (
17 # c1 INT PRIMARY KEY AUTO_INCREMENT,
18 # c2 INT UNSIGNED NOT NULL,
19 # c3 FLOAT,
20 # c4 VARCHAR(255),
21 # c5 TIME,
22 # c6 DATE,
23 # c7 DATETIME,
24 # c8 BLOB,
25 # c9 CHAR(30),
26 # c10 VARBINARY(255),
27 # UNIQUE KEY xc2(c2)
28 # ) ENGINE NDB;
29 # INSERT INTO t2 VALUES(1,1,2.5,'a','23:59:59','2018-01-30','2018-01-30 13:46:00','b','c','d');
30 #
31 # CREATE TABLE t3 (
32 # c1 int PRIMARY KEY,
33 # c2 int GENERATED ALWAYS AS (c1*c1)
34 # ) ENGINE NDB;
35 # INSERT INTO t3(c1) VALUES(2);
36 #
37 # CREATE TABLE t4 (
38 # c1 int NOT NULL AUTO_INCREMENT PRIMARY KEY,
39 # c2 varchar(100),
40 # c3 varchar(100)
41 # ) ENGINE NDB
42 # COMMENT="NDB_TABLE=READ_BACKUP=0,PARTITION_BALANCE=FOR_RP_BY_NODE";
43 # INSERT INTO t4 VALUES(1,'a','a');
44 #
45 # CREATE LOGFILE GROUP lg1
46 # ADD UNDOFILE 'lg1_undofile.dat'
47 # INITIAL_SIZE 1M
48 # UNDO_BUFFER_SIZE = 1M
49 # ENGINE NDB;
50 #
51 # CREATE TABLESPACE ts1
52 # ADD DATAFILE 'ts1_datafile.dat'
53 # USE LOGFILE GROUP lg1
54 # INITIAL_SIZE 2M
55 # ENGINE NDB;
56 #
57 # CREATE TABLE t5 (
58 # a INT PRIMARY KEY,
59 # b VARCHAR(255)
60 # ) ENGINE NDB
61 # TABLESPACE ts1 STORAGE DISK;
62 # INSERT INTO t5 VALUES (1,'Lipstick on a pig');
63 #
64
65 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m -r --backup-path=$NDB_SAVED_BACKUPS/metadata_upgrade_80_minor >> $NDB_TOOLS_OUTPUT
66 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r --backup-path=$NDB_SAVED_BACKUPS/metadata_upgrade_80_minor >> $NDB_TOOLS_OUTPUT
67
68 --echo Backup restored
69
70 # Test upgrade of the metadata during schema synchronization
71 --echo Restart server 1 to trigger schema synchronization
72 let $mysqld_name=mysqld.1.1;
73 --source include/restart_mysqld.inc
74
75 # Check if the tables have been synced
76 SHOW TABLES;
77
78 # Check table definitions and data
79 SHOW CREATE TABLE t1;
80 --sorted_result
81 SELECT * FROM t1;
82 SHOW CREATE TABLE t2;
83 SELECT * FROM t2;
84 SHOW CREATE TABLE t3;
85 INSERT INTO t3(c1) VALUES(14);
86 --sorted_result
87 SELECT * FROM t3;
88 SHOW CREATE TABLE t4;
89 SELECT * FROM t4;
90 SHOW CREATE TABLE t5;
91 SELECT * FROM t5;
92
93 # Demonstration of extracting information about NDB table extra metadata.
94 # For SDI extract some version information.
95 # To get stable result tables restored from the saved backup are used.
96 --replace_regex /BLOB_[0-9]+_[0-9]+/BLOB_#_#/
97 SELECT
98 RPAD(CONCAT(database_name, '.', table_name),30,' ') 'table',
99 extra_metadata_version,
100 LENGTH(extra_metadata) len,
101 IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.mysqld_version_id'), NULL) mysqld_version_id,
102 IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.dd_version'), NULL) dd_version,
103 IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.sdi_version'), NULL) sdi_version
104 FROM ndbinfo.dictionary_tables
105 ORDER BY 1,2;
106
107 # Clean-up
108 DROP TABLE t1, t2, t3, t4, t5;
109 ALTER TABLESPACE ts1
110 DROP DATAFILE 'ts1_datafile.dat';
111 DROP TABLESPACE ts1;
112 DROP LOGFILE GROUP lg1
113 ENGINE NDB;
114 --remove_file $NDB_TOOLS_OUTPUT