Debian Codegraph @

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

raw
1 #
2 # CREATE TABLESPACE related tests for 32k page sizes.
3 #
4 SET DEFAULT_STORAGE_ENGINE=InnoDB;
5 # Strict-mode has no effect on CREATE TABLESPACE. But it does affect
6 # whether an invalid KEY_BLOCK_SIZE is rejected or adjusted.
7 SHOW VARIABLES LIKE 'innodb_strict_mode';
8 Variable_name Value
9 innodb_strict_mode ON
10 SHOW VARIABLES LIKE 'innodb_file_per_table';
11 Variable_name Value
12 innodb_file_per_table ON
13 #
14 # Create a tablespace with compressed page sizes that can match
15 # innodb-page-size.
16 #
17 CREATE TABLESPACE s_1k ADD DATAFILE 's_1k.ibd' FILE_BLOCK_SIZE=1k;
18 ERROR HY000: InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
19 SHOW WARNINGS;
20 Level Code Message
21 Error 1478 InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
22 Error 1528 Failed to create TABLESPACE s_1k
23 Error 1031 Table storage engine for 's_1k' doesn't have this option
24 CREATE TABLESPACE s_2k ADD DATAFILE 's_2k.ibd' FILE_BLOCK_SIZE=2k;
25 ERROR HY000: InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
26 SHOW WARNINGS;
27 Level Code Message
28 Error 1478 InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
29 Error 1528 Failed to create TABLESPACE s_2k
30 Error 1031 Table storage engine for 's_2k' doesn't have this option
31 CREATE TABLESPACE s_4k ADD DATAFILE 's_4k.ibd' FILE_BLOCK_SIZE=4k;
32 ERROR HY000: InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
33 SHOW WARNINGS;
34 Level Code Message
35 Error 1478 InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
36 Error 1528 Failed to create TABLESPACE s_4k
37 Error 1031 Table storage engine for 's_4k' doesn't have this option
38 CREATE TABLESPACE s_8k ADD DATAFILE 's_8k.ibd' FILE_BLOCK_SIZE=8k;
39 ERROR HY000: InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
40 SHOW WARNINGS;
41 Level Code Message
42 Error 1478 InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
43 Error 1528 Failed to create TABLESPACE s_8k
44 Error 1031 Table storage engine for 's_8k' doesn't have this option
45 CREATE TABLESPACE s_16k ADD DATAFILE 's_16k.ibd' FILE_BLOCK_SIZE=16k;
46 ERROR HY000: InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
47 SHOW WARNINGS;
48 Level Code Message
49 Error 1478 InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
50 Error 1528 Failed to create TABLESPACE s_16k
51 Error 1031 Table storage engine for 's_16k' doesn't have this option
52 CREATE TABLESPACE s_32k ADD DATAFILE 's_32k.ibd' FILE_BLOCK_SIZE=32k;
53 ERROR HY000: InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
54 SHOW WARNINGS;
55 Level Code Message
56 Error 1478 InnoDB: Cannot create a COMPRESSED tablespace when innodb_page_size > 16k.
57 Error 1528 Failed to create TABLESPACE s_32k
58 Error 1031 Table storage engine for 's_32k' doesn't have this option
59 CREATE TABLESPACE s_64k ADD DATAFILE 's_64k.ibd' FILE_BLOCK_SIZE=64k;
60 === information_schema.innodb_tablespaces and innodb_datafiles ===
61 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
62 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
63 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
64 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
65 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
66 s_64k General DEFAULT 0 1 1 Any s_64k.ibd
67 === information_schema.files ===
68 Space_Name File_Type Engine Status Tablespace_Name Path
69 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
70 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
71 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
72 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
73 s_64k TABLESPACE InnoDB NORMAL s_64k MYSQLD_DATADIR/s_64k.ibd
74 #
75 # Add tables to the tablespaces.
76 #
77 CREATE TABLE t_zip1k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_64k;
78 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
79 SHOW WARNINGS;
80 Level Code Message
81 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
82 Error 1031 Table storage engine for 't_zip1k_in_64k' doesn't have this option
83 CREATE TABLE t_zip2k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_64k;
84 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
85 SHOW WARNINGS;
86 Level Code Message
87 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
88 Error 1031 Table storage engine for 't_zip2k_in_64k' doesn't have this option
89 CREATE TABLE t_zip4k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_64k;
90 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
91 SHOW WARNINGS;
92 Level Code Message
93 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
94 Error 1031 Table storage engine for 't_zip4k_in_64k' doesn't have this option
95 CREATE TABLE t_zip8k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_64k;
96 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
97 SHOW WARNINGS;
98 Level Code Message
99 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
100 Error 1031 Table storage engine for 't_zip8k_in_64k' doesn't have this option
101 CREATE TABLE t_zip16k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_64k;
102 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
103 SHOW WARNINGS;
104 Level Code Message
105 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
106 Error 1031 Table storage engine for 't_zip16k_in_64k' doesn't have this option
107 CREATE TABLE t_zip32k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_64k;
108 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
109 SHOW WARNINGS;
110 Level Code Message
111 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
112 Error 1031 Table storage engine for 't_zip32k_in_64k' doesn't have this option
113 CREATE TABLE t_zip64k_in_64k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_64k;
114 ERROR HY000: InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
115 SHOW WARNINGS;
116 Level Code Message
117 Error 1478 InnoDB: Tablespace `s_64k` cannot contain a COMPRESSED table
118 Error 1031 Table storage engine for 't_zip64k_in_64k' doesn't have this option
119 CREATE TABLE t_red_in_64k (a int, b text) ROW_FORMAT=redundant TABLESPACE s_64k;
120 CREATE TABLE t_com_in_64k (a int, b text) ROW_FORMAT=compact TABLESPACE s_64k;
121 CREATE TABLE t_dyn_in_64k (a int, b text) ROW_FORMAT=dynamic TABLESPACE s_64k;
122 # Add data to the existing Tables
123 INSERT INTO t_red_in_64k VALUES (1,'a'),(2,'b'),(3,'c');
124 INSERT INTO t_com_in_64k VALUES (1,'a'),(2,'b'),(3,'c');
125 INSERT INTO t_dyn_in_64k VALUES (1,'a'),(2,'b'),(3,'c');
126 # Restart mysqld
127 # restart
128 #
129 # Try to drop a tablespace which is not empty
130 #
131 DROP TABLESPACE s_64k;
132 ERROR HY000: Tablespace `s_64k` is not empty.
133 #
134 # Add more data to the existing Tables
135 #
136 INSERT INTO t_red_in_64k VALUES (4,'d');
137 INSERT INTO t_com_in_64k VALUES (4,'d');
138 INSERT INTO t_dyn_in_64k VALUES (4,'d');
139 #
140 # Restart the server and make sure that everything is OK.
141 #
142 # restart
143 === information_schema.innodb_tablespaces and innodb_datafiles ===
144 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
145 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
146 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
147 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
148 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
149 s_64k General DEFAULT 0 1 1 Any s_64k.ibd
150 === information_schema.files ===
151 Space_Name File_Type Engine Status Tablespace_Name Path
152 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
153 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
154 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
155 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
156 s_64k TABLESPACE InnoDB NORMAL s_64k MYSQLD_DATADIR/s_64k.ibd
157 === information_schema.innodb_tables and innodb_tablespaces ===
158 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
159 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
160 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
161 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
162 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
163 test/t_com_in_64k s_64k 129 5 Compact 0 General
164 test/t_dyn_in_64k s_64k 161 5 Dynamic 0 General
165 test/t_red_in_64k s_64k 128 5 Redundant 0 General
166 # Directory of MYSQLD_DATADIR/
167 mysql.ibd
168 s_64k.ibd
169 # Directory of MYSQLD_DATADIR/test/
170 #
171 # Clean-up.
172 #
173 CHECK TABLE t_red_in_64k;
174 Table Op Msg_type Msg_text
175 test.t_red_in_64k check status OK
176 CHECK TABLE t_com_in_64k;
177 Table Op Msg_type Msg_text
178 test.t_com_in_64k check status OK
179 CHECK TABLE t_dyn_in_64k;
180 Table Op Msg_type Msg_text
181 test.t_dyn_in_64k check status OK
182 DROP TABLE t_red_in_64k;
183 DROP TABLE t_com_in_64k;
184 DROP TABLE t_dyn_in_64k;
185 DROP TABLESPACE s_64k;