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