summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_zip/t/bug52745.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb_zip/t/bug52745.test')
-rw-r--r--mysql-test/suite/innodb_zip/t/bug52745.test41
1 files changed, 2 insertions, 39 deletions
diff --git a/mysql-test/suite/innodb_zip/t/bug52745.test b/mysql-test/suite/innodb_zip/t/bug52745.test
index be4b5c2bfcb..b642479f093 100644
--- a/mysql-test/suite/innodb_zip/t/bug52745.test
+++ b/mysql-test/suite/innodb_zip/t/bug52745.test
@@ -1,8 +1,5 @@
-- source include/innodb_page_size_small.inc
-let $file_per_table=`select @@innodb_file_per_table`;
-SET GLOBAL innodb_file_per_table=on;
-SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
CREATE TABLE bug52745 (
a2 int(10) unsigned DEFAULT NULL,
col37 time DEFAULT NULL,
@@ -40,25 +37,7 @@ CREATE TABLE bug52745 (
col69 date DEFAULT NULL,
col70 tinyint(3) unsigned zerofill DEFAULT NULL,
col71 varchar(44) CHARACTER SET utf8 DEFAULT NULL,
- col72 datetime DEFAULT NULL,
- col73 smallint(5) unsigned zerofill DEFAULT NULL,
- col74 longblob,
- col75 bit(34) DEFAULT NULL,
- col76 float unsigned zerofill DEFAULT NULL,
- col77 year(4) DEFAULT NULL,
- col78 tinyint(3) unsigned DEFAULT NULL,
- col79 set('msfheowh','tbpxbgf','by','wahnrjw','myqfasxz','rsokyumrt') CHARACTER SET latin2 DEFAULT NULL,
- col80 datetime DEFAULT NULL,
- col81 smallint(6) DEFAULT NULL,
- col82 enum('xtaurnqfqz','rifrse','kuzwpbvb','niisabk','zxavro','rbvasv','','uulrfaove','','') DEFAULT NULL,
- col83 bigint(20) unsigned zerofill DEFAULT NULL,
- col84 float unsigned zerofill DEFAULT NULL,
- col85 double DEFAULT NULL,
- col86 enum('ylannv','','vlkhycqc','snke','cxifustp','xiaxaswzp','oxl') CHARACTER SET latin1 COLLATE latin1_german2_ci DEFAULT NULL,
- col87 varbinary(221) DEFAULT NULL,
- col88 double unsigned DEFAULT NULL,
- col89 float unsigned zerofill DEFAULT NULL,
- col90 tinyblob
+ col72 datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
SET sql_mode = default;
INSERT IGNORE INTO bug52745 SET
@@ -81,24 +60,8 @@ col66='19600719080256',
col68=repeat('Sagittarius\'',54),
col69='38943902',
col70=1232,
-col71='Elora\'',
-col74=repeat('zipp',11),
-col75='0',
-col76=23254,
-col78=13247,
-col79='56219',
-col80='20500609035724',
-col81=11632,
-col82=7,
-col84=-23863,
-col85=6341,
-col87='HZdkf.4 s7t,5Rmq 8so fmr,ruGLUG25TrtI.yQ 2SuHq0ML7rw7.4 b2yf2E5TJxOtBBZImezDnzpj,uPYfznnEUDN1e9aQoO 2DsplB7TFWy oQJ br HLF :F,eQ p4i1oWsr lL3PG,hjCz6hYqN h1QTjLCjrv:QCdSzpYBibJAtZCxLOk3l6Blsh.W',
-col88=16894,
-col89=6161,
-col90=repeat('gale',48);
+col71='Elora\'';
SHOW WARNINGS;
DROP TABLE bug52745;
-
-EVAL SET GLOBAL innodb_file_per_table=$file_per_table;