| 1 |
DROP DATABASE IF EXISTS test1; |
| 2 |
CREATE DATABASE test1 charset latin1; |
| 3 |
USE test; |
| 4 |
drop table if exists tb1 ; |
| 5 |
create table tb1 ( |
| 6 |
f1 char(0), |
| 7 |
f2 char(0) binary, |
| 8 |
f3 char(0) ascii, |
| 9 |
f4 tinytext, |
| 10 |
f5 text, |
| 11 |
f6 mediumtext, |
| 12 |
f7 longtext, |
| 13 |
f8 tinyblob, |
| 14 |
f9 blob, |
| 15 |
f10 mediumblob, |
| 16 |
f11 longblob, |
| 17 |
f12 binary, |
| 18 |
f13 tinyint, |
| 19 |
f14 tinyint unsigned, |
| 20 |
f15 tinyint zerofill, |
| 21 |
f16 tinyint unsigned zerofill, |
| 22 |
f17 smallint, |
| 23 |
f18 smallint unsigned, |
| 24 |
f19 smallint zerofill, |
| 25 |
f20 smallint unsigned zerofill, |
| 26 |
f21 mediumint, |
| 27 |
f22 mediumint unsigned, |
| 28 |
f23 mediumint zerofill, |
| 29 |
f24 mediumint unsigned zerofill, |
| 30 |
f25 int, |
| 31 |
f26 int unsigned, |
| 32 |
f27 int zerofill, |
| 33 |
f28 int unsigned zerofill, |
| 34 |
f29 bigint, |
| 35 |
f30 bigint unsigned, |
| 36 |
f31 bigint zerofill, |
| 37 |
f32 bigint unsigned zerofill, |
| 38 |
f33 decimal, |
| 39 |
f34 decimal unsigned, |
| 40 |
f35 decimal zerofill, |
| 41 |
f36 decimal unsigned zerofill not null DEFAULT 9.9, |
| 42 |
f37 decimal (0) not null DEFAULT 9.9, |
| 43 |
f38 decimal (64) not null DEFAULT 9.9, |
| 44 |
f39 decimal (0) unsigned not null DEFAULT 9.9, |
| 45 |
f40 decimal (64) unsigned not null DEFAULT 9.9, |
| 46 |
f41 decimal (0) zerofill not null DEFAULT 9.9, |
| 47 |
f42 decimal (64) zerofill not null DEFAULT 9.9, |
| 48 |
f43 decimal (0) unsigned zerofill not null DEFAULT 9.9, |
| 49 |
f44 decimal (64) unsigned zerofill not null DEFAULT 9.9, |
| 50 |
f45 decimal (0,0) not null DEFAULT 9.9, |
| 51 |
f46 decimal (63,30) not null DEFAULT 9.9, |
| 52 |
f47 decimal (0,0) unsigned not null DEFAULT 9.9, |
| 53 |
f48 decimal (63,30) unsigned not null DEFAULT 9.9, |
| 54 |
f49 decimal (0,0) zerofill not null DEFAULT 9.9, |
| 55 |
f50 decimal (63,30) zerofill not null DEFAULT 9.9, |
| 56 |
f51 decimal (0,0) unsigned zerofill not null DEFAULT 9.9, |
| 57 |
f52 decimal (63,30) unsigned zerofill not null DEFAULT 9.9, |
| 58 |
f53 numeric not null DEFAULT 99, |
| 59 |
f54 numeric unsigned not null DEFAULT 99, |
| 60 |
f55 numeric zerofill not null DEFAULT 99, |
| 61 |
f56 numeric unsigned zerofill not null DEFAULT 99, |
| 62 |
f57 numeric (0) not null DEFAULT 99, |
| 63 |
f58 numeric (64) not null DEFAULT 99 |
| 64 |
) charset latin1 engine = innodb; |
| 65 |
Warnings: |
| 66 |
Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead |
| 67 |
Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead |
| 68 |
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. |
| 69 |
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. |
| 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 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. |
| 72 |
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. |
| 73 |
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. |
| 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 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. |
| 76 |
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. |
| 77 |
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. |
| 78 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 79 |
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. |
| 80 |
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. |
| 81 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 82 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 83 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 84 |
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. |
| 85 |
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. |
| 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 UNSIGNED for decimal and floating point data types is deprecated and support for it 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 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 91 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it 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 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. |
| 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 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. |
| 97 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 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 |
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. |
| 100 |
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. |
| 101 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 102 |
Note 1265 Data truncated for column 'f36' at row 1 |
| 103 |
Note 1265 Data truncated for column 'f37' at row 1 |
| 104 |
Note 1265 Data truncated for column 'f38' at row 1 |
| 105 |
Note 1265 Data truncated for column 'f39' at row 1 |
| 106 |
Note 1265 Data truncated for column 'f40' at row 1 |
| 107 |
Note 1265 Data truncated for column 'f41' at row 1 |
| 108 |
Note 1265 Data truncated for column 'f42' at row 1 |
| 109 |
Note 1265 Data truncated for column 'f43' at row 1 |
| 110 |
Note 1265 Data truncated for column 'f44' at row 1 |
| 111 |
Note 1265 Data truncated for column 'f45' at row 1 |
| 112 |
Note 1265 Data truncated for column 'f47' at row 1 |
| 113 |
Note 1265 Data truncated for column 'f49' at row 1 |
| 114 |
Note 1265 Data truncated for column 'f51' at row 1 |
| 115 |
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb1.txt' |
| 116 |
into table tb1 CHARACTER SET latin1; |
| 117 |
drop table if exists tb2 ; |
| 118 |
create table tb2 ( |
| 119 |
f59 numeric (0) unsigned, |
| 120 |
f60 numeric (64) unsigned, |
| 121 |
f61 numeric (0) zerofill, |
| 122 |
f62 numeric (64) zerofill, |
| 123 |
f63 numeric (0) unsigned zerofill, |
| 124 |
f64 numeric (64) unsigned zerofill, |
| 125 |
f65 numeric (0,0), |
| 126 |
f66 numeric (63,30), |
| 127 |
f67 numeric (0,0) unsigned, |
| 128 |
f68 numeric (63,30) unsigned, |
| 129 |
f69 numeric (0,0) zerofill, |
| 130 |
f70 numeric (63,30) zerofill, |
| 131 |
f71 numeric (0,0) unsigned zerofill, |
| 132 |
f72 numeric (63,30) unsigned zerofill, |
| 133 |
f73 real, |
| 134 |
f74 real unsigned, |
| 135 |
f75 real zerofill, |
| 136 |
f76 real unsigned zerofill, |
| 137 |
f77 double default 7.7, |
| 138 |
f78 double unsigned default 7.7, |
| 139 |
f79 double zerofill default 7.7, |
| 140 |
f80 double unsigned zerofill default 8.8, |
| 141 |
f81 float not null default 8.8, |
| 142 |
f82 float unsigned not null default 8.8, |
| 143 |
f83 float zerofill not null default 8.8, |
| 144 |
f84 float unsigned zerofill not null default 8.8, |
| 145 |
f85 float(0) not null default 8.8, |
| 146 |
f86 float(23) not null default 8.8, |
| 147 |
f87 float(0) unsigned not null default 8.8, |
| 148 |
f88 float(23) unsigned not null default 8.8, |
| 149 |
f89 float(0) zerofill not null default 8.8, |
| 150 |
f90 float(23) zerofill not null default 8.8, |
| 151 |
f91 float(0) unsigned zerofill not null default 8.8, |
| 152 |
f92 float(23) unsigned zerofill not null default 8.8, |
| 153 |
f93 float(24) not null default 8.8, |
| 154 |
f94 float(53) not null default 8.8, |
| 155 |
f95 float(24) unsigned not null default 8.8, |
| 156 |
f96 float(53) unsigned not null default 8.8, |
| 157 |
f97 float(24) zerofill not null default 8.8, |
| 158 |
f98 float(53) zerofill not null default 8.8, |
| 159 |
f99 float(24) unsigned zerofill not null default 8.8, |
| 160 |
f100 float(53) unsigned zerofill not null default 8.8, |
| 161 |
f101 date not null default '2000-01-01', |
| 162 |
f102 time not null default 20, |
| 163 |
f103 datetime not null default '2/2/2', |
| 164 |
f104 timestamp not null default 20001231235959, |
| 165 |
f105 year not null default 2000, |
| 166 |
f108 enum("1enum","2enum") not null default "1enum", |
| 167 |
f109 set("1set","2set") not null default "1set" |
| 168 |
) charset latin1 engine = innodb; |
| 169 |
Warnings: |
| 170 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 171 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 172 |
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. |
| 173 |
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. |
| 174 |
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. |
| 175 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 176 |
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. |
| 177 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 178 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 179 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 180 |
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. |
| 181 |
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. |
| 182 |
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. |
| 183 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 184 |
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. |
| 185 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 186 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 187 |
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. |
| 188 |
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. |
| 189 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 190 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 191 |
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. |
| 192 |
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. |
| 193 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 194 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 195 |
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. |
| 196 |
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. |
| 197 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 198 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 199 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 200 |
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. |
| 201 |
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. |
| 202 |
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. |
| 203 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 204 |
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. |
| 205 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 206 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 207 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 208 |
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. |
| 209 |
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. |
| 210 |
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. |
| 211 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 212 |
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. |
| 213 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 214 |
Warning 4095 Delimiter '/' in position 1 in datetime value '2/2/2' at row 1 is deprecated. Prefer the standard '-'. |
| 215 |
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb2.txt' |
| 216 |
into table tb2 CHARACTER SET latin1 ; |
| 217 |
drop table if exists tb3 ; |
| 218 |
create table tb3 ( |
| 219 |
f118 char not null DEFAULT 'a', |
| 220 |
f119 char binary not null DEFAULT b'101', |
| 221 |
f120 char ascii not null DEFAULT b'101', |
| 222 |
f121 tinytext, |
| 223 |
f122 text, |
| 224 |
f123 mediumtext, |
| 225 |
f124 longtext, |
| 226 |
f125 tinyblob, |
| 227 |
f126 blob, |
| 228 |
f127 mediumblob, |
| 229 |
f128 longblob, |
| 230 |
f129 binary not null DEFAULT b'101', |
| 231 |
f130 tinyint not null DEFAULT 99, |
| 232 |
f131 tinyint unsigned not null DEFAULT 99, |
| 233 |
f132 tinyint zerofill not null DEFAULT 99, |
| 234 |
f133 tinyint unsigned zerofill not null DEFAULT 99, |
| 235 |
f134 smallint not null DEFAULT 999, |
| 236 |
f135 smallint unsigned not null DEFAULT 999, |
| 237 |
f136 smallint zerofill not null DEFAULT 999, |
| 238 |
f137 smallint unsigned zerofill not null DEFAULT 999, |
| 239 |
f138 mediumint not null DEFAULT 9999, |
| 240 |
f139 mediumint unsigned not null DEFAULT 9999, |
| 241 |
f140 mediumint zerofill not null DEFAULT 9999, |
| 242 |
f141 mediumint unsigned zerofill not null DEFAULT 9999, |
| 243 |
f142 int not null DEFAULT 99999, |
| 244 |
f143 int unsigned not null DEFAULT 99999, |
| 245 |
f144 int zerofill not null DEFAULT 99999, |
| 246 |
f145 int unsigned zerofill not null DEFAULT 99999, |
| 247 |
f146 bigint not null DEFAULT 999999, |
| 248 |
f147 bigint unsigned not null DEFAULT 999999, |
| 249 |
f148 bigint zerofill not null DEFAULT 999999, |
| 250 |
f149 bigint unsigned zerofill not null DEFAULT 999999, |
| 251 |
f150 decimal not null DEFAULT 999.999, |
| 252 |
f151 decimal unsigned not null DEFAULT 999.17, |
| 253 |
f152 decimal zerofill not null DEFAULT 999.999, |
| 254 |
f153 decimal unsigned zerofill, |
| 255 |
f154 decimal (0), |
| 256 |
f155 decimal (64), |
| 257 |
f156 decimal (0) unsigned, |
| 258 |
f157 decimal (64) unsigned, |
| 259 |
f158 decimal (0) zerofill, |
| 260 |
f159 decimal (64) zerofill, |
| 261 |
f160 decimal (0) unsigned zerofill, |
| 262 |
f161 decimal (64) unsigned zerofill, |
| 263 |
f162 decimal (0,0), |
| 264 |
f163 decimal (63,30), |
| 265 |
f164 decimal (0,0) unsigned, |
| 266 |
f165 decimal (63,30) unsigned, |
| 267 |
f166 decimal (0,0) zerofill, |
| 268 |
f167 decimal (63,30) zerofill, |
| 269 |
f168 decimal (0,0) unsigned zerofill, |
| 270 |
f169 decimal (63,30) unsigned zerofill, |
| 271 |
f170 numeric, |
| 272 |
f171 numeric unsigned, |
| 273 |
f172 numeric zerofill, |
| 274 |
f173 numeric unsigned zerofill, |
| 275 |
f174 numeric (0), |
| 276 |
f175 numeric (64) |
| 277 |
) charset latin1 engine = innodb; |
| 278 |
Warnings: |
| 279 |
Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead |
| 280 |
Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead |
| 281 |
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. |
| 282 |
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. |
| 283 |
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. |
| 284 |
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. |
| 285 |
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. |
| 286 |
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. |
| 287 |
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. |
| 288 |
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. |
| 289 |
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. |
| 290 |
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. |
| 291 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 292 |
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. |
| 293 |
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. |
| 294 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 295 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 296 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 297 |
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. |
| 298 |
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. |
| 299 |
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. |
| 300 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 301 |
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. |
| 302 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 303 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 304 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 305 |
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. |
| 306 |
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. |
| 307 |
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. |
| 308 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 309 |
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. |
| 310 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 311 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 312 |
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. |
| 313 |
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. |
| 314 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 315 |
Note 1265 Data truncated for column 'f150' at row 1 |
| 316 |
Note 1265 Data truncated for column 'f151' at row 1 |
| 317 |
Note 1265 Data truncated for column 'f152' at row 1 |
| 318 |
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb3.txt' |
| 319 |
into table tb3 CHARACTER SET latin1; |
| 320 |
drop table if exists tb4; |
| 321 |
create table tb4 ( |
| 322 |
f176 numeric (0) unsigned not null DEFAULT 9, |
| 323 |
f177 numeric (64) unsigned not null DEFAULT 9, |
| 324 |
f178 numeric (0) zerofill not null DEFAULT 9, |
| 325 |
f179 numeric (64) zerofill not null DEFAULT 9, |
| 326 |
f180 numeric (0) unsigned zerofill not null DEFAULT 9, |
| 327 |
f181 numeric (64) unsigned zerofill not null DEFAULT 9, |
| 328 |
f182 numeric (0,0) not null DEFAULT 9, |
| 329 |
f183 numeric (63,30) not null DEFAULT 9, |
| 330 |
f184 numeric (0,0) unsigned not null DEFAULT 9, |
| 331 |
f185 numeric (63,30) unsigned not null DEFAULT 9, |
| 332 |
f186 numeric (0,0) zerofill not null DEFAULT 9, |
| 333 |
f187 numeric (63,30) zerofill not null DEFAULT 9, |
| 334 |
f188 numeric (0,0) unsigned zerofill not null DEFAULT 9, |
| 335 |
f189 numeric (63,30) unsigned zerofill not null DEFAULT 9, |
| 336 |
f190 real not null DEFAULT 88.8, |
| 337 |
f191 real unsigned not null DEFAULT 88.8, |
| 338 |
f192 real zerofill not null DEFAULT 88.8, |
| 339 |
f193 real unsigned zerofill not null DEFAULT 88.8, |
| 340 |
f194 double not null DEFAULT 55.5, |
| 341 |
f195 double unsigned not null DEFAULT 55.5, |
| 342 |
f196 double zerofill not null DEFAULT 55.5, |
| 343 |
f197 double unsigned zerofill not null DEFAULT 55.5, |
| 344 |
f198 float, |
| 345 |
f199 float unsigned, |
| 346 |
f200 float zerofill, |
| 347 |
f201 float unsigned zerofill, |
| 348 |
f202 float(0), |
| 349 |
f203 float(23), |
| 350 |
f204 float(0) unsigned, |
| 351 |
f205 float(23) unsigned, |
| 352 |
f206 float(0) zerofill, |
| 353 |
f207 float(23) zerofill, |
| 354 |
f208 float(0) unsigned zerofill, |
| 355 |
f209 float(23) unsigned zerofill, |
| 356 |
f210 float(24), |
| 357 |
f211 float(53), |
| 358 |
f212 float(24) unsigned, |
| 359 |
f213 float(53) unsigned, |
| 360 |
f214 float(24) zerofill, |
| 361 |
f215 float(53) zerofill, |
| 362 |
f216 float(24) unsigned zerofill, |
| 363 |
f217 float(53) unsigned zerofill, |
| 364 |
f218 date, |
| 365 |
f219 time, |
| 366 |
f220 datetime, |
| 367 |
f221 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 368 |
f222 year, |
| 369 |
f225 enum("1enum","2enum"), |
| 370 |
f226 set("1set","2set"), |
| 371 |
f235 char(0), |
| 372 |
f236 char(90), |
| 373 |
f237 char(255) ascii, |
| 374 |
f238 varchar(0), |
| 375 |
f239 varchar(20000) binary, |
| 376 |
f240 varchar(2000), |
| 377 |
f241 char(100) |
| 378 |
) charset latin1 engine = innodb; |
| 379 |
Warnings: |
| 380 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 381 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 382 |
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. |
| 383 |
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. |
| 384 |
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. |
| 385 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 386 |
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. |
| 387 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 388 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 389 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 390 |
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. |
| 391 |
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. |
| 392 |
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. |
| 393 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 394 |
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. |
| 395 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 396 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 397 |
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. |
| 398 |
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. |
| 399 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 400 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 401 |
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. |
| 402 |
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. |
| 403 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 404 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 405 |
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. |
| 406 |
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. |
| 407 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 408 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 409 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 410 |
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. |
| 411 |
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. |
| 412 |
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. |
| 413 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 414 |
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. |
| 415 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 416 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 417 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 418 |
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. |
| 419 |
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. |
| 420 |
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. |
| 421 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 422 |
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. |
| 423 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 424 |
Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead |
| 425 |
Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead |
| 426 |
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb4.txt' |
| 427 |
into table tb4 CHARACTER SET latin1; |
| 428 |
USE test1; |
| 429 |
drop table if exists tb2 ; |
| 430 |
create table tb2 ( |
| 431 |
f59 numeric (0) unsigned, |
| 432 |
f60 numeric (64) unsigned, |
| 433 |
f61 numeric (0) zerofill, |
| 434 |
f62 numeric (64) zerofill, |
| 435 |
f63 numeric (0) unsigned zerofill, |
| 436 |
f64 numeric (64) unsigned zerofill, |
| 437 |
f65 numeric (0,0), |
| 438 |
f66 numeric (63,30), |
| 439 |
f67 numeric (0,0) unsigned, |
| 440 |
f68 numeric (63,30) unsigned, |
| 441 |
f69 numeric (0,0) zerofill, |
| 442 |
f70 numeric (63,30) zerofill, |
| 443 |
f71 numeric (0,0) unsigned zerofill, |
| 444 |
f72 numeric (63,30) unsigned zerofill, |
| 445 |
f73 real, |
| 446 |
f74 real unsigned, |
| 447 |
f75 real zerofill, |
| 448 |
f76 real unsigned zerofill, |
| 449 |
f77 double default 7.7, |
| 450 |
f78 double unsigned default 7.7, |
| 451 |
f79 double zerofill default 7.7, |
| 452 |
f80 double unsigned zerofill default 8.8, |
| 453 |
f81 float not null default 8.8, |
| 454 |
f82 float unsigned not null default 8.8, |
| 455 |
f83 float zerofill not null default 8.8, |
| 456 |
f84 float unsigned zerofill not null default 8.8, |
| 457 |
f85 float(0) not null default 8.8, |
| 458 |
f86 float(23) not null default 8.8, |
| 459 |
f87 float(0) unsigned not null default 8.8, |
| 460 |
f88 float(23) unsigned not null default 8.8, |
| 461 |
f89 float(0) zerofill not null default 8.8, |
| 462 |
f90 float(23) zerofill not null default 8.8, |
| 463 |
f91 float(0) unsigned zerofill not null default 8.8, |
| 464 |
f92 float(23) unsigned zerofill not null default 8.8, |
| 465 |
f93 float(24) not null default 8.8, |
| 466 |
f94 float(53) not null default 8.8, |
| 467 |
f95 float(24) unsigned not null default 8.8, |
| 468 |
f96 float(53) unsigned not null default 8.8, |
| 469 |
f97 float(24) zerofill not null default 8.8, |
| 470 |
f98 float(53) zerofill not null default 8.8, |
| 471 |
f99 float(24) unsigned zerofill not null default 8.8, |
| 472 |
f100 float(53) unsigned zerofill not null default 8.8, |
| 473 |
f101 date not null default '2000-01-01', |
| 474 |
f102 time not null default 20, |
| 475 |
f103 datetime not null default '2/2/2', |
| 476 |
f104 timestamp not null default 20001231235959, |
| 477 |
f105 year not null default 2000, |
| 478 |
f108 enum("1enum","2enum") not null default "1enum", |
| 479 |
f109 set("1set","2set") not null default "1set" |
| 480 |
) charset latin1 engine = innodb; |
| 481 |
Warnings: |
| 482 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 483 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 484 |
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. |
| 485 |
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. |
| 486 |
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. |
| 487 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 488 |
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. |
| 489 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 490 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 491 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 492 |
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. |
| 493 |
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. |
| 494 |
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. |
| 495 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 496 |
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. |
| 497 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 498 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 499 |
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. |
| 500 |
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. |
| 501 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 502 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 503 |
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. |
| 504 |
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. |
| 505 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 506 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 507 |
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. |
| 508 |
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. |
| 509 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 510 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 511 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 512 |
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. |
| 513 |
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. |
| 514 |
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. |
| 515 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 516 |
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. |
| 517 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 518 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 519 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 520 |
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. |
| 521 |
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. |
| 522 |
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. |
| 523 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 524 |
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. |
| 525 |
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. |
| 526 |
Warning 4095 Delimiter '/' in position 1 in datetime value '2/2/2' at row 1 is deprecated. Prefer the standard '-'. |
| 527 |
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/innodb_tb2.txt' |
| 528 |
into table tb2 CHARACTER SET latin1 ; |
| 529 |
USE test; |
| 530 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 531 |
USE test; |
| 532 |
DROP TABLE IF EXISTS t1, t2, t4, t10, t11; |
| 533 |
CREATE TABLE t1 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) |
| 534 |
charset latin1 ENGINE = InnoDB; |
| 535 |
CREATE TABLE t2 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) |
| 536 |
charset latin1 ENGINE = InnoDB; |
| 537 |
CREATE TABLE t4 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) |
| 538 |
charset latin1 ENGINE = InnoDB; |
| 539 |
CREATE TABLE t10 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) |
| 540 |
charset latin1 ENGINE = InnoDB; |
| 541 |
CREATE TABLE t11 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) |
| 542 |
charset latin1 ENGINE = InnoDB; |
| 543 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t1 |
| 544 |
character set latin1; |
| 545 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t2 |
| 546 |
character set latin1; |
| 547 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t4 |
| 548 |
character set latin1; |
| 549 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t10 |
| 550 |
character set latin1; |
| 551 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t11 |
| 552 |
character set latin1; |
| 553 |
drop TABLE if exists t3; |
| 554 |
CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) charset latin1 ENGINE = InnoDB; |
| 555 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' INTO TABLE t3 |
| 556 |
character set latin1; |
| 557 |
drop database if exists test4; |
| 558 |
CREATE database test4; |
| 559 |
use test4; |
| 560 |
CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) |
| 561 |
charset latin1 ENGINE = InnoDB; |
| 562 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t6 |
| 563 |
character set latin1; |
| 564 |
use test; |
| 565 |
drop TABLE if exists t7, t8; |
| 566 |
CREATE TABLE t7 (f1 char(20),f2 char(25),f3 date,f4 int) charset latin1 ENGINE = InnoDB; |
| 567 |
CREATE TABLE t8 (f1 char(20),f2 char(25),f3 date,f4 int) charset latin1 ENGINE = InnoDB; |
| 568 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t7 |
| 569 |
character set latin1; |
| 570 |
Warnings: |
| 571 |
Warning 1265 Data truncated for column 'f3' at row 1 |
| 572 |
Warning 1265 Data truncated for column 'f3' at row 2 |
| 573 |
Warning 1265 Data truncated for column 'f3' at row 3 |
| 574 |
Warning 1265 Data truncated for column 'f3' at row 4 |
| 575 |
Warning 1265 Data truncated for column 'f3' at row 5 |
| 576 |
Warning 1265 Data truncated for column 'f3' at row 6 |
| 577 |
Warning 1265 Data truncated for column 'f3' at row 7 |
| 578 |
Warning 1265 Data truncated for column 'f3' at row 8 |
| 579 |
Warning 1265 Data truncated for column 'f3' at row 9 |
| 580 |
Warning 1265 Data truncated for column 'f3' at row 10 |
| 581 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t8 |
| 582 |
character set latin1; |
| 583 |
Warnings: |
| 584 |
Warning 1265 Data truncated for column 'f3' at row 1 |
| 585 |
Warning 1265 Data truncated for column 'f3' at row 2 |
| 586 |
Warning 1265 Data truncated for column 'f3' at row 3 |
| 587 |
Warning 1265 Data truncated for column 'f3' at row 4 |
| 588 |
Warning 1265 Data truncated for column 'f3' at row 5 |
| 589 |
Warning 1265 Data truncated for column 'f3' at row 6 |
| 590 |
Warning 1265 Data truncated for column 'f3' at row 7 |
| 591 |
Warning 1265 Data truncated for column 'f3' at row 8 |
| 592 |
Warning 1265 Data truncated for column 'f3' at row 9 |
| 593 |
Warning 1265 Data truncated for column 'f3' at row 10 |
| 594 |
drop TABLE if exists t9; |
| 595 |
CREATE TABLE t9 (f1 int, f2 char(25), f3 int) charset latin1 ENGINE = InnoDB; |
| 596 |
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' INTO TABLE t9 |
| 597 |
character set latin1; |
| 598 |
SET sql_mode = default; |
| 599 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 600 |
SELECT * FROM information_schema.columns |
| 601 |
WHERE table_schema LIKE 'test%' |
| 602 |
ORDER BY table_schema, |
| 603 |
table_name COLLATE utf8_general_ci, |
| 604 |
ordinal_position; |
| 605 |
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID |
| 606 |
def test t1 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 607 |
def test t1 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 608 |
def test t1 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 609 |
def test t1 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 610 |
def test t1 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 611 |
def test t1 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 612 |
def test t10 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 613 |
def test t10 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 614 |
def test t10 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 615 |
def test t10 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 616 |
def test t10 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 617 |
def test t10 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 618 |
def test t11 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 619 |
def test t11 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 620 |
def test t11 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 621 |
def test t11 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 622 |
def test t11 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 623 |
def test t11 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 624 |
def test t2 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 625 |
def test t2 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 626 |
def test t2 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 627 |
def test t2 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 628 |
def test t2 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 629 |
def test t2 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 630 |
def test t3 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 631 |
def test t3 f2 2 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 632 |
def test t3 f3 3 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 633 |
def test t4 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 634 |
def test t4 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 635 |
def test t4 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 636 |
def test t4 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 637 |
def test t4 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 638 |
def test t4 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 639 |
def test t7 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 640 |
def test t7 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 641 |
def test t7 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 642 |
def test t7 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 643 |
def test t8 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 644 |
def test t8 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 645 |
def test t8 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 646 |
def test t8 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 647 |
def test t9 f1 1 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 648 |
def test t9 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 649 |
def test t9 f3 3 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 650 |
def test tb1 f1 1 NULL YES char 0 0 NULL NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references NULL |
| 651 |
def test tb1 f2 2 NULL YES char 0 0 NULL NULL NULL latin1 latin1_bin char(0) select,insert,update,references NULL |
| 652 |
def test tb1 f3 3 NULL YES char 0 0 NULL NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references NULL |
| 653 |
def test tb1 f4 4 NULL YES tinytext 255 255 NULL NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references NULL |
| 654 |
def test tb1 f5 5 NULL YES text 65535 65535 NULL NULL NULL latin1 latin1_swedish_ci text select,insert,update,references NULL |
| 655 |
def test tb1 f6 6 NULL YES mediumtext 16777215 16777215 NULL NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references NULL |
| 656 |
def test tb1 f7 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references NULL |
| 657 |
def test tb1 f8 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL NULL tinyblob select,insert,update,references NULL |
| 658 |
def test tb1 f9 9 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL |
| 659 |
def test tb1 f10 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL |
| 660 |
def test tb1 f11 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob select,insert,update,references NULL |
| 661 |
def test tb1 f12 12 NULL YES binary 1 1 NULL NULL NULL NULL NULL binary(1) select,insert,update,references NULL |
| 662 |
def test tb1 f13 13 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL |
| 663 |
def test tb1 f14 14 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL |
| 664 |
def test tb1 f15 15 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL |
| 665 |
def test tb1 f16 16 NULL YES tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL |
| 666 |
def test tb1 f17 17 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint select,insert,update,references NULL |
| 667 |
def test tb1 f18 18 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 668 |
def test tb1 f19 19 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL |
| 669 |
def test tb1 f20 20 NULL YES smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL |
| 670 |
def test tb1 f21 21 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint select,insert,update,references NULL |
| 671 |
def test tb1 f22 22 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint unsigned select,insert,update,references NULL |
| 672 |
def test tb1 f23 23 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL |
| 673 |
def test tb1 f24 24 NULL YES mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL |
| 674 |
def test tb1 f25 25 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 675 |
def test tb1 f26 26 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 676 |
def test tb1 f27 27 NULL YES int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL |
| 677 |
def test tb1 f28 28 NULL YES int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL |
| 678 |
def test tb1 f29 29 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references NULL |
| 679 |
def test tb1 f30 30 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 680 |
def test tb1 f31 31 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL |
| 681 |
def test tb1 f32 32 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL |
| 682 |
def test tb1 f33 33 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 683 |
def test tb1 f34 34 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 684 |
def test tb1 f35 35 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 685 |
def test tb1 f36 36 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 686 |
def test tb1 f37 37 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 687 |
def test tb1 f38 38 10 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL |
| 688 |
def test tb1 f39 39 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 689 |
def test tb1 f40 40 10 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL |
| 690 |
def test tb1 f41 41 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 691 |
def test tb1 f42 42 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 692 |
def test tb1 f43 43 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 693 |
def test tb1 f44 44 0000000000000000000000000000000000000000000000000000000000000010 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 694 |
def test tb1 f45 45 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 695 |
def test tb1 f46 46 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL |
| 696 |
def test tb1 f47 47 10 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 697 |
def test tb1 f48 48 9.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL |
| 698 |
def test tb1 f49 49 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 699 |
def test tb1 f50 50 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 700 |
def test tb1 f51 51 0000000010 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 701 |
def test tb1 f52 52 000000000000000000000000000000009.900000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 702 |
def test tb1 f53 53 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 703 |
def test tb1 f54 54 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 704 |
def test tb1 f55 55 0000000099 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 705 |
def test tb1 f56 56 0000000099 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 706 |
def test tb1 f57 57 99 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 707 |
def test tb1 f58 58 99 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL |
| 708 |
def test tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 709 |
def test tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL |
| 710 |
def test tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 711 |
def test tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 712 |
def test tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 713 |
def test tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 714 |
def test tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 715 |
def test tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL |
| 716 |
def test tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 717 |
def test tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL |
| 718 |
def test tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 719 |
def test tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 720 |
def test tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 721 |
def test tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 722 |
def test tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 723 |
def test tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 724 |
def test tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 725 |
def test tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 726 |
def test tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 727 |
def test tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 728 |
def test tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 729 |
def test tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 730 |
def test tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 731 |
def test tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 732 |
def test tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 733 |
def test tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 734 |
def test tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 735 |
def test tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 736 |
def test tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 737 |
def test tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 738 |
def test tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 739 |
def test tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 740 |
def test tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 741 |
def test tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 742 |
def test tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 743 |
def test tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 744 |
def test tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 745 |
def test tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 746 |
def test tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 747 |
def test tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 748 |
def test tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 749 |
def test tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 750 |
def test tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 751 |
def test tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL |
| 752 |
def test tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL |
| 753 |
def test tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL |
| 754 |
def test tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL |
| 755 |
def test tb2 f108 48 1enum NO enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL |
| 756 |
def test tb2 f109 49 1set NO set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL |
| 757 |
def test tb3 f118 1 a NO char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL |
| 758 |
def test tb3 f119 2 NO char 1 1 NULL NULL NULL latin1 latin1_bin char(1) select,insert,update,references NULL |
| 759 |
def test tb3 f120 3 NO char 1 1 NULL NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references NULL |
| 760 |
def test tb3 f121 4 NULL YES tinytext 255 255 NULL NULL NULL latin1 latin1_swedish_ci tinytext select,insert,update,references NULL |
| 761 |
def test tb3 f122 5 NULL YES text 65535 65535 NULL NULL NULL latin1 latin1_swedish_ci text select,insert,update,references NULL |
| 762 |
def test tb3 f123 6 NULL YES mediumtext 16777215 16777215 NULL NULL NULL latin1 latin1_swedish_ci mediumtext select,insert,update,references NULL |
| 763 |
def test tb3 f124 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext select,insert,update,references NULL |
| 764 |
def test tb3 f125 8 NULL YES tinyblob 255 255 NULL NULL NULL NULL NULL tinyblob select,insert,update,references NULL |
| 765 |
def test tb3 f126 9 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select,insert,update,references NULL |
| 766 |
def test tb3 f127 10 NULL YES mediumblob 16777215 16777215 NULL NULL NULL NULL NULL mediumblob select,insert,update,references NULL |
| 767 |
def test tb3 f128 11 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL NULL longblob select,insert,update,references NULL |
| 768 |
def test tb3 f129 12 0x05 NO binary 1 1 NULL NULL NULL NULL NULL binary(1) select,insert,update,references NULL |
| 769 |
def test tb3 f130 13 99 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint select,insert,update,references NULL |
| 770 |
def test tb3 f131 14 99 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned select,insert,update,references NULL |
| 771 |
def test tb3 f132 15 099 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL |
| 772 |
def test tb3 f133 16 099 NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(3) unsigned zerofill select,insert,update,references NULL |
| 773 |
def test tb3 f134 17 999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint select,insert,update,references NULL |
| 774 |
def test tb3 f135 18 999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint unsigned select,insert,update,references NULL |
| 775 |
def test tb3 f136 19 00999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL |
| 776 |
def test tb3 f137 20 00999 NO smallint NULL NULL 5 0 NULL NULL NULL smallint(5) unsigned zerofill select,insert,update,references NULL |
| 777 |
def test tb3 f138 21 9999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint select,insert,update,references NULL |
| 778 |
def test tb3 f139 22 9999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint unsigned select,insert,update,references NULL |
| 779 |
def test tb3 f140 23 00009999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL |
| 780 |
def test tb3 f141 24 00009999 NO mediumint NULL NULL 7 0 NULL NULL NULL mediumint(8) unsigned zerofill select,insert,update,references NULL |
| 781 |
def test tb3 f142 25 99999 NO int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 782 |
def test tb3 f143 26 99999 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select,insert,update,references NULL |
| 783 |
def test tb3 f144 27 0000099999 NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL |
| 784 |
def test tb3 f145 28 0000099999 NO int NULL NULL 10 0 NULL NULL NULL int(10) unsigned zerofill select,insert,update,references NULL |
| 785 |
def test tb3 f146 29 999999 NO bigint NULL NULL 19 0 NULL NULL NULL bigint select,insert,update,references NULL |
| 786 |
def test tb3 f147 30 999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL |
| 787 |
def test tb3 f148 31 00000000000000999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL |
| 788 |
def test tb3 f149 32 00000000000000999999 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(20) unsigned zerofill select,insert,update,references NULL |
| 789 |
def test tb3 f150 33 1000 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 790 |
def test tb3 f151 34 999 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 791 |
def test tb3 f152 35 0000001000 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 792 |
def test tb3 f153 36 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 793 |
def test tb3 f154 37 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 794 |
def test tb3 f155 38 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL |
| 795 |
def test tb3 f156 39 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 796 |
def test tb3 f157 40 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL |
| 797 |
def test tb3 f158 41 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 798 |
def test tb3 f159 42 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 799 |
def test tb3 f160 43 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 800 |
def test tb3 f161 44 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 801 |
def test tb3 f162 45 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 802 |
def test tb3 f163 46 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL |
| 803 |
def test tb3 f164 47 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 804 |
def test tb3 f165 48 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL |
| 805 |
def test tb3 f166 49 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 806 |
def test tb3 f167 50 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 807 |
def test tb3 f168 51 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 808 |
def test tb3 f169 52 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 809 |
def test tb3 f170 53 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 810 |
def test tb3 f171 54 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 811 |
def test tb3 f172 55 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 812 |
def test tb3 f173 56 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 813 |
def test tb3 f174 57 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 814 |
def test tb3 f175 58 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) select,insert,update,references NULL |
| 815 |
def test tb4 f176 1 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 816 |
def test tb4 f177 2 9 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL |
| 817 |
def test tb4 f178 3 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 818 |
def test tb4 f179 4 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 819 |
def test tb4 f180 5 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 820 |
def test tb4 f181 6 0000000000000000000000000000000000000000000000000000000000000009 NO decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 821 |
def test tb4 f182 7 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 822 |
def test tb4 f183 8 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL |
| 823 |
def test tb4 f184 9 9 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 824 |
def test tb4 f185 10 9.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL |
| 825 |
def test tb4 f186 11 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 826 |
def test tb4 f187 12 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 827 |
def test tb4 f188 13 0000000009 NO decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 828 |
def test tb4 f189 14 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 829 |
def test tb4 f190 15 88.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 830 |
def test tb4 f191 16 88.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 831 |
def test tb4 f192 17 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 832 |
def test tb4 f193 18 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 833 |
def test tb4 f194 19 55.5 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 834 |
def test tb4 f195 20 55.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 835 |
def test tb4 f196 21 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 836 |
def test tb4 f197 22 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 837 |
def test tb4 f198 23 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 838 |
def test tb4 f199 24 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 839 |
def test tb4 f200 25 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 840 |
def test tb4 f201 26 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 841 |
def test tb4 f202 27 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 842 |
def test tb4 f203 28 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 843 |
def test tb4 f204 29 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 844 |
def test tb4 f205 30 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 845 |
def test tb4 f206 31 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 846 |
def test tb4 f207 32 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 847 |
def test tb4 f208 33 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 848 |
def test tb4 f209 34 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 849 |
def test tb4 f210 35 NULL YES float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 850 |
def test tb4 f211 36 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 851 |
def test tb4 f212 37 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 852 |
def test tb4 f213 38 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 853 |
def test tb4 f214 39 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 854 |
def test tb4 f215 40 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 855 |
def test tb4 f216 41 NULL YES float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 856 |
def test tb4 f217 42 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 857 |
def test tb4 f218 43 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 858 |
def test tb4 f219 44 NULL YES time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL |
| 859 |
def test tb4 f220 45 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL |
| 860 |
def test tb4 f221 46 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL |
| 861 |
def test tb4 f222 47 NULL YES year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL |
| 862 |
def test tb4 f225 48 NULL YES enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL |
| 863 |
def test tb4 f226 49 NULL YES set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL |
| 864 |
def test tb4 f235 50 NULL YES char 0 0 NULL NULL NULL latin1 latin1_swedish_ci char(0) select,insert,update,references NULL |
| 865 |
def test tb4 f236 51 NULL YES char 90 90 NULL NULL NULL latin1 latin1_swedish_ci char(90) select,insert,update,references NULL |
| 866 |
def test tb4 f237 52 NULL YES char 255 255 NULL NULL NULL latin1 latin1_swedish_ci char(255) select,insert,update,references NULL |
| 867 |
def test tb4 f238 53 NULL YES varchar 0 0 NULL NULL NULL latin1 latin1_swedish_ci varchar(0) select,insert,update,references NULL |
| 868 |
def test tb4 f239 54 NULL YES varchar 20000 20000 NULL NULL NULL latin1 latin1_bin varchar(20000) select,insert,update,references NULL |
| 869 |
def test tb4 f240 55 NULL YES varchar 2000 2000 NULL NULL NULL latin1 latin1_swedish_ci varchar(2000) select,insert,update,references NULL |
| 870 |
def test tb4 f241 56 NULL YES char 100 100 NULL NULL NULL latin1 latin1_swedish_ci char(100) select,insert,update,references NULL |
| 871 |
def test1 tb2 f59 1 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 872 |
def test1 tb2 f60 2 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned select,insert,update,references NULL |
| 873 |
def test1 tb2 f61 3 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 874 |
def test1 tb2 f62 4 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 875 |
def test1 tb2 f63 5 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 876 |
def test1 tb2 f64 6 NULL YES decimal NULL NULL 64 0 NULL NULL NULL decimal(64,0) unsigned zerofill select,insert,update,references NULL |
| 877 |
def test1 tb2 f65 7 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) select,insert,update,references NULL |
| 878 |
def test1 tb2 f66 8 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) select,insert,update,references NULL |
| 879 |
def test1 tb2 f67 9 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned select,insert,update,references NULL |
| 880 |
def test1 tb2 f68 10 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned select,insert,update,references NULL |
| 881 |
def test1 tb2 f69 11 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 882 |
def test1 tb2 f70 12 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 883 |
def test1 tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references NULL |
| 884 |
def test1 tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references NULL |
| 885 |
def test1 tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 886 |
def test1 tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 887 |
def test1 tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 888 |
def test1 tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 889 |
def test1 tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 890 |
def test1 tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 891 |
def test1 tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 892 |
def test1 tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 893 |
def test1 tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 894 |
def test1 tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 895 |
def test1 tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 896 |
def test1 tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 897 |
def test1 tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 898 |
def test1 tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 899 |
def test1 tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 900 |
def test1 tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 901 |
def test1 tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 902 |
def test1 tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 903 |
def test1 tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 904 |
def test1 tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 905 |
def test1 tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float select,insert,update,references NULL |
| 906 |
def test1 tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double select,insert,update,references NULL |
| 907 |
def test1 tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned select,insert,update,references NULL |
| 908 |
def test1 tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned select,insert,update,references NULL |
| 909 |
def test1 tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 910 |
def test1 tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 911 |
def test1 tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL NULL float unsigned zerofill select,insert,update,references NULL |
| 912 |
def test1 tb2 f100 42 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL NULL double unsigned zerofill select,insert,update,references NULL |
| 913 |
def test1 tb2 f101 43 2000-01-01 NO date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 914 |
def test1 tb2 f102 44 00:00:20 NO time NULL NULL NULL NULL 0 NULL NULL time select,insert,update,references NULL |
| 915 |
def test1 tb2 f103 45 0002-02-02 00:00:00 NO datetime NULL NULL NULL NULL 0 NULL NULL datetime select,insert,update,references NULL |
| 916 |
def test1 tb2 f104 46 2000-12-31 23:59:59 NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select,insert,update,references NULL |
| 917 |
def test1 tb2 f105 47 2000 NO year NULL NULL NULL NULL NULL NULL NULL year select,insert,update,references NULL |
| 918 |
def test1 tb2 f108 48 1enum NO enum 5 5 NULL NULL NULL latin1 latin1_swedish_ci enum('1enum','2enum') select,insert,update,references NULL |
| 919 |
def test1 tb2 f109 49 1set NO set 9 9 NULL NULL NULL latin1 latin1_swedish_ci set('1set','2set') select,insert,update,references NULL |
| 920 |
def test4 t6 f1 1 NULL YES char 20 20 NULL NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references NULL |
| 921 |
def test4 t6 f2 2 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 922 |
def test4 t6 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL NULL date select,insert,update,references NULL |
| 923 |
def test4 t6 f4 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 924 |
def test4 t6 f5 5 NULL YES char 25 25 NULL NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references NULL |
| 925 |
def test4 t6 f6 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select,insert,update,references NULL |
| 926 |
########################################################################## |
| 927 |
# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH |
| 928 |
########################################################################## |
| 929 |
SELECT DISTINCT |
| 930 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 931 |
DATA_TYPE, |
| 932 |
CHARACTER_SET_NAME, |
| 933 |
COLLATION_NAME |
| 934 |
FROM information_schema.columns |
| 935 |
WHERE table_schema LIKE 'test%' |
| 936 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1 |
| 937 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 938 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 939 |
1.0000 binary NULL NULL |
| 940 |
1.0000 blob NULL NULL |
| 941 |
1.0000 longblob NULL NULL |
| 942 |
1.0000 mediumblob NULL NULL |
| 943 |
1.0000 tinyblob NULL NULL |
| 944 |
1.0000 char latin1 latin1_bin |
| 945 |
1.0000 varchar latin1 latin1_bin |
| 946 |
1.0000 char latin1 latin1_swedish_ci |
| 947 |
1.0000 enum latin1 latin1_swedish_ci |
| 948 |
1.0000 longtext latin1 latin1_swedish_ci |
| 949 |
1.0000 mediumtext latin1 latin1_swedish_ci |
| 950 |
1.0000 set latin1 latin1_swedish_ci |
| 951 |
1.0000 text latin1 latin1_swedish_ci |
| 952 |
1.0000 tinytext latin1 latin1_swedish_ci |
| 953 |
1.0000 varchar latin1 latin1_swedish_ci |
| 954 |
SELECT DISTINCT |
| 955 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 956 |
DATA_TYPE, |
| 957 |
CHARACTER_SET_NAME, |
| 958 |
COLLATION_NAME |
| 959 |
FROM information_schema.columns |
| 960 |
WHERE table_schema LIKE 'test%' |
| 961 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1 |
| 962 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 963 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 964 |
SELECT DISTINCT |
| 965 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 966 |
DATA_TYPE, |
| 967 |
CHARACTER_SET_NAME, |
| 968 |
COLLATION_NAME |
| 969 |
FROM information_schema.columns |
| 970 |
WHERE table_schema LIKE 'test%' |
| 971 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL |
| 972 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 973 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 974 |
NULL bigint NULL NULL |
| 975 |
NULL date NULL NULL |
| 976 |
NULL datetime NULL NULL |
| 977 |
NULL decimal NULL NULL |
| 978 |
NULL double NULL NULL |
| 979 |
NULL float NULL NULL |
| 980 |
NULL int NULL NULL |
| 981 |
NULL mediumint NULL NULL |
| 982 |
NULL smallint NULL NULL |
| 983 |
NULL time NULL NULL |
| 984 |
NULL timestamp NULL NULL |
| 985 |
NULL tinyint NULL NULL |
| 986 |
NULL year NULL NULL |
| 987 |
NULL char latin1 latin1_bin |
| 988 |
NULL char latin1 latin1_swedish_ci |
| 989 |
NULL varchar latin1 latin1_swedish_ci |
| 990 |
--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values |
| 991 |
--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL |
| 992 |
SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 993 |
TABLE_SCHEMA, |
| 994 |
TABLE_NAME, |
| 995 |
COLUMN_NAME, |
| 996 |
DATA_TYPE, |
| 997 |
CHARACTER_MAXIMUM_LENGTH, |
| 998 |
CHARACTER_OCTET_LENGTH, |
| 999 |
CHARACTER_SET_NAME, |
| 1000 |
COLLATION_NAME, |
| 1001 |
COLUMN_TYPE |
| 1002 |
FROM information_schema.columns |
| 1003 |
WHERE table_schema LIKE 'test%' |
| 1004 |
ORDER BY TABLE_SCHEMA, TABLE_NAME COLLATE utf8_general_ci, ORDINAL_POSITION; |
| 1005 |
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE |
| 1006 |
1.0000 test t1 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1007 |
1.0000 test t1 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1008 |
NULL test t1 f3 date NULL NULL NULL NULL date |
| 1009 |
NULL test t1 f4 int NULL NULL NULL NULL int |
| 1010 |
1.0000 test t1 f5 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1011 |
NULL test t1 f6 int NULL NULL NULL NULL int |
| 1012 |
1.0000 test t10 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1013 |
1.0000 test t10 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1014 |
NULL test t10 f3 date NULL NULL NULL NULL date |
| 1015 |
NULL test t10 f4 int NULL NULL NULL NULL int |
| 1016 |
1.0000 test t10 f5 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1017 |
NULL test t10 f6 int NULL NULL NULL NULL int |
| 1018 |
1.0000 test t11 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1019 |
1.0000 test t11 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1020 |
NULL test t11 f3 date NULL NULL NULL NULL date |
| 1021 |
NULL test t11 f4 int NULL NULL NULL NULL int |
| 1022 |
1.0000 test t11 f5 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1023 |
NULL test t11 f6 int NULL NULL NULL NULL int |
| 1024 |
1.0000 test t2 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1025 |
1.0000 test t2 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1026 |
NULL test t2 f3 date NULL NULL NULL NULL date |
| 1027 |
NULL test t2 f4 int NULL NULL NULL NULL int |
| 1028 |
1.0000 test t2 f5 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1029 |
NULL test t2 f6 int NULL NULL NULL NULL int |
| 1030 |
1.0000 test t3 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1031 |
1.0000 test t3 f2 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1032 |
NULL test t3 f3 int NULL NULL NULL NULL int |
| 1033 |
1.0000 test t4 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1034 |
1.0000 test t4 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1035 |
NULL test t4 f3 date NULL NULL NULL NULL date |
| 1036 |
NULL test t4 f4 int NULL NULL NULL NULL int |
| 1037 |
1.0000 test t4 f5 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1038 |
NULL test t4 f6 int NULL NULL NULL NULL int |
| 1039 |
1.0000 test t7 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1040 |
1.0000 test t7 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1041 |
NULL test t7 f3 date NULL NULL NULL NULL date |
| 1042 |
NULL test t7 f4 int NULL NULL NULL NULL int |
| 1043 |
1.0000 test t8 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1044 |
1.0000 test t8 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1045 |
NULL test t8 f3 date NULL NULL NULL NULL date |
| 1046 |
NULL test t8 f4 int NULL NULL NULL NULL int |
| 1047 |
NULL test t9 f1 int NULL NULL NULL NULL int |
| 1048 |
1.0000 test t9 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1049 |
NULL test t9 f3 int NULL NULL NULL NULL int |
| 1050 |
NULL test tb1 f1 char 0 0 latin1 latin1_swedish_ci char(0) |
| 1051 |
NULL test tb1 f2 char 0 0 latin1 latin1_bin char(0) |
| 1052 |
NULL test tb1 f3 char 0 0 latin1 latin1_swedish_ci char(0) |
| 1053 |
1.0000 test tb1 f4 tinytext 255 255 latin1 latin1_swedish_ci tinytext |
| 1054 |
1.0000 test tb1 f5 text 65535 65535 latin1 latin1_swedish_ci text |
| 1055 |
1.0000 test tb1 f6 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext |
| 1056 |
1.0000 test tb1 f7 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext |
| 1057 |
1.0000 test tb1 f8 tinyblob 255 255 NULL NULL tinyblob |
| 1058 |
1.0000 test tb1 f9 blob 65535 65535 NULL NULL blob |
| 1059 |
1.0000 test tb1 f10 mediumblob 16777215 16777215 NULL NULL mediumblob |
| 1060 |
1.0000 test tb1 f11 longblob 4294967295 4294967295 NULL NULL longblob |
| 1061 |
1.0000 test tb1 f12 binary 1 1 NULL NULL binary(1) |
| 1062 |
NULL test tb1 f13 tinyint NULL NULL NULL NULL tinyint |
| 1063 |
NULL test tb1 f14 tinyint NULL NULL NULL NULL tinyint unsigned |
| 1064 |
NULL test tb1 f15 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill |
| 1065 |
NULL test tb1 f16 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill |
| 1066 |
NULL test tb1 f17 smallint NULL NULL NULL NULL smallint |
| 1067 |
NULL test tb1 f18 smallint NULL NULL NULL NULL smallint unsigned |
| 1068 |
NULL test tb1 f19 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill |
| 1069 |
NULL test tb1 f20 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill |
| 1070 |
NULL test tb1 f21 mediumint NULL NULL NULL NULL mediumint |
| 1071 |
NULL test tb1 f22 mediumint NULL NULL NULL NULL mediumint unsigned |
| 1072 |
NULL test tb1 f23 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill |
| 1073 |
NULL test tb1 f24 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill |
| 1074 |
NULL test tb1 f25 int NULL NULL NULL NULL int |
| 1075 |
NULL test tb1 f26 int NULL NULL NULL NULL int unsigned |
| 1076 |
NULL test tb1 f27 int NULL NULL NULL NULL int(10) unsigned zerofill |
| 1077 |
NULL test tb1 f28 int NULL NULL NULL NULL int(10) unsigned zerofill |
| 1078 |
NULL test tb1 f29 bigint NULL NULL NULL NULL bigint |
| 1079 |
NULL test tb1 f30 bigint NULL NULL NULL NULL bigint unsigned |
| 1080 |
NULL test tb1 f31 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill |
| 1081 |
NULL test tb1 f32 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill |
| 1082 |
NULL test tb1 f33 decimal NULL NULL NULL NULL decimal(10,0) |
| 1083 |
NULL test tb1 f34 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1084 |
NULL test tb1 f35 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1085 |
NULL test tb1 f36 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1086 |
NULL test tb1 f37 decimal NULL NULL NULL NULL decimal(10,0) |
| 1087 |
NULL test tb1 f38 decimal NULL NULL NULL NULL decimal(64,0) |
| 1088 |
NULL test tb1 f39 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1089 |
NULL test tb1 f40 decimal NULL NULL NULL NULL decimal(64,0) unsigned |
| 1090 |
NULL test tb1 f41 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1091 |
NULL test tb1 f42 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1092 |
NULL test tb1 f43 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1093 |
NULL test tb1 f44 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1094 |
NULL test tb1 f45 decimal NULL NULL NULL NULL decimal(10,0) |
| 1095 |
NULL test tb1 f46 decimal NULL NULL NULL NULL decimal(63,30) |
| 1096 |
NULL test tb1 f47 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1097 |
NULL test tb1 f48 decimal NULL NULL NULL NULL decimal(63,30) unsigned |
| 1098 |
NULL test tb1 f49 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1099 |
NULL test tb1 f50 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1100 |
NULL test tb1 f51 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1101 |
NULL test tb1 f52 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1102 |
NULL test tb1 f53 decimal NULL NULL NULL NULL decimal(10,0) |
| 1103 |
NULL test tb1 f54 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1104 |
NULL test tb1 f55 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1105 |
NULL test tb1 f56 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1106 |
NULL test tb1 f57 decimal NULL NULL NULL NULL decimal(10,0) |
| 1107 |
NULL test tb1 f58 decimal NULL NULL NULL NULL decimal(64,0) |
| 1108 |
NULL test tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1109 |
NULL test tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned |
| 1110 |
NULL test tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1111 |
NULL test tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1112 |
NULL test tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1113 |
NULL test tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1114 |
NULL test tb2 f65 decimal NULL NULL NULL NULL decimal(10,0) |
| 1115 |
NULL test tb2 f66 decimal NULL NULL NULL NULL decimal(63,30) |
| 1116 |
NULL test tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1117 |
NULL test tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned |
| 1118 |
NULL test tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1119 |
NULL test tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1120 |
NULL test tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1121 |
NULL test tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1122 |
NULL test tb2 f73 double NULL NULL NULL NULL double |
| 1123 |
NULL test tb2 f74 double NULL NULL NULL NULL double unsigned |
| 1124 |
NULL test tb2 f75 double NULL NULL NULL NULL double unsigned zerofill |
| 1125 |
NULL test tb2 f76 double NULL NULL NULL NULL double unsigned zerofill |
| 1126 |
NULL test tb2 f77 double NULL NULL NULL NULL double |
| 1127 |
NULL test tb2 f78 double NULL NULL NULL NULL double unsigned |
| 1128 |
NULL test tb2 f79 double NULL NULL NULL NULL double unsigned zerofill |
| 1129 |
NULL test tb2 f80 double NULL NULL NULL NULL double unsigned zerofill |
| 1130 |
NULL test tb2 f81 float NULL NULL NULL NULL float |
| 1131 |
NULL test tb2 f82 float NULL NULL NULL NULL float unsigned |
| 1132 |
NULL test tb2 f83 float NULL NULL NULL NULL float unsigned zerofill |
| 1133 |
NULL test tb2 f84 float NULL NULL NULL NULL float unsigned zerofill |
| 1134 |
NULL test tb2 f85 float NULL NULL NULL NULL float |
| 1135 |
NULL test tb2 f86 float NULL NULL NULL NULL float |
| 1136 |
NULL test tb2 f87 float NULL NULL NULL NULL float unsigned |
| 1137 |
NULL test tb2 f88 float NULL NULL NULL NULL float unsigned |
| 1138 |
NULL test tb2 f89 float NULL NULL NULL NULL float unsigned zerofill |
| 1139 |
NULL test tb2 f90 float NULL NULL NULL NULL float unsigned zerofill |
| 1140 |
NULL test tb2 f91 float NULL NULL NULL NULL float unsigned zerofill |
| 1141 |
NULL test tb2 f92 float NULL NULL NULL NULL float unsigned zerofill |
| 1142 |
NULL test tb2 f93 float NULL NULL NULL NULL float |
| 1143 |
NULL test tb2 f94 double NULL NULL NULL NULL double |
| 1144 |
NULL test tb2 f95 float NULL NULL NULL NULL float unsigned |
| 1145 |
NULL test tb2 f96 double NULL NULL NULL NULL double unsigned |
| 1146 |
NULL test tb2 f97 float NULL NULL NULL NULL float unsigned zerofill |
| 1147 |
NULL test tb2 f98 double NULL NULL NULL NULL double unsigned zerofill |
| 1148 |
NULL test tb2 f99 float NULL NULL NULL NULL float unsigned zerofill |
| 1149 |
NULL test tb2 f100 double NULL NULL NULL NULL double unsigned zerofill |
| 1150 |
NULL test tb2 f101 date NULL NULL NULL NULL date |
| 1151 |
NULL test tb2 f102 time NULL NULL NULL NULL time |
| 1152 |
NULL test tb2 f103 datetime NULL NULL NULL NULL datetime |
| 1153 |
NULL test tb2 f104 timestamp NULL NULL NULL NULL timestamp |
| 1154 |
NULL test tb2 f105 year NULL NULL NULL NULL year |
| 1155 |
1.0000 test tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum') |
| 1156 |
1.0000 test tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set') |
| 1157 |
1.0000 test tb3 f118 char 1 1 latin1 latin1_swedish_ci char(1) |
| 1158 |
1.0000 test tb3 f119 char 1 1 latin1 latin1_bin char(1) |
| 1159 |
1.0000 test tb3 f120 char 1 1 latin1 latin1_swedish_ci char(1) |
| 1160 |
1.0000 test tb3 f121 tinytext 255 255 latin1 latin1_swedish_ci tinytext |
| 1161 |
1.0000 test tb3 f122 text 65535 65535 latin1 latin1_swedish_ci text |
| 1162 |
1.0000 test tb3 f123 mediumtext 16777215 16777215 latin1 latin1_swedish_ci mediumtext |
| 1163 |
1.0000 test tb3 f124 longtext 4294967295 4294967295 latin1 latin1_swedish_ci longtext |
| 1164 |
1.0000 test tb3 f125 tinyblob 255 255 NULL NULL tinyblob |
| 1165 |
1.0000 test tb3 f126 blob 65535 65535 NULL NULL blob |
| 1166 |
1.0000 test tb3 f127 mediumblob 16777215 16777215 NULL NULL mediumblob |
| 1167 |
1.0000 test tb3 f128 longblob 4294967295 4294967295 NULL NULL longblob |
| 1168 |
1.0000 test tb3 f129 binary 1 1 NULL NULL binary(1) |
| 1169 |
NULL test tb3 f130 tinyint NULL NULL NULL NULL tinyint |
| 1170 |
NULL test tb3 f131 tinyint NULL NULL NULL NULL tinyint unsigned |
| 1171 |
NULL test tb3 f132 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill |
| 1172 |
NULL test tb3 f133 tinyint NULL NULL NULL NULL tinyint(3) unsigned zerofill |
| 1173 |
NULL test tb3 f134 smallint NULL NULL NULL NULL smallint |
| 1174 |
NULL test tb3 f135 smallint NULL NULL NULL NULL smallint unsigned |
| 1175 |
NULL test tb3 f136 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill |
| 1176 |
NULL test tb3 f137 smallint NULL NULL NULL NULL smallint(5) unsigned zerofill |
| 1177 |
NULL test tb3 f138 mediumint NULL NULL NULL NULL mediumint |
| 1178 |
NULL test tb3 f139 mediumint NULL NULL NULL NULL mediumint unsigned |
| 1179 |
NULL test tb3 f140 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill |
| 1180 |
NULL test tb3 f141 mediumint NULL NULL NULL NULL mediumint(8) unsigned zerofill |
| 1181 |
NULL test tb3 f142 int NULL NULL NULL NULL int |
| 1182 |
NULL test tb3 f143 int NULL NULL NULL NULL int unsigned |
| 1183 |
NULL test tb3 f144 int NULL NULL NULL NULL int(10) unsigned zerofill |
| 1184 |
NULL test tb3 f145 int NULL NULL NULL NULL int(10) unsigned zerofill |
| 1185 |
NULL test tb3 f146 bigint NULL NULL NULL NULL bigint |
| 1186 |
NULL test tb3 f147 bigint NULL NULL NULL NULL bigint unsigned |
| 1187 |
NULL test tb3 f148 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill |
| 1188 |
NULL test tb3 f149 bigint NULL NULL NULL NULL bigint(20) unsigned zerofill |
| 1189 |
NULL test tb3 f150 decimal NULL NULL NULL NULL decimal(10,0) |
| 1190 |
NULL test tb3 f151 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1191 |
NULL test tb3 f152 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1192 |
NULL test tb3 f153 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1193 |
NULL test tb3 f154 decimal NULL NULL NULL NULL decimal(10,0) |
| 1194 |
NULL test tb3 f155 decimal NULL NULL NULL NULL decimal(64,0) |
| 1195 |
NULL test tb3 f156 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1196 |
NULL test tb3 f157 decimal NULL NULL NULL NULL decimal(64,0) unsigned |
| 1197 |
NULL test tb3 f158 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1198 |
NULL test tb3 f159 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1199 |
NULL test tb3 f160 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1200 |
NULL test tb3 f161 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1201 |
NULL test tb3 f162 decimal NULL NULL NULL NULL decimal(10,0) |
| 1202 |
NULL test tb3 f163 decimal NULL NULL NULL NULL decimal(63,30) |
| 1203 |
NULL test tb3 f164 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1204 |
NULL test tb3 f165 decimal NULL NULL NULL NULL decimal(63,30) unsigned |
| 1205 |
NULL test tb3 f166 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1206 |
NULL test tb3 f167 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1207 |
NULL test tb3 f168 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1208 |
NULL test tb3 f169 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1209 |
NULL test tb3 f170 decimal NULL NULL NULL NULL decimal(10,0) |
| 1210 |
NULL test tb3 f171 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1211 |
NULL test tb3 f172 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1212 |
NULL test tb3 f173 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1213 |
NULL test tb3 f174 decimal NULL NULL NULL NULL decimal(10,0) |
| 1214 |
NULL test tb3 f175 decimal NULL NULL NULL NULL decimal(64,0) |
| 1215 |
NULL test tb4 f176 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1216 |
NULL test tb4 f177 decimal NULL NULL NULL NULL decimal(64,0) unsigned |
| 1217 |
NULL test tb4 f178 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1218 |
NULL test tb4 f179 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1219 |
NULL test tb4 f180 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1220 |
NULL test tb4 f181 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1221 |
NULL test tb4 f182 decimal NULL NULL NULL NULL decimal(10,0) |
| 1222 |
NULL test tb4 f183 decimal NULL NULL NULL NULL decimal(63,30) |
| 1223 |
NULL test tb4 f184 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1224 |
NULL test tb4 f185 decimal NULL NULL NULL NULL decimal(63,30) unsigned |
| 1225 |
NULL test tb4 f186 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1226 |
NULL test tb4 f187 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1227 |
NULL test tb4 f188 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1228 |
NULL test tb4 f189 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1229 |
NULL test tb4 f190 double NULL NULL NULL NULL double |
| 1230 |
NULL test tb4 f191 double NULL NULL NULL NULL double unsigned |
| 1231 |
NULL test tb4 f192 double NULL NULL NULL NULL double unsigned zerofill |
| 1232 |
NULL test tb4 f193 double NULL NULL NULL NULL double unsigned zerofill |
| 1233 |
NULL test tb4 f194 double NULL NULL NULL NULL double |
| 1234 |
NULL test tb4 f195 double NULL NULL NULL NULL double unsigned |
| 1235 |
NULL test tb4 f196 double NULL NULL NULL NULL double unsigned zerofill |
| 1236 |
NULL test tb4 f197 double NULL NULL NULL NULL double unsigned zerofill |
| 1237 |
NULL test tb4 f198 float NULL NULL NULL NULL float |
| 1238 |
NULL test tb4 f199 float NULL NULL NULL NULL float unsigned |
| 1239 |
NULL test tb4 f200 float NULL NULL NULL NULL float unsigned zerofill |
| 1240 |
NULL test tb4 f201 float NULL NULL NULL NULL float unsigned zerofill |
| 1241 |
NULL test tb4 f202 float NULL NULL NULL NULL float |
| 1242 |
NULL test tb4 f203 float NULL NULL NULL NULL float |
| 1243 |
NULL test tb4 f204 float NULL NULL NULL NULL float unsigned |
| 1244 |
NULL test tb4 f205 float NULL NULL NULL NULL float unsigned |
| 1245 |
NULL test tb4 f206 float NULL NULL NULL NULL float unsigned zerofill |
| 1246 |
NULL test tb4 f207 float NULL NULL NULL NULL float unsigned zerofill |
| 1247 |
NULL test tb4 f208 float NULL NULL NULL NULL float unsigned zerofill |
| 1248 |
NULL test tb4 f209 float NULL NULL NULL NULL float unsigned zerofill |
| 1249 |
NULL test tb4 f210 float NULL NULL NULL NULL float |
| 1250 |
NULL test tb4 f211 double NULL NULL NULL NULL double |
| 1251 |
NULL test tb4 f212 float NULL NULL NULL NULL float unsigned |
| 1252 |
NULL test tb4 f213 double NULL NULL NULL NULL double unsigned |
| 1253 |
NULL test tb4 f214 float NULL NULL NULL NULL float unsigned zerofill |
| 1254 |
NULL test tb4 f215 double NULL NULL NULL NULL double unsigned zerofill |
| 1255 |
NULL test tb4 f216 float NULL NULL NULL NULL float unsigned zerofill |
| 1256 |
NULL test tb4 f217 double NULL NULL NULL NULL double unsigned zerofill |
| 1257 |
NULL test tb4 f218 date NULL NULL NULL NULL date |
| 1258 |
NULL test tb4 f219 time NULL NULL NULL NULL time |
| 1259 |
NULL test tb4 f220 datetime NULL NULL NULL NULL datetime |
| 1260 |
NULL test tb4 f221 timestamp NULL NULL NULL NULL timestamp |
| 1261 |
NULL test tb4 f222 year NULL NULL NULL NULL year |
| 1262 |
1.0000 test tb4 f225 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum') |
| 1263 |
1.0000 test tb4 f226 set 9 9 latin1 latin1_swedish_ci set('1set','2set') |
| 1264 |
NULL test tb4 f235 char 0 0 latin1 latin1_swedish_ci char(0) |
| 1265 |
1.0000 test tb4 f236 char 90 90 latin1 latin1_swedish_ci char(90) |
| 1266 |
1.0000 test tb4 f237 char 255 255 latin1 latin1_swedish_ci char(255) |
| 1267 |
NULL test tb4 f238 varchar 0 0 latin1 latin1_swedish_ci varchar(0) |
| 1268 |
1.0000 test tb4 f239 varchar 20000 20000 latin1 latin1_bin varchar(20000) |
| 1269 |
1.0000 test tb4 f240 varchar 2000 2000 latin1 latin1_swedish_ci varchar(2000) |
| 1270 |
1.0000 test tb4 f241 char 100 100 latin1 latin1_swedish_ci char(100) |
| 1271 |
NULL test1 tb2 f59 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1272 |
NULL test1 tb2 f60 decimal NULL NULL NULL NULL decimal(64,0) unsigned |
| 1273 |
NULL test1 tb2 f61 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1274 |
NULL test1 tb2 f62 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1275 |
NULL test1 tb2 f63 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1276 |
NULL test1 tb2 f64 decimal NULL NULL NULL NULL decimal(64,0) unsigned zerofill |
| 1277 |
NULL test1 tb2 f65 decimal NULL NULL NULL NULL decimal(10,0) |
| 1278 |
NULL test1 tb2 f66 decimal NULL NULL NULL NULL decimal(63,30) |
| 1279 |
NULL test1 tb2 f67 decimal NULL NULL NULL NULL decimal(10,0) unsigned |
| 1280 |
NULL test1 tb2 f68 decimal NULL NULL NULL NULL decimal(63,30) unsigned |
| 1281 |
NULL test1 tb2 f69 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1282 |
NULL test1 tb2 f70 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1283 |
NULL test1 tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill |
| 1284 |
NULL test1 tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill |
| 1285 |
NULL test1 tb2 f73 double NULL NULL NULL NULL double |
| 1286 |
NULL test1 tb2 f74 double NULL NULL NULL NULL double unsigned |
| 1287 |
NULL test1 tb2 f75 double NULL NULL NULL NULL double unsigned zerofill |
| 1288 |
NULL test1 tb2 f76 double NULL NULL NULL NULL double unsigned zerofill |
| 1289 |
NULL test1 tb2 f77 double NULL NULL NULL NULL double |
| 1290 |
NULL test1 tb2 f78 double NULL NULL NULL NULL double unsigned |
| 1291 |
NULL test1 tb2 f79 double NULL NULL NULL NULL double unsigned zerofill |
| 1292 |
NULL test1 tb2 f80 double NULL NULL NULL NULL double unsigned zerofill |
| 1293 |
NULL test1 tb2 f81 float NULL NULL NULL NULL float |
| 1294 |
NULL test1 tb2 f82 float NULL NULL NULL NULL float unsigned |
| 1295 |
NULL test1 tb2 f83 float NULL NULL NULL NULL float unsigned zerofill |
| 1296 |
NULL test1 tb2 f84 float NULL NULL NULL NULL float unsigned zerofill |
| 1297 |
NULL test1 tb2 f85 float NULL NULL NULL NULL float |
| 1298 |
NULL test1 tb2 f86 float NULL NULL NULL NULL float |
| 1299 |
NULL test1 tb2 f87 float NULL NULL NULL NULL float unsigned |
| 1300 |
NULL test1 tb2 f88 float NULL NULL NULL NULL float unsigned |
| 1301 |
NULL test1 tb2 f89 float NULL NULL NULL NULL float unsigned zerofill |
| 1302 |
NULL test1 tb2 f90 float NULL NULL NULL NULL float unsigned zerofill |
| 1303 |
NULL test1 tb2 f91 float NULL NULL NULL NULL float unsigned zerofill |
| 1304 |
NULL test1 tb2 f92 float NULL NULL NULL NULL float unsigned zerofill |
| 1305 |
NULL test1 tb2 f93 float NULL NULL NULL NULL float |
| 1306 |
NULL test1 tb2 f94 double NULL NULL NULL NULL double |
| 1307 |
NULL test1 tb2 f95 float NULL NULL NULL NULL float unsigned |
| 1308 |
NULL test1 tb2 f96 double NULL NULL NULL NULL double unsigned |
| 1309 |
NULL test1 tb2 f97 float NULL NULL NULL NULL float unsigned zerofill |
| 1310 |
NULL test1 tb2 f98 double NULL NULL NULL NULL double unsigned zerofill |
| 1311 |
NULL test1 tb2 f99 float NULL NULL NULL NULL float unsigned zerofill |
| 1312 |
NULL test1 tb2 f100 double NULL NULL NULL NULL double unsigned zerofill |
| 1313 |
NULL test1 tb2 f101 date NULL NULL NULL NULL date |
| 1314 |
NULL test1 tb2 f102 time NULL NULL NULL NULL time |
| 1315 |
NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime |
| 1316 |
NULL test1 tb2 f104 timestamp NULL NULL NULL NULL timestamp |
| 1317 |
NULL test1 tb2 f105 year NULL NULL NULL NULL year |
| 1318 |
1.0000 test1 tb2 f108 enum 5 5 latin1 latin1_swedish_ci enum('1enum','2enum') |
| 1319 |
1.0000 test1 tb2 f109 set 9 9 latin1 latin1_swedish_ci set('1set','2set') |
| 1320 |
1.0000 test4 t6 f1 char 20 20 latin1 latin1_swedish_ci char(20) |
| 1321 |
1.0000 test4 t6 f2 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1322 |
NULL test4 t6 f3 date NULL NULL NULL NULL date |
| 1323 |
NULL test4 t6 f4 int NULL NULL NULL NULL int |
| 1324 |
1.0000 test4 t6 f5 char 25 25 latin1 latin1_swedish_ci char(25) |
| 1325 |
NULL test4 t6 f6 int NULL NULL NULL NULL int |
| 1326 |
SET sql_mode = default; |
| 1327 |
DROP DATABASE test1; |
| 1328 |
DROP DATABASE test4; |
| 1329 |
DROP TABLE test.t1; |
| 1330 |
DROP TABLE test.t2; |
| 1331 |
DROP TABLE test.t3; |
| 1332 |
DROP TABLE test.t4; |
| 1333 |
DROP TABLE test.t7; |
| 1334 |
DROP TABLE test.t8; |
| 1335 |
DROP TABLE test.t9; |
| 1336 |
DROP TABLE test.t10; |
| 1337 |
DROP TABLE test.t11; |
| 1338 |
DROP TABLE test.tb1; |
| 1339 |
DROP TABLE test.tb2; |
| 1340 |
DROP TABLE test.tb3; |
| 1341 |
DROP TABLE test.tb4; |