| 1 |
##### suite/funcs_1/include/memory_tb1.inc |
| 2 |
|
| 3 |
--disable_warnings |
| 4 |
drop table if exists tb1 ; |
| 5 |
--enable_warnings |
| 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 |
|
| 59 |
--replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR> |
| 60 |
eval |
| 61 |
load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/memory_tb1.txt' |
| 62 |
into table tb1 character set latin1; |