mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
cf574cf53b
Some GNU/Linux distributions ship a zlib that is modified to use the s390x DFLTCC instruction. That modification would essentially redefine compressBound(sourceLen) as (sourceLen * 16 + 2308) / 8 + 6. Let us relax the tests for InnoDB ROW_FORMAT=COMPRESSED to cope with such a weaker compression guarantee. create_table_info_t::row_size_is_acceptable(): Remove a bogus debug-only assertion that would fail to hold for the test innodb_zip.bug36169. The function page_zip_empty_size() may indeed return 0.
67 lines
2.1 KiB
Text
67 lines
2.1 KiB
Text
-- source include/innodb_page_size_small.inc
|
|
|
|
CREATE TABLE bug52745 (
|
|
a2 int(10) unsigned DEFAULT NULL,
|
|
col37 time DEFAULT NULL,
|
|
col38 char(229) CHARACTER SET utf8 DEFAULT NULL,
|
|
col39 text,
|
|
col40 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
col41 int(10) unsigned DEFAULT NULL,
|
|
col42 varchar(248) CHARACTER SET utf8 DEFAULT NULL,
|
|
col43 smallint(5) unsigned zerofill DEFAULT NULL,
|
|
col44 varchar(150) CHARACTER SET utf8 DEFAULT NULL,
|
|
col45 float unsigned zerofill DEFAULT NULL,
|
|
col46 binary(1) DEFAULT NULL,
|
|
col47 tinyint(4) DEFAULT NULL,
|
|
col48 tinyint(1) DEFAULT NULL,
|
|
col49 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
col50 binary(1) DEFAULT NULL,
|
|
col51 double unsigned zerofill DEFAULT NULL,
|
|
col52 int(10) unsigned DEFAULT NULL,
|
|
col53 time DEFAULT NULL,
|
|
col54 double unsigned DEFAULT NULL,
|
|
col55 time DEFAULT NULL,
|
|
col56 mediumtext CHARACTER SET latin2,
|
|
col57 blob,
|
|
col58 decimal(52,16) unsigned zerofill NOT NULL DEFAULT '000000000000000000000000000000000000.0000000000000000',
|
|
col59 binary(1) DEFAULT NULL,
|
|
col60 longblob,
|
|
col61 time DEFAULT NULL,
|
|
col62 longtext CHARACTER SET utf8 COLLATE utf8_persian_ci,
|
|
col63 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
col64 int(10) unsigned DEFAULT NULL,
|
|
col65 date DEFAULT NULL,
|
|
col66 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
col67 binary(1) DEFAULT NULL,
|
|
col68 tinyblob,
|
|
col69 date DEFAULT NULL,
|
|
col70 tinyint(3) unsigned zerofill DEFAULT NULL,
|
|
col71 varchar(44) CHARACTER SET utf8 DEFAULT NULL,
|
|
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
|
|
col40='0000-00-00 00:00:00',
|
|
col51=16547,
|
|
col53='7711484',
|
|
col54=-28604,
|
|
col55='7112612',
|
|
col56='wakefulness\'',
|
|
col57=repeat('absorbefacient\'',106),
|
|
col58=11027,
|
|
col59='AM09gW7',
|
|
col60=repeat('Noelani\'',16),
|
|
col61='2520576',
|
|
col62='substitutiv',
|
|
col63='19950106155112',
|
|
col64=-12038,
|
|
col65='86238806',
|
|
col66='19600719080256',
|
|
col68=repeat('Sagittarius\'',54),
|
|
col69='38943902',
|
|
col70=1232,
|
|
col71='Elora\'';
|
|
|
|
SHOW WARNINGS;
|
|
|
|
DROP TABLE bug52745;
|