1##### suite/funcs_1/include/ndb_tb4.inc
2
3--disable_warnings
4drop table if exists tb4;
5--enable_warnings
6create table tb4 (
7f176 numeric (0) unsigned not null DEFAULT 9,
8f177 numeric (64) unsigned not null DEFAULT 9,
9f178 numeric (0) zerofill not null DEFAULT 9,
10f179 numeric (64) zerofill not null DEFAULT 9,
11f180 numeric (0) unsigned zerofill not null DEFAULT 9,
12f181 numeric (64) unsigned zerofill not null DEFAULT 9,
13f182 numeric (0,0) not null DEFAULT 9,
14f183 numeric (63,30) not null DEFAULT 9,
15f184 numeric (0,0) unsigned not null DEFAULT 9,
16f185 numeric (63,30) unsigned not null DEFAULT 9,
17f186 numeric (0,0) zerofill not null DEFAULT 9,
18f187 numeric (63,30) zerofill not null DEFAULT 9,
19f188 numeric (0,0) unsigned zerofill not null DEFAULT 9,
20f189 numeric (63,30) unsigned zerofill not null DEFAULT 9,
21f190 real not null DEFAULT 88.8,
22f191 real unsigned not null DEFAULT 88.8,
23f192 real zerofill not null DEFAULT 88.8,
24f193 real unsigned zerofill not null DEFAULT 88.8,
25f194 double not null DEFAULT 55.5,
26f195 double unsigned not null DEFAULT 55.5,
27f196 double zerofill not null DEFAULT 55.5,
28f197 double unsigned zerofill not null DEFAULT 55.5,
29f198 float,
30f199 float unsigned,
31f200 float zerofill,
32f201 float unsigned zerofill,
33f202 float(0),
34f203 float(23),
35f204 float(0) unsigned,
36f205 float(23) unsigned,
37f206 float(0) zerofill,
38f207 float(23) zerofill,
39f208 float(0) unsigned zerofill,
40f209 float(23) unsigned zerofill,
41f210 float(24),
42f211 float(53),
43f212 float(24) unsigned,
44f213 float(53) unsigned,
45f214 float(24) zerofill,
46f215 float(53) zerofill,
47f216 float(24) unsigned zerofill,
48f217 float(53) unsigned zerofill,
49f218 date,
50f219 time,
51f220 datetime,
52f221 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
53f222 year,
54f223 year(4),
55f224 year(4),
56f225 enum("1enum","2enum"),
57f226 set("1set","2set"),
58f235 char(0) unicode,
59f236 char(90),
60f237 char(255) ascii,
61f238 varchar(0),
62f239 varchar(3000) binary,
63f240 varchar(2000) unicode,
64f241 char(100) unicode
65) engine = ndb;
66
67--replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
68eval
69load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/ndb_tb4.txt'
70into table tb4 ;
71