BUG#16321920 : CREATE A SEPARATE INNODB_ZIP TEST SUITE

Fix :
-------	

Created separate suites called innodb_zip ans i_innodb_zip that contain all compression tests.

Running the new suites with following compression-related parameters :

* innodb_compression_level = {1/9}
* innodb_log_compressed_pages = {ON/OFF}

1 files changed, 0 insertions, 109 deletions

diff --git a/mysql-test/suite/innodb/r/innodb_bug56680.result b/mysql-test/suite/innodb/r/innodb_bug56680.result
deleted file mode 100644
index 5e798b69167..00000000000
--- a/mysql-test/suite/innodb/r/innodb_bug56680.result
+++ /dev/null
@@ -1,109 +0,0 @@
-SET GLOBAL tx_isolation='REPEATABLE-READ';
-SET GLOBAL innodb_file_format=Barracuda;
-SET GLOBAL innodb_file_per_table=on;
-CREATE TABLE bug56680(
-a INT AUTO_INCREMENT PRIMARY KEY,
-b CHAR(1),
-c INT,
-INDEX(b))
-ENGINE=InnoDB;
-INSERT INTO bug56680 VALUES(0,'x',1);
-BEGIN;
-SELECT b FROM bug56680;
-b
-x
-BEGIN;
-UPDATE bug56680 SET b='X';
-SELECT b FROM bug56680;
-b
-x
-SELECT * FROM bug56680;
-a	b	c
-1	x	1
-ROLLBACK;
-SELECT b FROM bug56680;
-b
-x
-SET GLOBAL tx_isolation='READ-UNCOMMITTED';
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-INSERT INTO bug56680 SELECT 0,b,c FROM bug56680;
-BEGIN;
-SELECT b FROM bug56680 LIMIT 2;
-b
-x
-x
-BEGIN;
-DELETE FROM bug56680 WHERE a=1;
-INSERT INTO bug56680 VALUES(1,'X',1);
-SELECT b FROM bug56680 LIMIT 3;
-b
-X
-x
-x
-SELECT b FROM bug56680 LIMIT 2;
-b
-x
-x
-CHECK TABLE bug56680;
-Table	Op	Msg_type	Msg_text
-test.bug56680	check	status	OK
-ROLLBACK;
-SELECT b FROM bug56680 LIMIT 2;
-b
-x
-x
-CHECK TABLE bug56680;
-Table	Op	Msg_type	Msg_text
-test.bug56680	check	status	OK
-SELECT b FROM bug56680 LIMIT 2;
-b
-x
-x
-CREATE TABLE bug56680_2(
-a INT AUTO_INCREMENT PRIMARY KEY,
-b VARCHAR(2) CHARSET latin1 COLLATE latin1_german2_ci,
-c INT,
-INDEX(b))
-ENGINE=InnoDB;
-INSERT INTO bug56680_2 SELECT 0,_latin1 0xdf,c FROM bug56680;
-BEGIN;
-SELECT HEX(b) FROM bug56680_2 LIMIT 2;
-HEX(b)
-DF
-DF
-DELETE FROM bug56680_2 WHERE a=1;
-INSERT INTO bug56680_2 VALUES(1,'SS',1);
-SELECT HEX(b) FROM bug56680_2 LIMIT 3;
-HEX(b)
-5353
-DF
-DF
-CHECK TABLE bug56680_2;
-Table	Op	Msg_type	Msg_text
-test.bug56680_2	check	status	OK
-ALTER TABLE bug56680_2 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
-SELECT HEX(b) FROM bug56680_2 LIMIT 2;
-HEX(b)
-5353
-DF
-DELETE FROM bug56680_2 WHERE a=1;
-INSERT INTO bug56680_2 VALUES(1,_latin1 0xdf,1);
-SELECT HEX(b) FROM bug56680_2 LIMIT 3;
-HEX(b)
-DF
-DF
-DF
-CHECK TABLE bug56680_2;
-Table	Op	Msg_type	Msg_text
-test.bug56680_2	check	status	OK
-DROP TABLE bug56680_2;
-DROP TABLE bug56680;