Gecko [ www.jdcpatala.org ]

Name	Size	Permission
alter_table_pk_no_sort.inc	10.86 KB	-rw-r--r--
check_pfs_mem_other_is_zero.in...	623 B	-rw-r--r--
checksum_not_strict.inc	151 B	-rw-r--r--
create_options_invalid.inc	1.29 KB	-rw-r--r--
create_workload_itt.inc	13.86 KB	-rw-r--r--
default_row_format_alter.inc	3.25 KB	-rw-r--r--
default_row_format_create.inc	995 B	-rw-r--r--
default_row_format_large.inc	1.32 KB	-rw-r--r--
default_row_format_show.inc	119 B	-rw-r--r--
default_row_format_tablespace....	3.75 KB	-rw-r--r--
drop_workload_itt.inc	150 B	-rw-r--r--
import.inc	1014 B	-rw-r--r--
innodb-multiple-tablespaces-cl...	193 B	-rw-r--r--
innodb_bulk_create_index.inc	4.1 KB	-rw-r--r--
innodb_bulk_create_index_debug...	4.26 KB	-rw-r--r--
innodb_dict.inc	371 B	-rw-r--r--
innodb_import.inc	28.86 KB	-rw-r--r--
innodb_isolation_selects.inc	1.21 KB	-rw-r--r--
innodb_merge_threshold_delete....	4.19 KB	-rw-r--r--
innodb_merge_threshold_seconda...	6.65 KB	-rw-r--r--
innodb_merge_threshold_update....	3.47 KB	-rw-r--r--
innodb_stats.inc	665 B	-rw-r--r--
innodb_stats_table_flag.inc	2.33 KB	-rw-r--r--
innodb_stats_table_flag_analyz...	508 B	-rw-r--r--
innodb_undo_logs_action.inc	861 B	-rw-r--r--
innodb_v_large_col.inc	1.47 KB	-rw-r--r--
innodb_wl6501_crash.inc	12.68 KB	-rw-r--r--
innodb_wl6501_crash_temp.inc	3.25 KB	-rw-r--r--
log_file_cleanup.inc	748 B	-rw-r--r--
query_workload_itt.inc	7.44 KB	-rw-r--r--
show_i_s_tables.inc	655 B	-rw-r--r--
show_i_s_tablespaces.inc	1.57 KB	-rw-r--r--
tablespace_filenames.inc	3.22 KB	-rw-r--r--
tablespace_portability.inc	16.79 KB	-rw-r--r--
wl5522_oom.inc	211 B	-rw-r--r--

Code Editor : default_row_format_tablespace.inc

# Check Default row_format=Dynamic
SELECT @@innodb_default_row_format;

# Check if no tablespace is set
if ($tablespace == '') {

# Check Default file_per_table=ON & Barracuda
SELECT @@innodb_file_per_table;

--echo #Create table with no tablespace
CREATE TABLE tab(c1  TEXT, c2 BLOB);

# Insert some records
INSERT INTO tab VALUES('Check with no tablespace','Check with no tablespace');
}

# Check if tablespace is set
if ($tablespace == 'tblsp') {

# Check for compressed tables without File_block_size.
--echo #Create table with tablespace
CREATE TABLESPACE $tablespace ADD DATAFILE '$tablespace.ibd'
ENGINE=InnoDB;

CREATE TABLE tab(c1  TEXT, c2 BLOB) TABLESPACE $tablespace;

# Check for compressed tables with File_block_size.
CREATE TABLESPACE tblsp1 ADD DATAFILE 'tblsp1.ibd' FILE_BLOCK_SIZE=1k
ENGINE=InnoDB;
CREATE TABLE tab1(c1  TEXT, c2 BLOB) KEY_BLOCK_SIZE=1 TABLESPACE tblsp1;

# Insert some records
INSERT INTO tab VALUES('Check with General tablespace',
'Check with General tablespace');
INSERT INTO tab1 VALUES('tablsp File Block size',
'tablsp File Block size');
}

# Check if system tablespace is set
if ($tablespace == 'innodb_system') {

--echo #Create table with innodb system tablespace
# Create table in system tablesspace
CREATE TABLE tab(c1  TEXT, c2 BLOB) TABLESPACE innodb_system;

# Insert some records
INSERT INTO tab VALUES('Check with InnoDB system tablespace',
'Check with InnoDB system tablespace');

}

# Check when file_per_table=OFF is set
if ($tablespace == 'OFF') {
# Set file_per_table=OFF
SET GLOBAL innodb_file_per_table=0;

# Check Default file_per_table=OFF
SELECT @@innodb_file_per_table;

--echo #Create table with file_per_table=0
CREATE TABLE tab(c1  TEXT, c2 BLOB);

# Insert some records
INSERT INTO tab VALUES('File per table off','File per table off');
}

# Check Default row_format=Dynamic
--source suite/innodb/include/default_row_format_show.inc

ALTER TABLE tab ROW_FORMAT=COMPACT;

# Check Default row_format=Compact
--source suite/innodb/include/default_row_format_show.inc

CHECK TABLE tab;

ALTER TABLE tab ROW_FORMAT=DYNAMIC;

# Check Default row_format=Dynamic
--source suite/innodb/include/default_row_format_show.inc

CHECK TABLE tab;

ALTER TABLE tab ROW_FORMAT=REDUNDANT;

# Check Default row_format=Redundant
--source suite/innodb/include/default_row_format_show.inc

CHECK TABLE tab;

# Check successful, when no tablespace is set
if ($tablespace == '') {
ALTER TABLE tab ROW_FORMAT=COMPRESSED;
}

# When tablespace is set, check error for compressed tables with
# and without File_block_size
# Check ALTER success for compressed tables with tablespace File_block_size
if ($tablespace == 'tblsp') {

# Check error with compressed tables without File_block_size
--error ER_ILLEGAL_HA_CREATE_OPTION
ALTER TABLE tab ROW_FORMAT=COMPRESSED;

# Check error with compressed tables with File_block_size
--error ER_ILLEGAL_HA_CREATE_OPTION
ALTER TABLE tab1 ROW_FORMAT=DYNAMIC;
}

# Check when file_per_table=OFF is set
if ($tablespace == 'OFF') {
--error ER_ILLEGAL_HA_CREATE_OPTION
ALTER TABLE tab ROW_FORMAT=COMPRESSED;
}

# Check Default row_format=Compressed
# Note: we do not use default_row_format_show.inc because
# ALTER ROW_FORMAT=COMPRESSED shows different compressed page sizes
# with different innodb_page_sizes
SELECT NAME,FILE_FORMAT,ROW_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES
WHERE NAME='test/tab';

CHECK TABLE tab;

if ($tablespace == 'tblsp') {
CHECK TABLE tab1;
}

ALTER TABLE tab ROW_FORMAT=Dynamic;

# Check Default row_format=Dynamic;
--source suite/innodb/include/default_row_format_show.inc

CHECK TABLE tab;

# Cleanup
DROP TABLE tab;

# Drop only when tablespace is set
if ($tablespace == 'tblsp') {
DROP TABLE tab1;
DROP TABLESPACE $tablespace;
DROP TABLESPACE tblsp1;
}

# Reset to default values
SET GLOBAL innodb_file_per_table=Default;

${this.title}

Code Editor : default_row_format_tablespace.inc