| 1 |
##### suite/funcs_1/include/ndb_tb2.inc |
| 2 |
|
| 3 |
--disable_warnings |
| 4 |
drop table if exists tb2 ; |
| 5 |
--enable_warnings |
| 6 |
create table tb2 ( |
| 7 |
f59 numeric (0) unsigned, |
| 8 |
f60 numeric (64) unsigned, |
| 9 |
f61 numeric (0) zerofill, |
| 10 |
f62 numeric (64) zerofill, |
| 11 |
f63 numeric (0) unsigned zerofill, |
| 12 |
f64 numeric (64) unsigned zerofill, |
| 13 |
f65 numeric (0,0), |
| 14 |
f66 numeric (63,30), |
| 15 |
f67 numeric (0,0) unsigned, |
| 16 |
f68 numeric (63,30) unsigned, |
| 17 |
f69 numeric (0,0) zerofill, |
| 18 |
f70 numeric (63,30) zerofill, |
| 19 |
f71 numeric (0,0) unsigned zerofill, |
| 20 |
f72 numeric (63,30) unsigned zerofill, |
| 21 |
f73 real, |
| 22 |
f74 real unsigned, |
| 23 |
f75 real zerofill, |
| 24 |
f76 real unsigned zerofill, |
| 25 |
f77 double default 7.7, |
| 26 |
f78 double unsigned default 7.7, |
| 27 |
f79 double zerofill default 7.7, |
| 28 |
f80 double unsigned zerofill default 8.8, |
| 29 |
f81 float not null default 8.8, |
| 30 |
f82 float unsigned not null default 8.8, |
| 31 |
f83 float zerofill not null default 8.8, |
| 32 |
f84 float unsigned zerofill not null default 8.8, |
| 33 |
f85 float(0) not null default 8.8, |
| 34 |
f86 float(23) not null default 8.8, |
| 35 |
f87 float(0) unsigned not null default 8.8, |
| 36 |
f88 float(23) unsigned not null default 8.8, |
| 37 |
f89 float(0) zerofill not null default 8.8, |
| 38 |
f90 float(23) zerofill not null default 8.8, |
| 39 |
f91 float(0) unsigned zerofill not null default 8.8, |
| 40 |
f92 float(23) unsigned zerofill not null default 8.8, |
| 41 |
f93 float(24) not null default 8.8, |
| 42 |
f94 float(53) not null default 8.8, |
| 43 |
f95 float(24) unsigned not null default 8.8, |
| 44 |
f96 float(53) unsigned not null default 8.8, |
| 45 |
f97 float(24) zerofill not null default 8.8, |
| 46 |
f98 float(53) zerofill not null default 8.8, |
| 47 |
f99 float(24) unsigned zerofill not null default 8.8, |
| 48 |
f100 float(53) unsigned zerofill not null default 8.8, |
| 49 |
f101 date not null default '2000-01-01', |
| 50 |
f102 time not null default 20, |
| 51 |
f103 datetime not null default '2/2/2', |
| 52 |
f104 timestamp not null default 20001231235959, |
| 53 |
f105 year not null default 2000, |
| 54 |
f106 year(4) not null default 2000, |
| 55 |
f107 year(4) not null default 2000, |
| 56 |
f108 enum("1enum","2enum") not null default "1enum", |
| 57 |
f109 set("1set","2set") not null default "1set" |
| 58 |
) engine = ndb; |
| 59 |
|
| 60 |
--replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR> |
| 61 |
eval |
| 62 |
load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/ndb_tb2.txt' |
| 63 |
into table tb2 ; |