Debian Codegraph @

mysql-test/suite/innodb_zip/r/bug52745.result

raw
1 SET @saved_innodb_strict_mode=@@SESSION.innodb_strict_mode;
2 SET GLOBAL innodb_file_per_table=on;
3 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
4 SET SESSION innodb_strict_mode=OFF;
5 CREATE TABLE bug52745 (
6 a2 int(10) unsigned DEFAULT NULL,
7 col37 time DEFAULT NULL,
8 col38 char(229) CHARACTER SET utf8 DEFAULT NULL,
9 col39 text,
10 col40 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
11 col41 int(10) unsigned DEFAULT NULL,
12 col42 varchar(248) CHARACTER SET utf8 DEFAULT NULL,
13 col43 smallint(5) unsigned zerofill DEFAULT NULL,
14 col44 varchar(150) CHARACTER SET utf8 DEFAULT NULL,
15 col45 float unsigned zerofill DEFAULT NULL,
16 col46 binary(1) DEFAULT NULL,
17 col47 tinyint(4) DEFAULT NULL,
18 col48 tinyint(1) DEFAULT NULL,
19 col49 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
20 col50 binary(1) DEFAULT NULL,
21 col51 double unsigned zerofill DEFAULT NULL,
22 col52 int(10) unsigned DEFAULT NULL,
23 col53 time DEFAULT NULL,
24 col54 double unsigned DEFAULT NULL,
25 col55 time DEFAULT NULL,
26 col56 mediumtext CHARACTER SET latin2,
27 col57 blob,
28 col58 decimal(52,16) unsigned zerofill NOT NULL DEFAULT '000000000000000000000000000000000000.0000000000000000',
29 col59 binary(1) DEFAULT NULL,
30 col60 longblob,
31 col61 time DEFAULT NULL,
32 col62 longtext CHARACTER SET utf8 COLLATE utf8_persian_ci,
33 col63 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
34 col64 int(10) unsigned DEFAULT NULL,
35 col65 date DEFAULT NULL,
36 col66 timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
37 col67 binary(1) DEFAULT NULL,
38 col68 tinyblob,
39 col69 date DEFAULT NULL,
40 col70 tinyint(3) unsigned zerofill DEFAULT NULL,
41 col71 varchar(44) CHARACTER SET utf8 DEFAULT NULL,
42 col72 datetime DEFAULT NULL,
43 col73 smallint(5) unsigned zerofill DEFAULT NULL,
44 col74 longblob,
45 col75 bit(34) DEFAULT NULL,
46 col76 float unsigned zerofill DEFAULT NULL,
47 col77 year DEFAULT NULL,
48 col78 tinyint(3) unsigned DEFAULT NULL,
49 col79 set('msfheowh','tbpxbgf','by','wahnrjw','myqfasxz','rsokyumrt') CHARACTER SET latin2 DEFAULT NULL,
50 col80 datetime DEFAULT NULL,
51 col81 smallint(6) DEFAULT NULL,
52 col82 enum('xtaurnqfqz','rifrse','kuzwpbvb','niisabk','zxavro','rbvasv','','uulrfaove','','') DEFAULT NULL,
53 col83 bigint(20) unsigned zerofill DEFAULT NULL,
54 col84 float unsigned zerofill DEFAULT NULL,
55 col85 double DEFAULT NULL,
56 col86 enum('ylannv','','vlkhycqc','snke','cxifustp','xiaxaswzp','oxl') CHARACTER SET latin1 COLLATE latin1_german2_ci DEFAULT NULL,
57 col87 varbinary(221) DEFAULT NULL,
58 col88 double unsigned DEFAULT NULL,
59 col89 float unsigned zerofill DEFAULT NULL,
60 col90 tinyblob
61 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
62 Warnings:
63 Warning 1681 Integer display width is deprecated and will be removed in a future release.
64 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.
65 Warning 1681 Integer display width is deprecated and will be removed in a future release.
66 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.
67 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.
68 Warning 1681 Integer display width is deprecated and will be removed in a future release.
69 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.
70 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.
71 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
72 Warning 1681 Integer display width is deprecated and will be removed in a future release.
73 Warning 1681 Integer display width is deprecated and will be removed in a future release.
74 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.
75 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
76 Warning 1681 Integer display width is deprecated and will be removed in a future release.
77 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
78 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.
79 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
80 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.
81 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
82 Warning 1681 Integer display width is deprecated and will be removed in a future release.
83 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.
84 Warning 1681 Integer display width is deprecated and will be removed in a future release.
85 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.
86 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.
87 Warning 1681 Integer display width is deprecated and will be removed in a future release.
88 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.
89 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
90 Warning 1681 Integer display width is deprecated and will be removed in a future release.
91 Warning 1681 Integer display width is deprecated and will be removed in a future release.
92 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.
93 Warning 1681 Integer display width is deprecated and will be removed in a future release.
94 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.
95 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
96 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
97 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.
98 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
99 Note 1291 Column 'col82' has duplicated value '' in ENUM
100 Note 1291 Column 'col82' has duplicated value '' in ENUM
101 Warning 139 Row size too large (> NNNN). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
102 SET @saved_innodb_strict_mode=@@SESSION.innodb_strict_mode;
103 SET sql_mode = (SELECT replace(@@sql_mode,'NO_ZERO_DATE',''));
104 INSERT IGNORE INTO bug52745 SET
105 col40='0000-00-00 00:00:00',
106 col51=16547,
107 col53='7711484',
108 col54=-28604,
109 col55='7112612',
110 col56='wakefulness\'',
111 col57=repeat('absorbefacient\'',106),
112 col58=11027,
113 col59='AM09gW7',
114 col60=repeat('Noelani\'',16),
115 col61='2520576',
116 col62='substitutiv',
117 col63='19950106155112',
118 col64=-12038,
119 col65='86238806',
120 col66='19600719080256',
121 col68=repeat('Sagittarius\'',54),
122 col69='38943902',
123 col70=1232,
124 col71='Elora\'',
125 col74=repeat('zipp',11),
126 col75='0',
127 col76=23254,
128 col78=13247,
129 col79='56219',
130 col80='20500609035724',
131 col81=11632,
132 col82=7,
133 col84=-23863,
134 col85=6341,
135 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',
136 col88=16894,
137 col89=6161,
138 col90=repeat('gale',48);
139 Warnings:
140 Warning 1264 Out of range value for column 'col53' at row 1
141 Warning 1264 Out of range value for column 'col54' at row 1
142 Warning 1265 Data truncated for column 'col59' at row 1
143 Warning 1264 Out of range value for column 'col61' at row 1
144 Warning 1264 Out of range value for column 'col64' at row 1
145 Warning 1265 Data truncated for column 'col65' at row 1
146 Warning 1264 Out of range value for column 'col66' at row 1
147 Warning 1265 Data truncated for column 'col68' at row 1
148 Warning 1265 Data truncated for column 'col69' at row 1
149 Warning 1264 Out of range value for column 'col70' at row 1
150 Warning 1264 Out of range value for column 'col78' at row 1
151 Warning 1265 Data truncated for column 'col79' at row 1
152 Warning 1264 Out of range value for column 'col84' at row 1
153 SHOW WARNINGS;
154 Level Code Message
155 Warning 1264 Out of range value for column 'col53' at row 1
156 Warning 1264 Out of range value for column 'col54' at row 1
157 Warning 1265 Data truncated for column 'col59' at row 1
158 Warning 1264 Out of range value for column 'col61' at row 1
159 Warning 1264 Out of range value for column 'col64' at row 1
160 Warning 1265 Data truncated for column 'col65' at row 1
161 Warning 1264 Out of range value for column 'col66' at row 1
162 Warning 1265 Data truncated for column 'col68' at row 1
163 Warning 1265 Data truncated for column 'col69' at row 1
164 Warning 1264 Out of range value for column 'col70' at row 1
165 Warning 1264 Out of range value for column 'col78' at row 1
166 Warning 1265 Data truncated for column 'col79' at row 1
167 Warning 1264 Out of range value for column 'col84' at row 1
168 SET sql_mode = default;
169 DROP TABLE bug52745;
170 SET GLOBAL innodb_file_per_table=1;