diff options
Diffstat (limited to 'mysql-test/suite/innodb_zip/t')
4 files changed, 28 insertions, 16 deletions
diff --git a/mysql-test/suite/innodb_zip/t/innodb_bug36169.test b/mysql-test/suite/innodb_zip/t/innodb_bug36169.test index 1d82b95a602..0c4d4c6b228 100644 --- a/mysql-test/suite/innodb_zip/t/innodb_bug36169.test +++ b/mysql-test/suite/innodb_zip/t/innodb_bug36169.test @@ -26,6 +26,7 @@ SET GLOBAL innodb_file_per_table=ON; # Creating a table with 94 columns and 24 indexes DROP TABLE IF EXISTS `table0`; set innodb_strict_mode=on; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; --error ER_TOO_BIG_ROWSIZE CREATE TABLE IF NOT EXISTS `table0` (`col0` BOOL, @@ -147,6 +148,7 @@ KEY `idx21` (`col83`(54)), KEY `idx22` (`col51`,`col7`(120)), KEY `idx23` (`col7`(163),`col31`,`col71`,`col14`) )engine=innodb ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1; +SET sql_mode = DEFAULT; # Creating a table with 10 columns and 32 indexes DROP TABLE IF EXISTS `table1`; @@ -294,7 +296,7 @@ CREATE TABLE IF NOT EXISTS `table2` `col91` TINYINT, `col92` ENUM ('test1','test2','test3'), `col93` BOOL, -`col94` TIMESTAMP, +`col94` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col95` BOOL, `col96` MEDIUMTEXT, `col97` DECIMAL, @@ -307,22 +309,22 @@ CREATE TABLE IF NOT EXISTS `table2` `col104` MEDIUMINT, `col105` DECIMAL, `col106` NUMERIC, -`col107` TIMESTAMP, +`col107` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col108` MEDIUMBLOB, `col109` TINYBLOB, `col110` SET ('test1','test2','test3'), `col111` YEAR, -`col112` TIMESTAMP, +`col112` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col113` CHAR (201), `col114` BOOL, `col115` TINYINT, `col116` DOUBLE, `col117` TINYINT, -`col118` TIMESTAMP, +`col118` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col119` SET ('test1','test2','test3'), `col120` SMALLINT, `col121` TINYBLOB, -`col122` TIMESTAMP, +`col122` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col123` BLOB, `col124` DATE, `col125` SMALLINT, @@ -546,7 +548,7 @@ CREATE TABLE IF NOT EXISTS `table3` `col178` MEDIUMINT, `col179` TINYBLOB, `col180` FLOAT, -`col181` TIMESTAMP, +`col181` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col182` REAL, `col183` DOUBLE PRECISION, `col184` BIGINT, @@ -701,7 +703,7 @@ CREATE TABLE IF NOT EXISTS `table4` `col127` TINYTEXT, `col128` BOOL, `col129` NUMERIC, -`col130` TIMESTAMP, +`col130` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col131` INT, `col132` MEDIUMBLOB, KEY `idx0` (`col130`), @@ -820,8 +822,8 @@ CREATE TABLE IF NOT EXISTS `table5` `col91` FLOAT, `col92` DATETIME, `col93` TINYTEXT, -`col94` TIMESTAMP, -`col95` TIMESTAMP, +`col94` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, +`col95` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col96` TEXT, `col97` REAL, `col98` VARCHAR (198), @@ -832,7 +834,7 @@ CREATE TABLE IF NOT EXISTS `table5` `col103` LONGBLOB, `col104` MEDIUMINT, `col105` MEDIUMTEXT, -`col106` TIMESTAMP, +`col106` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col107` SMALLINT, `col108` NUMERIC, `col109` DECIMAL, @@ -891,7 +893,7 @@ CREATE TABLE IF NOT EXISTS `table5` `col162` DOUBLE PRECISION, `col163` BLOB, `col164` ENUM ('test1','test2','test3'), -`col165` TIMESTAMP, +`col165` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col166` DATE, `col167` TINYBLOB, `col168` TINYBLOB, @@ -936,7 +938,7 @@ CREATE TABLE IF NOT EXISTS `table6` `col11` DOUBLE, `col12` DOUBLE, `col13` SMALLINT, -`col14` TIMESTAMP, +`col14` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col15` DECIMAL, `col16` DATE, `col17` TEXT, @@ -958,7 +960,7 @@ CREATE TABLE IF NOT EXISTS `table6` `col33` FLOAT, `col34` TEXT, `col35` DATE, -`col36` TIMESTAMP, +`col36` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col37` REAL, `col38` BLOB, `col39` BLOB, @@ -968,7 +970,7 @@ CREATE TABLE IF NOT EXISTS `table6` `col43` TINYINT, `col44` REAL, `col45` BIGINT, -`col46` TIMESTAMP, +`col46` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col47` BLOB, `col48` ENUM ('test1','test2','test3'), `col49` BOOL, @@ -1051,7 +1053,7 @@ CREATE TABLE IF NOT EXISTS `table6` `col126` BLOB, `col127` REAL, `col128` MEDIUMBLOB, -`col129` TIMESTAMP, +`col129` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `col130` LONGBLOB, `col131` MEDIUMBLOB, `col132` YEAR, diff --git a/mysql-test/suite/innodb_zip/t/innodb_bug36172.test b/mysql-test/suite/innodb_zip/t/innodb_bug36172.test index 015f461e532..f649f8d521f 100644 --- a/mysql-test/suite/innodb_zip/t/innodb_bug36172.test +++ b/mysql-test/suite/innodb_zip/t/innodb_bug36172.test @@ -20,7 +20,9 @@ SET GLOBAL innodb_file_format='Barracuda'; SET GLOBAL innodb_file_per_table=on; DROP TABLE IF EXISTS `table0`; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE `table0` ( `col0` tinyint(1) DEFAULT NULL, `col1` tinyint(1) DEFAULT NULL, `col2` tinyint(4) DEFAULT NULL, `col3` date DEFAULT NULL, `col4` time DEFAULT NULL, `col5` set('test1','test2','test3') DEFAULT NULL, `col6` time DEFAULT NULL, `col7` text, `col8` decimal(10,0) DEFAULT NULL, `col9` set('test1','test2','test3') DEFAULT NULL, `col10` float DEFAULT NULL, `col11` double DEFAULT NULL, `col12` enum('test1','test2','test3') DEFAULT NULL, `col13` tinyblob, `col14` year(4) DEFAULT NULL, `col15` set('test1','test2','test3') DEFAULT NULL, `col16` decimal(10,0) DEFAULT NULL, `col17` decimal(10,0) DEFAULT NULL, `col18` blob, `col19` datetime DEFAULT NULL, `col20` double DEFAULT NULL, `col21` decimal(10,0) DEFAULT NULL, `col22` datetime DEFAULT NULL, `col23` decimal(10,0) DEFAULT NULL, `col24` decimal(10,0) DEFAULT NULL, `col25` longtext, `col26` tinyblob, `col27` time DEFAULT NULL, `col28` tinyblob, `col29` enum('test1','test2','test3') DEFAULT NULL, `col30` smallint(6) DEFAULT NULL, `col31` double DEFAULT NULL, `col32` float DEFAULT NULL, `col33` char(175) DEFAULT NULL, `col34` tinytext, `col35` tinytext, `col36` tinyblob, `col37` tinyblob, `col38` tinytext, `col39` mediumblob, `col40` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `col41` double DEFAULT NULL, `col42` smallint(6) DEFAULT NULL, `col43` longblob, `col44` varchar(80) DEFAULT NULL, `col45` mediumtext, `col46` decimal(10,0) DEFAULT NULL, `col47` bigint(20) DEFAULT NULL, `col48` date DEFAULT NULL, `col49` tinyblob, `col50` date DEFAULT NULL, `col51` tinyint(1) DEFAULT NULL, `col52` mediumint(9) DEFAULT NULL, `col53` float DEFAULT NULL, `col54` tinyblob, `col55` longtext, `col56` smallint(6) DEFAULT NULL, `col57` enum('test1','test2','test3') DEFAULT NULL, `col58` datetime DEFAULT NULL, `col59` mediumtext, `col60` varchar(232) DEFAULT NULL, `col61` decimal(10,0) DEFAULT NULL, `col62` year(4) DEFAULT NULL, `col63` smallint(6) DEFAULT NULL, `col64` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `col65` blob, `col66` longblob, `col67` int(11) DEFAULT NULL, `col68` longtext, `col69` enum('test1','test2','test3') DEFAULT NULL, `col70` int(11) DEFAULT NULL, `col71` time DEFAULT NULL, `col72` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `col73` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `col74` varchar(170) DEFAULT NULL, `col75` set('test1','test2','test3') DEFAULT NULL, `col76` tinyblob, `col77` bigint(20) DEFAULT NULL, `col78` decimal(10,0) DEFAULT NULL, `col79` datetime DEFAULT NULL, `col80` year(4) DEFAULT NULL, `col81` decimal(10,0) DEFAULT NULL, `col82` longblob, `col83` text, `col84` char(83) DEFAULT NULL, `col85` decimal(10,0) DEFAULT NULL, `col86` float DEFAULT NULL, `col87` int(11) DEFAULT NULL, `col88` varchar(145) DEFAULT NULL, `col89` date DEFAULT NULL, `col90` decimal(10,0) DEFAULT NULL, `col91` decimal(10,0) DEFAULT NULL, `col92` mediumblob, `col93` time DEFAULT NULL, KEY `idx0` (`col69`,`col90`,`col8`), KEY `idx1` (`col60`), KEY `idx2` (`col60`,`col70`,`col74`), KEY `idx3` (`col22`,`col32`,`col72`,`col30`), KEY `idx4` (`col29`), KEY `idx5` (`col19`,`col45`(143)), KEY `idx6` (`col46`,`col48`,`col5`,`col39`(118)), KEY `idx7` (`col48`,`col61`), KEY `idx8` (`col93`), KEY `idx9` (`col31`), KEY `idx10` (`col30`,`col21`), KEY `idx11` (`col67`), KEY `idx12` (`col44`,`col6`,`col8`,`col38`(226)), KEY `idx13` (`col71`,`col41`,`col15`,`col49`(88)), KEY `idx14` (`col78`), KEY `idx15` (`col63`,`col67`,`col64`), KEY `idx16` (`col17`,`col86`), KEY `idx17` (`col77`,`col56`,`col10`,`col55`(24)), KEY `idx18` (`col62`), KEY `idx19` (`col31`,`col57`,`col56`,`col53`), KEY `idx20` (`col46`), KEY `idx21` (`col83`(54)), KEY `idx22` (`col51`,`col7`(120)), KEY `idx23` (`col7`(163),`col31`,`col71`,`col14`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2; +SET sql_mode = DEFAULT; insert ignore into `table0` set `col23` = 7887371.5084383683, `col24` = 4293854615.6906948000, `col25` = 'vitalist', `col26` = 'widespread', `col27` = '3570490', `col28` = 'habitual', `col30` = -5471, `col31` = 4286985783.6771750000, `col32` = 6354540.9826654866, `col33` = 'defoliation', `col34` = 'logarithms', `col35` = 'tegument\'s', `col36` = 'scouting\'s', `col37` = 'intermittency', `col38` = 'elongates', `col39` = 'prophecies', `col40` = '20560103035939', `col41` = 4292809130.0544143000, `col42` = 22057, `col43` = 'Hess\'s', `col44` = 'bandstand', `col45` = 'phenylketonuria', `col46` = 6338767.4018677324, `col47` = 5310247, `col48` = '12592418', `col49` = 'churchman\'s', `col50` = '32226125', `col51` = -58, `col52` = -6207968, `col53` = 1244839.3255104220, `col54` = 'robotized', `col55` = 'monotonous', `col56` = -26909, `col58` = '20720107023550', `col59` = 'suggestiveness\'s', `col60` = 'gemology', `col61` = 4287800670.2229986000, `col62` = '1944', `col63` = -16827, `col64` = '20700107212324', `col65` = 'Nicolais', `col66` = 'apteryx', `col67` = 6935317, `col68` = 'stroganoff', `col70` = 3316430, `col71` = '3277608', `col72` = '19300511045918', `col73` = '20421201003327', `col74` = 'attenuant', `col75` = '15173', `col76` = 'upstroke\'s', `col77` = 8118987, `col78` = 6791516.2735374002, `col79` = '20780701144624', `col80` = '2134', `col81` = 4290682351.3127537000, `col82` = 'unexplainably', `col83` = 'Storm', `col84` = 'Greyso\'s', `col85` = 4289119212.4306774000, `col86` = 7617575.8796655172, `col87` = -6325335, `col88` = 'fondue\'s', `col89` = '40608940', `col90` = 1659421.8093508712, `col91` = 8346904.6584368423, `col92` = 'reloads', `col93` = '5188366'; CHECK TABLE table0 EXTENDED; INSERT IGNORE INTO `table0` SET `col19` = '19940127002709', `col20` = 2383927.9055146948, `col21` = 4293243420.5621204000, `col22` = '20511211123705', `col23` = 4289899778.6573381000, `col24` = 4293449279.0540481000, `col25` = 'emphysemic', `col26` = 'dentally', `col27` = '2347406', `col28` = 'eruct', `col30` = 1222, `col31` = 4294372994.9941406000, `col32` = 4291385574.1173744000, `col33` = 'borrowing\'s', `col34` = 'septics', `col35` = 'ratter\'s', `col36` = 'Kaye', `col37` = 'Florentia', `col38` = 'allium', `col39` = 'barkeep', `col40` = '19510407003441', `col41` = 4293559200.4215522000, `col42` = 22482, `col43` = 'decussate', `col44` = 'Brom\'s', `col45` = 'violated', `col46` = 4925506.4635456400, `col47` = 930549, `col48` = '51296066', `col49` = 'voluminously', `col50` = '29306676', `col51` = -88, `col52` = -2153690, `col53` = 4290250202.1464887000, `col54` = 'expropriation', `col55` = 'Aberdeen\'s', `col56` = 20343, `col58` = '19640415171532', `col59` = 'extern', `col60` = 'Ubana', `col61` = 4290487961.8539081000, `col62` = '2147', `col63` = -24271, `col64` = '20750801194548', `col65` = 'Cunaxa\'s', `col66` = 'pasticcio', `col67` = 2795817, `col68` = 'Indore\'s', `col70` = 6864127, `col71` = '1817832', `col72` = '20540506114211', `col73` = '20040101012300', `col74` = 'rationalized', `col75` = '45522', `col76` = 'indene', `col77` = -6964559, `col78` = 4247535.5266884370, `col79` = '20720416124357', `col80` = '2143', `col81` = 4292060102.4466386000, `col82` = 'striving', `col83` = 'boneblack\'s', `col84` = 'redolent', `col85` = 6489697.9009369183, `col86` = 4287473465.9731131000, `col87` = 7726015, `col88` = 'perplexed', `col89` = '17153791', `col90` = 5478587.1108127078, `col91` = 4287091404.7004304000, `col92` = 'Boulez\'s', `col93` = '2931278'; diff --git a/mysql-test/suite/innodb_zip/t/innodb_bug52745.test b/mysql-test/suite/innodb_zip/t/innodb_bug52745.test index 3c5d79826f0..b210afc7d1f 100644 --- a/mysql-test/suite/innodb_zip/t/innodb_bug52745.test +++ b/mysql-test/suite/innodb_zip/t/innodb_bug52745.test @@ -5,6 +5,7 @@ let $file_per_table=`select @@innodb_file_per_table`; SET GLOBAL innodb_file_format='Barracuda'; 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, @@ -62,8 +63,9 @@ CREATE TABLE bug52745 ( col89 float unsigned zerofill DEFAULT NULL, col90 tinyblob ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1; +SET sql_mode = DEFAULT; -INSERT INTO bug52745 SET +INSERT IGNORE INTO bug52745 SET col40='0000-00-00 00:00:00', col51=16547, col53='7711484', diff --git a/mysql-test/suite/innodb_zip/t/innodb_index_large_prefix.test b/mysql-test/suite/innodb_zip/t/innodb_index_large_prefix.test index 8af2bc7ffc7..93beea6c80f 100644 --- a/mysql-test/suite/innodb_zip/t/innodb_index_large_prefix.test +++ b/mysql-test/suite/innodb_zip/t/innodb_index_large_prefix.test @@ -140,6 +140,7 @@ create table worklog5743_16(a1 int, a2 TEXT, a3 TEXT) KEY_BLOCK_SIZE=16; # See page_zip_empty_size() and Bug #47495 for more detail. # Test edge cases for indexes using key_block_size=1 +set sql_mode=''; set global innodb_large_prefix=0; -- error ER_TOO_BIG_ROWSIZE create index idx1 on worklog5743_1(a2(4000)); @@ -242,6 +243,7 @@ create index idx6 on worklog5743_16(a1, a2(2000), a3(1069)); show warnings; create index idx7 on worklog5743_16(a1, a2(2000), a3(1068)); show warnings; +set sql_mode=default; # Insert a large record into each of these tables. insert into worklog5743_1 values(9, repeat("a", 10000)); @@ -325,6 +327,7 @@ create table worklog5743(a1 int, a5 varchar(3069), a6 varchar(3068)) ROW_FORMAT=DYNAMIC; +set sql_mode=''; create index idx1 on worklog5743(a2); create index idx2 on worklog5743(a3); create index idx3 on worklog5743(a4); @@ -338,6 +341,7 @@ show warnings; create index idx6 on worklog5743(a1, a6); show warnings; show create table worklog5743; +set sql_mode=default; insert into worklog5743 values(9, repeat("a", 20000), repeat("a", 3073), @@ -409,7 +413,9 @@ create table worklog5743(a TEXT not null) ROW_FORMAT=DYNAMIC; # Length exceeds maximum supported key length # It will be auto-truncated to 3072 +set sql_mode=''; create index idx1 on worklog5743(a(3073)); +set sql_mode=default; create index idx2 on worklog5743(a(3072)); show create table worklog5743; drop table worklog5743; |