Debian Codegraph @

mysql-test/suite/ndbcluster/tablespace_datafiles.test

raw
1 --source include/have_ndb.inc
2
3 # Create logfile group
4 CREATE LOGFILE GROUP lg1
5 ADD UNDOFILE 'lg1_undofile.dat'
6 INITIAL_SIZE 1M
7 UNDO_BUFFER_SIZE = 1M
8 ENGINE=NDB;
9
10 # Create tablespace
11 CREATE TABLESPACE ts1
12 ADD DATAFILE 'ts1_datafile.dat'
13 USE LOGFILE GROUP lg1
14 INITIAL_SIZE 1M
15 ENGINE NDB;
16
17 # Add an extra datafile
18 ALTER TABLESPACE ts1
19 ADD DATAFILE 'ts1_datafile2.dat'
20 INITIAL_SIZE = 4M;
21
22 # Check for UNDO LOG file in I_S
23 SELECT file_name, file_type FROM information_schema.files
24 WHERE engine='ndbcluster' AND file_type = 'UNDO LOG';
25
26 # Check for DATAFILE in I_S
27 SELECT file_name, file_type FROM information_schema.files
28 WHERE engine='ndbcluster' AND file_type = 'DATAFILE';
29
30 # Drop datafile from tablespace
31 ALTER TABLESPACE ts1
32 DROP DATAFILE 'ts1_datafile.dat';
33
34 # Drop second datafile from NDB
35 ALTER TABLESPACE ts1
36 DROP DATAFILE 'ts1_datafile2.dat';
37
38 # Bug#26133507: ATTEMPT TO DROP NONEXISTING DATAFILE FROM TABLESPACE GIVES
39 # 'INCORRECT FILE NAME'
40 # Drop second datafile from NDB again
41 --error ER_MISSING_TABLESPACE_FILE
42 ALTER TABLESPACE ts1
43 DROP DATAFILE 'ts1_datafile2.dat';
44
45 # Drop tablespace
46 DROP TABLESPACE ts1;
47
48 # Create empty datafile
49 --write_file $MYSQLTEST_VARDIR/tmp/t1.dat
50 EOF
51
52 # Try to create tablespace with the same datafile
53 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
54 --error ER_CREATE_FILEGROUP_FAILED
55 --eval CREATE TABLESPACE ts1 ADD DATAFILE '$MYSQLTEST_VARDIR/tmp/t1.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 1M ENGINE NDB
56 SHOW WARNINGS;
57
58 # Create tablespace again this time with valid datafile
59 CREATE TABLESPACE ts1
60 ADD DATAFILE 'ts1_datafile.dat'
61 USE LOGFILE GROUP lg1
62 INITIAL_SIZE 1M
63 ENGINE NDB;
64
65 # Drop datafile from tablespace
66 ALTER TABLESPACE ts1
67 DROP DATAFILE 'ts1_datafile.dat';
68
69 # Drop tablespace
70 DROP TABLESPACE ts1;
71
72 --echo #
73 --echo # WL#12236 - CREATE TABLESPACE without DATAFILE clause.
74 --echo #
75
76 CREATE TABLESPACE ts1
77 USE LOGFILE GROUP lg1
78 INITIAL_SIZE 1M
79 ENGINE NDB;
80 let $datafile_name = `SELECT SUBSTR(file_name,3) FROM INFORMATION_SCHEMA.FILES WHERE engine='ndbcluster' AND file_type = 'DATAFILE'`;
81
82 # Drop datafile from tablespace
83 --replace_result $datafile_name DATAFILE_NAME
84 eval ALTER TABLESPACE ts1 DROP DATAFILE '$datafile_name';
85 DROP TABLESPACE ts1;
86
87 # create tablespace without DATAFILE clause and alter tablespace with ADD DATAFILE clause
88 CREATE TABLESPACE ts2
89 USE LOGFILE GROUP lg1
90 INITIAL_SIZE 1M
91 ENGINE NDB;
92
93 ALTER TABLESPACE ts2
94 ADD DATAFILE 'data_2.dat'
95 INITIAL_SIZE 1M;
96
97 CREATE TABLE t2 (
98 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
99 last_name VARCHAR(50) NOT NULL,
100 first_name VARCHAR(50) NOT NULL,
101 dob DATE NOT NULL,
102 joined DATE NOT NULL,
103 INDEX(last_name, first_name)
104 )
105 TABLESPACE ts2 STORAGE DISK
106 ENGINE NDB;
107
108 INSERT INTO t2 VALUES(1,'aaa','bbb','1981-02-04','2017-07-17');
109 SELECT * FROM t2;
110 DROP TABLE t2;
111
112 ALTER TABLESPACE ts2 DROP DATAFILE 'data_2.dat';
113
114 let $datafile_name1=`SELECT SUBSTR(file_name,3) FROM INFORMATION_SCHEMA.FILES WHERE engine='ndbcluster' AND file_type = 'DATAFILE'`;
115
116 --replace_result $datafile_name1 DATAFILE_NAME
117 eval ALTER TABLESPACE ts2 DROP DATAFILE '$datafile_name1';
118
119 DROP TABLESPACE ts2;
120
121 # Drop logfile group
122 DROP LOGFILE GROUP lg1
123 ENGINE=NDB;
124
125 # Remove empty datafile
126 --remove_file $MYSQLTEST_VARDIR/tmp/t1.dat