Debian Codegraph @

mysql-test/suite/innodb/r/upgrade_unknown_directory.result

raw
1 # This test upgrades tables from 5.7 to 8.0.x where
2 # datafiles are not known directories.
3 # a warning message will be put into the error log
4 # Stop the running the server
5 ######################################################################
6 # Unzip a 5.7 datadir with tables where datafiles are at
7 # unknown directories
8 # start the server using this directory
9 ######################################################################
10 ######################################################################
11 # Copy and unzip the datadir.
12 ######################################################################
13 # Restart the server against the unzipped datadir
14 # restart: --datadir=DATADIR --innodb-page-size=16k
15 # Verify tables after upgrade
16 USE test;
17 SHOW CREATE TABLE t1;
18 Table Create Table
19 t1 CREATE TABLE `t1` (
20 `id` int NOT NULL,
21 `fname` varchar(30) DEFAULT NULL,
22 `lname` varchar(30) DEFAULT NULL
23 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='../unknown/'
24 SHOW CREATE TABLE t2;
25 Table Create Table
26 t2 CREATE TABLE `t2` (
27 `c1` int NOT NULL,
28 PRIMARY KEY (`c1`)
29 ) /*!50100 TABLESPACE `ts2` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
30 SHOW CREATE TABLE t3;
31 Table Create Table
32 t3 CREATE TABLE `t3` (
33 `id` int DEFAULT NULL,
34 `purchased` date DEFAULT NULL
35 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
36 /*!50100 PARTITION BY RANGE (year(`purchased`))
37 SUBPARTITION BY HASH (to_days(`purchased`))
38 (PARTITION p0 VALUES LESS THAN (1990)
39 (SUBPARTITION s0 DATA DIRECTORY = '../unknown' ENGINE = InnoDB,
40 SUBPARTITION s1 DATA DIRECTORY = '../unknown' ENGINE = InnoDB),
41 PARTITION p1 VALUES LESS THAN (2000)
42 (SUBPARTITION s2 DATA DIRECTORY = '../unknown' ENGINE = InnoDB,
43 SUBPARTITION s3 DATA DIRECTORY = '../unknown' ENGINE = InnoDB),
44 PARTITION p2 VALUES LESS THAN MAXVALUE
45 (SUBPARTITION s4 DATA DIRECTORY = '../unknown' ENGINE = InnoDB,
46 SUBPARTITION s5 DATA DIRECTORY = '../unknown' ENGINE = InnoDB)) */
47 SELECT * FROM t1;
48 id fname lname
49 1669 Jim Smith
50 337 Mary Jones
51 16 Frank White
52 2005 Linda Black
53 SELECT * FROM t2;
54 c1
55 16
56 337
57 1669
58 2005
59 SELECT * FROM t3;
60 id purchased
61 4 1970-05-31
62 1 1980-05-31
63 5 1985-05-31
64 2 2090-05-31
65 3 2012-05-31
66 6 2006-05-31
67 # Run some DML statements
68 INSERT INTO t1 VALUES (207, "Tom", "Kim");
69 DELETE FROM t2 WHERE c1=337;
70 UPDATE t3 SET purchased='2001-01-31' WHERE id=6;
71 # Verify results
72 SELECT * FROM t1;
73 id fname lname
74 1669 Jim Smith
75 337 Mary Jones
76 16 Frank White
77 2005 Linda Black
78 207 Tom Kim
79 SELECT * FROM t2;
80 c1
81 16
82 1669
83 2005
84 SELECT * FROM t3;
85 id purchased
86 4 1970-05-31
87 1 1980-05-31
88 5 1985-05-31
89 2 2090-05-31
90 3 2012-05-31
91 6 2001-01-31
92 # Cleanup
93 # Shutdown server
94 # Remove copied files
95 # Resart the server
96 # restart