| 1 |
##### suite/funcs_1/include/innodb_tb4.inc |
| 2 |
|
| 3 |
--disable_warnings |
| 4 |
drop table if exists tb4; |
| 5 |
--enable_warnings |
| 6 |
create table tb4 ( |
| 7 |
f176 numeric (0) unsigned not null DEFAULT 9, |
| 8 |
f177 numeric (64) unsigned not null DEFAULT 9, |
| 9 |
f178 numeric (0) zerofill not null DEFAULT 9, |
| 10 |
f179 numeric (64) zerofill not null DEFAULT 9, |
| 11 |
f180 numeric (0) unsigned zerofill not null DEFAULT 9, |
| 12 |
f181 numeric (64) unsigned zerofill not null DEFAULT 9, |
| 13 |
f182 numeric (0,0) not null DEFAULT 9, |
| 14 |
f183 numeric (63,30) not null DEFAULT 9, |
| 15 |
f184 numeric (0,0) unsigned not null DEFAULT 9, |
| 16 |
f185 numeric (63,30) unsigned not null DEFAULT 9, |
| 17 |
f186 numeric (0,0) zerofill not null DEFAULT 9, |
| 18 |
f187 numeric (63,30) zerofill not null DEFAULT 9, |
| 19 |
f188 numeric (0,0) unsigned zerofill not null DEFAULT 9, |
| 20 |
f189 numeric (63,30) unsigned zerofill not null DEFAULT 9, |
| 21 |
f190 real not null DEFAULT 88.8, |
| 22 |
f191 real unsigned not null DEFAULT 88.8, |
| 23 |
f192 real zerofill not null DEFAULT 88.8, |
| 24 |
f193 real unsigned zerofill not null DEFAULT 88.8, |
| 25 |
f194 double not null DEFAULT 55.5, |
| 26 |
f195 double unsigned not null DEFAULT 55.5, |
| 27 |
f196 double zerofill not null DEFAULT 55.5, |
| 28 |
f197 double unsigned zerofill not null DEFAULT 55.5, |
| 29 |
f198 float, |
| 30 |
f199 float unsigned, |
| 31 |
f200 float zerofill, |
| 32 |
f201 float unsigned zerofill, |
| 33 |
f202 float(0), |
| 34 |
f203 float(23), |
| 35 |
f204 float(0) unsigned, |
| 36 |
f205 float(23) unsigned, |
| 37 |
f206 float(0) zerofill, |
| 38 |
f207 float(23) zerofill, |
| 39 |
f208 float(0) unsigned zerofill, |
| 40 |
f209 float(23) unsigned zerofill, |
| 41 |
f210 float(24), |
| 42 |
f211 float(53), |
| 43 |
f212 float(24) unsigned, |
| 44 |
f213 float(53) unsigned, |
| 45 |
f214 float(24) zerofill, |
| 46 |
f215 float(53) zerofill, |
| 47 |
f216 float(24) unsigned zerofill, |
| 48 |
f217 float(53) unsigned zerofill, |
| 49 |
f218 date, |
| 50 |
f219 time, |
| 51 |
f220 datetime, |
| 52 |
f221 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 53 |
f222 year, |
| 54 |
f225 enum("1enum","2enum"), |
| 55 |
f226 set("1set","2set"), |
| 56 |
f235 char(0), |
| 57 |
f236 char(90), |
| 58 |
f237 char(255) ascii, |
| 59 |
f238 varchar(0), |
| 60 |
f239 varchar(20000) binary, |
| 61 |
f240 varchar(2000), |
| 62 |
f241 char(100) |
| 63 |
) charset latin1 engine = innodb; |
| 64 |
|
| 65 |
--replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR> |
| 66 |
eval |
| 67 |
load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/innodb_tb4.txt' |
| 68 |
into table tb4 CHARACTER SET latin1; |