| 1 |
##### suite/funcs_1/include/innodb_tb3.inc |
| 2 |
|
| 3 |
--disable_warnings |
| 4 |
drop table if exists tb3 ; |
| 5 |
--enable_warnings |
| 6 |
create table tb3 ( |
| 7 |
f118 char not null DEFAULT 'a', |
| 8 |
f119 char binary not null DEFAULT b'101', |
| 9 |
f120 char ascii not null DEFAULT b'101', |
| 10 |
f121 tinytext, |
| 11 |
f122 text, |
| 12 |
f123 mediumtext, |
| 13 |
f124 longtext, |
| 14 |
f125 tinyblob, |
| 15 |
f126 blob, |
| 16 |
f127 mediumblob, |
| 17 |
f128 longblob, |
| 18 |
f129 binary not null DEFAULT b'101', |
| 19 |
f130 tinyint not null DEFAULT 99, |
| 20 |
f131 tinyint unsigned not null DEFAULT 99, |
| 21 |
f132 tinyint zerofill not null DEFAULT 99, |
| 22 |
f133 tinyint unsigned zerofill not null DEFAULT 99, |
| 23 |
f134 smallint not null DEFAULT 999, |
| 24 |
f135 smallint unsigned not null DEFAULT 999, |
| 25 |
f136 smallint zerofill not null DEFAULT 999, |
| 26 |
f137 smallint unsigned zerofill not null DEFAULT 999, |
| 27 |
f138 mediumint not null DEFAULT 9999, |
| 28 |
f139 mediumint unsigned not null DEFAULT 9999, |
| 29 |
f140 mediumint zerofill not null DEFAULT 9999, |
| 30 |
f141 mediumint unsigned zerofill not null DEFAULT 9999, |
| 31 |
f142 int not null DEFAULT 99999, |
| 32 |
f143 int unsigned not null DEFAULT 99999, |
| 33 |
f144 int zerofill not null DEFAULT 99999, |
| 34 |
f145 int unsigned zerofill not null DEFAULT 99999, |
| 35 |
f146 bigint not null DEFAULT 999999, |
| 36 |
f147 bigint unsigned not null DEFAULT 999999, |
| 37 |
f148 bigint zerofill not null DEFAULT 999999, |
| 38 |
f149 bigint unsigned zerofill not null DEFAULT 999999, |
| 39 |
f150 decimal not null DEFAULT 999.999, |
| 40 |
f151 decimal unsigned not null DEFAULT 999.17, |
| 41 |
f152 decimal zerofill not null DEFAULT 999.999, |
| 42 |
f153 decimal unsigned zerofill, |
| 43 |
f154 decimal (0), |
| 44 |
f155 decimal (64), |
| 45 |
f156 decimal (0) unsigned, |
| 46 |
f157 decimal (64) unsigned, |
| 47 |
f158 decimal (0) zerofill, |
| 48 |
f159 decimal (64) zerofill, |
| 49 |
f160 decimal (0) unsigned zerofill, |
| 50 |
f161 decimal (64) unsigned zerofill, |
| 51 |
f162 decimal (0,0), |
| 52 |
f163 decimal (63,30), |
| 53 |
f164 decimal (0,0) unsigned, |
| 54 |
f165 decimal (63,30) unsigned, |
| 55 |
f166 decimal (0,0) zerofill, |
| 56 |
f167 decimal (63,30) zerofill, |
| 57 |
f168 decimal (0,0) unsigned zerofill, |
| 58 |
f169 decimal (63,30) unsigned zerofill, |
| 59 |
f170 numeric, |
| 60 |
f171 numeric unsigned, |
| 61 |
f172 numeric zerofill, |
| 62 |
f173 numeric unsigned zerofill, |
| 63 |
f174 numeric (0), |
| 64 |
f175 numeric (64) |
| 65 |
) charset latin1 engine = innodb; |
| 66 |
|
| 67 |
--replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR> |
| 68 |
eval |
| 69 |
load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/innodb_tb3.txt' |
| 70 |
into table tb3 CHARACTER SET latin1; |