1##### suite/funcs_1/include/ndb_tb1.inc
2
3--disable_warnings
4drop table if exists tb1 ;
5--enable_warnings
6create table tb1 (
7f1 char(0),
8f2 char(0) binary,
9f3 char(0) ascii,
10f4 tinytext unicode,
11f5 text,
12f6 mediumtext,
13f7 longtext,
14f8 tinyblob,
15f9 blob,
16f10 mediumblob,
17f11 longblob,
18f12 binary,
19f13 tinyint,
20f14 tinyint unsigned,
21f15 tinyint zerofill,
22f16 tinyint unsigned zerofill,
23f17 smallint,
24f18 smallint unsigned,
25f19 smallint zerofill,
26f20 smallint unsigned zerofill,
27f21 mediumint,
28f22 mediumint unsigned,
29f23 mediumint zerofill,
30f24 mediumint unsigned zerofill,
31f25 int,
32f26 int unsigned,
33f27 int zerofill,
34f28 int unsigned zerofill,
35f29 bigint,
36f30 bigint unsigned,
37f31 bigint zerofill,
38f32 bigint unsigned zerofill,
39f33 decimal,
40f34 decimal unsigned,
41f35 decimal zerofill,
42f36 decimal unsigned zerofill not null DEFAULT 9.9,
43f37 decimal (0) not null DEFAULT 9.9,
44f38 decimal (64) not null DEFAULT 9.9,
45f39 decimal (0) unsigned not null DEFAULT 9.9,
46f40 decimal (64) unsigned not null DEFAULT 9.9,
47f41 decimal (0) zerofill not null DEFAULT 9.9,
48f42 decimal (64) zerofill not null DEFAULT 9.9,
49f43 decimal (0) unsigned zerofill not null DEFAULT 9.9,
50f44 decimal (64) unsigned zerofill not null DEFAULT 9.9,
51f45 decimal (0,0) not null DEFAULT 9.9,
52f46 decimal (63,30) not null DEFAULT 9.9,
53f47 decimal (0,0) unsigned not null DEFAULT 9.9,
54f48 decimal (63,30) unsigned not null DEFAULT 9.9,
55f49 decimal (0,0) zerofill not null DEFAULT 9.9,
56f50 decimal (63,30) zerofill not null DEFAULT 9.9,
57f51 decimal (0,0) unsigned zerofill not null DEFAULT 9.9,
58f52 decimal (63,30) unsigned zerofill not null DEFAULT 9.9,
59f53 numeric not null DEFAULT 99,
60f54 numeric unsigned not null DEFAULT 99,
61f55 numeric zerofill not null DEFAULT 99,
62f56 numeric unsigned zerofill not null DEFAULT 99,
63f57 numeric (0) not null DEFAULT 99,
64f58 numeric (64) not null DEFAULT 99
65) engine = ndb;
66
67--replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
68eval
69load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/ndb_tb1.txt'
70into table tb1 ;
71