^^&&^^

Edit File: innodb_wl6347_comp_indx_stat.test

#******************************************************************
# test the interaction between wl6347 & wl6344 (2.1)
# This testcase is to verify the table/idex level comoression stats
# When the flags are set as follows
# innodb_cmp_per_index_enabled=ON and innodb_compression_level=0
# page size 1K,2K,4K,8K,16K
# check the size and compression stats of the table tab5
#******************************************************************

# This test case needs InnoDB.
-- source include/have_innodb.inc
-- source include/not_embedded.inc
-- source include/have_innodb_16k.inc
-- source include/not_valgrind.inc

-- vertical_results

let MYSQLD_DATADIR=`SELECT @@datadir`;
let $innodb_compression_level = `SELECT @@global.innodb_compression_level`;

--echo # set the flags
SET GLOBAL innodb_file_per_table=on;
SET GLOBAL innodb_file_format='barracuda';
SET GLOBAL innodb_cmp_per_index_enabled=ON;
SET GLOBAL innodb_compression_level=0;

#******************************************************************
# innodb_cmp_per_index_enabled=ON and innodb_compression_level=0
# with page size 1K
#******************************************************************

--echo # create a table with page size=1K
--echo # create indexes on each column.(total 9 indexes)
let $block_size=1;
--source suite/innodb_zip/include/innodb_create_tab_indx.inc

--echo # check the stats of the table & size of the table
SET @inl_val=1;
--source suite/innodb_zip/include/innodb_stats_comp_index.inc

--echo # for deterministic reasons simple data should be inserted.
--echo # insert some 100 records
let $i = 100;
--source suite/innodb_zip/include/innodb_load_data.inc

--echo # check the stats of the table & size of the table
SET @inl_val=2;
--source suite/innodb_zip/include/innodb_stats_comp_index.inc

--echo # fetch the compressed page and check the stats
--source suite/innodb_zip/include/innodb_fetch_records.inc

--echo # check the stats of the table & size of the table
SET @inl_val=2;
--source suite/innodb_zip/include/innodb_stats_comp_index.inc

--echo # fetch the compressed same page once again and check the stats
--echo # the stat figures should be same as above query
--source suite/innodb_zip/include/innodb_fetch_records.inc

--echo # check the stats of the table & size of the table
SET @inl_val=2;
--source suite/innodb_zip/include/innodb_stats_comp_index.inc

--echo # Restarting server
-- source include/restart_mysqld.inc

--echo # set the flag on (default off)
SET GLOBAL innodb_cmp_per_index_enabled=ON;

--echo # set the flags
SET GLOBAL innodb_file_per_table=on;
SET GLOBAL innodb_file_format='barracuda';
SET GLOBAL innodb_compression_level=0;

--echo # fetch the compressed page and check the stats
--echo # The stats figure may be different/same for each restart.
--source suite/innodb_zip/include/innodb_fetch_records.inc

--echo # check the stats of the table
-- echo # testcase : pass = 1 fail = 0
SET @comp_val=0;
SET @uncomp_val=1;
--source suite/innodb_zip/include/innodb_stats_restart.inc

DROP TABLE tab5;

#******************************************************************
# innodb_cmp_per_index_enabled=ON and innodb_compression_level=0
# with page size 2K
#******************************************************************

--echo #reset the stat table before starting next testcase
SET GLOBAL innodb_cmp_per_index_enabled=0;
SET GLOBAL innodb_cmp_per_index_enabled=1;

--echo # create a table with page size=2K
--echo # create indexes on each column.(total 9 indexes)
let $block_size=2;
--source suite/innodb_zip/include/innodb_create_tab_indx.inc

--echo # check the stats of the table & size of the table
SET @inl_val=1;
--source suite/innodb_zip/include/innodb_stats_comp_index.inc

--echo # for determintic resons simple data should be inserted.
--echo #insert some 100 records
let $i = 100;
--source suite/innodb_zip/include/innodb_load_data.inc