Debian Codegraph @

mysql-test/suite/innodb_fts/t/tablespace_location.test

raw
1 --echo #
2 --echo # BUG#20527217 - INNODB: PUT FTS AUXILIARY TABLES INTO THE SAME GENERAL
3 --echo # TABLESPACE AS THE PRIMARY
4 --echo #
5
6 --source include/have_innodb_max_16k.inc
7
8 # Create a table with FTS columns and make sure the auxilliary
9 # table are created in the same tablespace.
10
11
12 SET DEFAULT_STORAGE_ENGINE=InnoDB;
13
14 SET GLOBAL innodb_file_per_table = ON;
15 SHOW VARIABLES LIKE 'innodb_file_per_table';
16
17 --echo # Strict-mode has no affect on CREATE TABLESPACE.
18 --echo # It rejects all invalid input, as if strict mode is always ON.
19 SET SESSION innodb_strict_mode = OFF;
20 SHOW VARIABLES LIKE 'innodb_strict_mode';
21
22 CREATE TABLESPACE s_def ADD DATAFILE 's_def.ibd';
23 CREATE TABLESPACE s_zip ADD DATAFILE 's_zip.ibd' FILE_BLOCK_SIZE=2k;
24
25 --let $MYSQLD_DATADIR = `select @@datadir`
26 --let $INNODB_PAGE_SIZE = `select @@innodb_page_size`
27 --source suite/innodb/include/show_i_s_tablespaces.inc
28
29 --let $TABLESPACE=s_def
30 --let $ROW_FORMAT=redundant
31 --echo #
32 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
33 --echo #
34 --source ../include/tablespace_location.inc
35
36 --let $TABLESPACE=s_def
37 --let $ROW_FORMAT=compact
38 --echo #
39 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
40 --echo #
41 --source ../include/tablespace_location.inc
42
43 --let $TABLESPACE=s_def
44 --let $ROW_FORMAT=dynamic
45 --echo #
46 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
47 --echo #
48 --source ../include/tablespace_location.inc
49
50 --let $TABLESPACE=s_zip
51 --let $ROW_FORMAT=compressed
52 --let $EXTRA_PARAMS=KEY_BLOCK_SIZE=2
53 --echo #
54 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT $EXTRA_PARAMS
55 --echo #
56 --source ../include/tablespace_location.inc
57 # to unset EXTRA_PARAMS
58 --let $EXTRA_PARAMS=
59
60 --let $TABLESPACE=innodb_file_per_table
61 --let $ROW_FORMAT=dynamic
62 --echo #
63 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
64 --echo #
65 --source ../include/tablespace_location.inc
66
67 --let $TABLESPACE=innodb_file_per_table
68 --let $ROW_FORMAT=compressed
69 --let $EXTRA_PARAMS=KEY_BLOCK_SIZE=2
70 --echo #
71 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT $EXTRA_PARAMS
72 --echo #
73 --source ../include/tablespace_location.inc
74 # to unset EXTRA_PARAMS
75 --let $EXTRA_PARAMS=
76
77 --let $TABLESPACE=innodb_system
78 --let $ROW_FORMAT=redundant
79 --echo #
80 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
81 --echo #
82 --source ../include/tablespace_location.inc
83
84 --let $TABLESPACE=innodb_system
85 --let $ROW_FORMAT=compact
86 --echo #
87 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
88 --echo #
89 --source ../include/tablespace_location.inc
90
91 --let $TABLESPACE=innodb_system
92 --let $ROW_FORMAT=dynamic
93 --echo #
94 --echo # tablespace=$TABLESPACE row_format=$ROW_FORMAT
95 --echo #
96 --source ../include/tablespace_location.inc
97
98 --echo #
99 --echo # Without TABLESPACE=, innodb_file_per_table=ON(default);
100 --echo #
101 --eval CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));
102 --source suite/innodb/include/show_i_s_tables.inc
103 DROP TABLE t1;
104
105 --echo #
106 --echo # Without TABLESPACE=, innodb_file_per_table=OFF
107 --echo #
108 SET GLOBAL innodb_file_per_table=OFF;
109 --eval CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));
110 --source suite/innodb/include/show_i_s_tables.inc
111 DROP TABLE t1;
112 SET GLOBAL innodb_file_per_table=default;
113
114 --error 1796
115 CREATE TEMPORARY TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT(a,b))
116 TABLESPACE=innodb_temporary ROW_FORMAT=compact;
117
118 --echo # Test with FTS TABLES in remote DATA DIRECTORY
119 --let $REMOTE_DIR = $MYSQL_TMP_DIR/fts_remote
120 --mkdir $REMOTE_DIR
121
122 --replace_result $REMOTE_DIR REMOTE_DIR
123 --eval CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) DATA DIRECTORY '$REMOTE_DIR'
124 --source suite/innodb/include/show_i_s_tables.inc
125
126 --echo # list files in REMOTE_DIR
127 --let $regexp=/fts_([0-9a-f_]+)([A-Z0-9_]+)/fts_aux\2/
128 --replace_regex $regexp
129 --list_files $REMOTE_DIR/test *
130
131 # Truncate the table
132 TRUNCATE TABLE t1;
133
134 # Truncate after restart
135 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
136 --source include/restart_mysqld.inc
137 TRUNCATE TABLE t1;
138
139 --echo # list files in REMOTE_DIR after TRUNCATE
140 --replace_regex $regexp
141 --list_files $REMOTE_DIR/test *
142
143 DROP TABLE t1;
144 --echo # list files after DROP TABLE. Should be empty
145 --list_files $REMOTE_DIR/test *
146
147 --rmdir $REMOTE_DIR/test/
148 --rmdir $REMOTE_DIR
149
150 --echo # Test with FTS , IMPORT & EXPORT tablespace
151 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def;
152 FLUSH TABLES t1 FOR EXPORT;
153 UNLOCK TABLES;
154 DROP TABLE t1;
155
156 --echo # Test with ALTER. Add a FTS Index and also move the current
157 --echo # table to general tablespace
158
159 CREATE TABLE t1 (
160 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
161 title VARCHAR(200)
162 ) ENGINE=InnoDB;
163
164 --source suite/innodb/include/show_i_s_tables.inc
165 ALTER TABLE t1 ADD FULLTEXT INDEX (title), TABLESPACE=s_def;
166 --source suite/innodb/include/show_i_s_tables.inc
167
168 DROP TABLE t1;
169
170 --let $CREATE_TABLE_PARAMS=TABLESPACE=s_def ROW_FORMAT=compact
171 --source ../include/tablespace_location_alter.inc
172
173 --echo # Test with file-per-table tablespace
174 --let $CREATE_TABLE_PARAMS=
175 --source ../include/tablespace_location_alter.inc
176
177 #
178 # Clean-up.
179 #
180
181 DROP TABLESPACE s_def;
182 DROP TABLESPACE s_zip;
183
184 SET GLOBAL innodb_file_per_table = default;