1 ##### suite/funcs_1/include/innodb_tb3.inc
4 drop
table if exists 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',
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,
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,
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,
60 f171 numeric
unsigned,
61 f172 numeric zerofill,
62 f173 numeric
unsigned zerofill,
67 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
69 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/innodb_tb3.txt'