|
1
by brian
clean slate |
1 |
##### suite/funcs_1/include/memory_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 char(50), |
|
11 |
f122 char(50), |
|
12 |
f129 binary not null DEFAULT b'101', |
|
13 |
f130 tinyint not null DEFAULT 99, |
|
14 |
f131 tinyint unsigned not null DEFAULT 99, |
|
15 |
f132 tinyint zerofill not null DEFAULT 99, |
|
16 |
f133 tinyint unsigned zerofill not null DEFAULT 99, |
|
17 |
f134 smallint not null DEFAULT 999, |
|
18 |
f135 smallint unsigned not null DEFAULT 999, |
|
19 |
f136 smallint zerofill not null DEFAULT 999, |
|
20 |
f137 smallint unsigned zerofill not null DEFAULT 999, |
|
21 |
f138 mediumint not null DEFAULT 9999, |
|
22 |
f139 mediumint unsigned not null DEFAULT 9999, |
|
23 |
f140 mediumint zerofill not null DEFAULT 9999, |
|
24 |
f141 mediumint unsigned zerofill not null DEFAULT 9999, |
|
25 |
f142 int not null DEFAULT 99999, |
|
26 |
f143 int unsigned not null DEFAULT 99999, |
|
27 |
f144 int zerofill not null DEFAULT 99999, |
|
28 |
f145 int unsigned zerofill not null DEFAULT 99999, |
|
29 |
f146 bigint not null DEFAULT 999999, |
|
30 |
f147 bigint unsigned not null DEFAULT 999999, |
|
31 |
f148 bigint zerofill not null DEFAULT 999999, |
|
32 |
f149 bigint unsigned zerofill not null DEFAULT 999999, |
|
33 |
f150 decimal not null DEFAULT 999.999, |
|
34 |
f151 decimal unsigned not null DEFAULT 999.17, |
|
35 |
f152 decimal zerofill not null DEFAULT 999.999, |
|
36 |
f153 decimal unsigned zerofill, |
|
37 |
f154 decimal (0), |
|
38 |
f155 decimal (64), |
|
39 |
f156 decimal (0) unsigned, |
|
40 |
f157 decimal (64) unsigned, |
|
41 |
f158 decimal (0) zerofill, |
|
42 |
f159 decimal (64) zerofill, |
|
43 |
f160 decimal (0) unsigned zerofill, |
|
44 |
f161 decimal (64) unsigned zerofill, |
|
45 |
f162 decimal (0,0), |
|
46 |
f163 decimal (63,30), |
|
47 |
f164 decimal (0,0) unsigned, |
|
48 |
f165 decimal (63,30) unsigned, |
|
49 |
f166 decimal (0,0) zerofill, |
|
50 |
f167 decimal (63,30) zerofill, |
|
51 |
f168 decimal (0,0) unsigned zerofill, |
|
52 |
f169 decimal (63,30) unsigned zerofill, |
|
53 |
f170 numeric, |
|
54 |
f171 numeric unsigned, |
|
55 |
f172 numeric zerofill, |
|
56 |
f173 numeric unsigned zerofill, |
|
57 |
f174 numeric (0), |
|
58 |
f175 numeric (64) |
|
59 |
) engine = memory; |
|
60 |
||
61 |
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR |
|
62 |
eval load data infile '$MYSQL_TEST_DIR/suite/funcs_1/data/memory_tb3.txt' into table tb3 ; |
|
63 |