167 lines
10 KiB
Plaintext
167 lines
10 KiB
Plaintext
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,
|
|
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,
|
|
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
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
|
|
Warnings:
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
Warning 3778 'utf8_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Note 1291 Column 'col82' has duplicated value '' in ENUM
|
|
Note 1291 Column 'col82' has duplicated value '' in ENUM
|
|
SET sql_mode = (SELECT replace(@@sql_mode,'NO_ZERO_DATE',''));
|
|
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\'',
|
|
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);
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'col53' at row 1
|
|
Warning 1264 Out of range value for column 'col54' at row 1
|
|
Warning 1265 Data truncated for column 'col59' at row 1
|
|
Warning 1264 Out of range value for column 'col61' at row 1
|
|
Warning 1264 Out of range value for column 'col64' at row 1
|
|
Warning 1265 Data truncated for column 'col65' at row 1
|
|
Warning 1264 Out of range value for column 'col66' at row 1
|
|
Warning 1265 Data truncated for column 'col68' at row 1
|
|
Warning 1265 Data truncated for column 'col69' at row 1
|
|
Warning 1264 Out of range value for column 'col70' at row 1
|
|
Warning 1264 Out of range value for column 'col78' at row 1
|
|
Warning 1265 Data truncated for column 'col79' at row 1
|
|
Warning 1264 Out of range value for column 'col84' at row 1
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Warning 1264 Out of range value for column 'col53' at row 1
|
|
Warning 1264 Out of range value for column 'col54' at row 1
|
|
Warning 1265 Data truncated for column 'col59' at row 1
|
|
Warning 1264 Out of range value for column 'col61' at row 1
|
|
Warning 1264 Out of range value for column 'col64' at row 1
|
|
Warning 1265 Data truncated for column 'col65' at row 1
|
|
Warning 1264 Out of range value for column 'col66' at row 1
|
|
Warning 1265 Data truncated for column 'col68' at row 1
|
|
Warning 1265 Data truncated for column 'col69' at row 1
|
|
Warning 1264 Out of range value for column 'col70' at row 1
|
|
Warning 1264 Out of range value for column 'col78' at row 1
|
|
Warning 1265 Data truncated for column 'col79' at row 1
|
|
Warning 1264 Out of range value for column 'col84' at row 1
|
|
SET sql_mode = default;
|
|
DROP TABLE bug52745;
|
|
SET GLOBAL innodb_file_per_table=1;
|