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