| 1 |
# ************************************************************** |
| 2 |
# wl8307 : Check Default_row_format functionality |
| 3 |
# case 1; Check with no tablespace (file_per_table=1) |
| 4 |
# case 2: Check with General tablespace |
| 5 |
# case 3: Check with innodb_system tablespace |
| 6 |
# case 4: Check with innodb_file_per_table=OFF |
| 7 |
# Modifying Dynamic to Compact to Dynamic to Redundant to |
| 8 |
# compressed to Dynamic |
| 9 |
# Modify table Dynamic to Compact to Compressed to Dynamic |
| 10 |
# ************************************************************** |
| 11 |
# InnoDB does not support compressed tables for page sizes=32k,64k |
| 12 |
# Also FILE_BLOCK_SIZE=8k and KEY_BLOCK_SIZEr=8 |
| 13 |
--source include/have_innodb_max_16k.inc |
| 14 |
|
| 15 |
# Check without any tablespace is set |
| 16 |
--let tablespace= |
| 17 |
--source ../include/default_row_format_tablespace.inc |
| 18 |
|
| 19 |
# Check with tablespace is set, with and without Key_block_size |
| 20 |
let tablespace = tblsp; |
| 21 |
--source ../include/default_row_format_tablespace.inc |
| 22 |
|
| 23 |
# Check with innodb_system is set |
| 24 |
let tablespace = innodb_system; |
| 25 |
--source ../include/default_row_format_tablespace.inc |
| 26 |
|
| 27 |
# Check with innodb_file_per_table=0 |
| 28 |
let tablespace = OFF; |
| 29 |
--source ../include/default_row_format_tablespace.inc |