2
drop table if exists tb2 ;
4
f59 numeric (0) unsigned,
5
f60 numeric (64) unsigned,
6
f61 numeric (0) zerofill,
7
f62 numeric (64) zerofill,
8
f63 numeric (0) unsigned zerofill,
9
f64 numeric (64) unsigned zerofill,
12
f67 numeric (0,0) unsigned,
13
f68 numeric (63,30) unsigned,
14
f69 numeric (0,0) zerofill,
15
f70 numeric (63,30) zerofill,
16
f71 numeric (0,0) unsigned zerofill,
17
f72 numeric (63,30) unsigned zerofill,
21
f76 real unsigned zerofill,
22
f77 double default 7.7,
23
f78 double unsigned default 7.7,
24
f79 double zerofill default 7.7,
25
f80 double unsigned zerofill default 8.8,
26
f81 float not null default 8.8,
27
f82 float unsigned not null default 8.8,
28
f83 float zerofill not null default 8.8,
29
f84 float unsigned zerofill not null default 8.8,
30
f85 float(0) not null default 8.8,
31
f86 float(23) not null default 8.8,
32
f87 float(0) unsigned not null default 8.8,
33
f88 float(23) unsigned not null default 8.8,
34
f89 float(0) zerofill not null default 8.8,
35
f90 float(23) zerofill not null default 8.8,
36
f91 float(0) unsigned zerofill not null default 8.8,
37
f92 float(23) unsigned zerofill not null default 8.8,
38
f93 float(24) not null default 8.8,
39
f94 float(53) not null default 8.8,
40
f95 float(24) unsigned not null default 8.8,
41
f96 float(53) unsigned not null default 8.8,
42
f97 float(24) zerofill not null default 8.8,
43
f98 float(53) zerofill not null default 8.8,
44
f99 float(24) unsigned zerofill not null default 8.8,
45
f100 float(53) unsigned zerofill not null default 8.8,
46
f101 date not null default '2000-01-01',
47
f102 time not null default 20,
48
f103 datetime not null default '2/2/2',
49
f104 timestamp not null default 20001231235959,
50
f105 year not null default 2000,
51
f106 year(3) not null default 2000,
52
f107 year(4) not null default 2000,
53
f108 enum("1enum","2enum") not null default "1enum",
54
f109 set("1set","2set") not null default "1set",
55
f110 VARBINARY(64) null,
56
f111 VARBINARY(27) null ,
57
f112 VARBINARY(64) null ,
58
f113 VARBINARY(192) null ,
60
f115 VARBINARY(27) null ,
61
f116 VARBINARY(64) null,
62
f117 VARBINARY(192) null
64
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb2.txt' into table tb2 ;
65
DROP DATABASE IF EXISTS test1;
66
CREATE DATABASE test1;
68
drop table if exists tb2 ;
70
f59 numeric (0) unsigned,
71
f60 numeric (64) unsigned,
72
f61 numeric (0) zerofill,
73
f62 numeric (64) zerofill,
74
f63 numeric (0) unsigned zerofill,
75
f64 numeric (64) unsigned zerofill,
78
f67 numeric (0,0) unsigned,
79
f68 numeric (63,30) unsigned,
80
f69 numeric (0,0) zerofill,
81
f70 numeric (63,30) zerofill,
82
f71 numeric (0,0) unsigned zerofill,
83
f72 numeric (63,30) unsigned zerofill,
87
f76 real unsigned zerofill,
88
f77 double default 7.7,
89
f78 double unsigned default 7.7,
90
f79 double zerofill default 7.7,
91
f80 double unsigned zerofill default 8.8,
92
f81 float not null default 8.8,
93
f82 float unsigned not null default 8.8,
94
f83 float zerofill not null default 8.8,
95
f84 float unsigned zerofill not null default 8.8,
96
f85 float(0) not null default 8.8,
97
f86 float(23) not null default 8.8,
98
f87 float(0) unsigned not null default 8.8,
99
f88 float(23) unsigned not null default 8.8,
100
f89 float(0) zerofill not null default 8.8,
101
f90 float(23) zerofill not null default 8.8,
102
f91 float(0) unsigned zerofill not null default 8.8,
103
f92 float(23) unsigned zerofill not null default 8.8,
104
f93 float(24) not null default 8.8,
105
f94 float(53) not null default 8.8,
106
f95 float(24) unsigned not null default 8.8,
107
f96 float(53) unsigned not null default 8.8,
108
f97 float(24) zerofill not null default 8.8,
109
f98 float(53) zerofill not null default 8.8,
110
f99 float(24) unsigned zerofill not null default 8.8,
111
f100 float(53) unsigned zerofill not null default 8.8,
112
f101 date not null default '2000-01-01',
113
f102 time not null default 20,
114
f103 datetime not null default '2/2/2',
115
f104 timestamp not null default 20001231235959,
116
f105 year not null default 2000,
117
f106 year(3) not null default 2000,
118
f107 year(4) not null default 2000,
119
f108 enum("1enum","2enum") not null default "1enum",
120
f109 set("1set","2set") not null default "1set",
121
f110 VARBINARY(64) null,
122
f111 VARBINARY(27) null ,
123
f112 VARBINARY(64) null ,
124
f113 VARBINARY(192) null ,
125
f114 VARBINARY(192) ,
126
f115 VARBINARY(27) null ,
127
f116 VARBINARY(64) null,
128
f117 VARBINARY(192) null
130
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/myisam_tb2.txt' into table tb2 ;
133
Attention: The nesting level @max_level in Testcase 3.3.1.A6
134
(Complicated nested VIEWs) has to be limited to 20 because of
135
MyISAM(only) performance issues Bug#11948
136
--------------------------------------------------------------------------------
139
! Attention: The file with the expected results is not
140
| thoroughly checked.
141
! The server return codes are correct, but
142
| most result sets where the table tb2 is
143
! involved are not checked.
144
--------------------------------------------------------------------------------
146
There are some statements where the ps-protocol is switched off.
147
Bug#32285: mysqltest, --ps-protocol, strange output, float/double/real with zerofill
148
--------------------------------------------------------------------------------
149
insert into test.tb2 (f59,f60) values (76710,226546);
150
insert into test.tb2 (f59,f60) values(2760,985654);
151
insert into test.tb2 (f59,f60) values(569300,9114376);
152
insert into test.tb2 (f59,f60) values(660,876546);
153
insert into test.tb2 (f59,f60) values(250,87895654);
154
insert into test.tb2 (f59,f60) values(340,9984376);
155
insert into test.tb2 (f59,f60) values(3410,996546);
156
insert into test.tb2 (f59,f60) values(2550,775654);
157
insert into test.tb2 (f59,f60) values(3330,764376);
158
insert into test.tb2 (f59,f60) values(441,16546);
159
insert into test.tb2 (f59,f60) values(24,51654);
160
insert into test.tb2 (f59,f60) values(323,14376);
161
insert into test.tb2 (f59,f60) values(34,41);
162
insert into test.tb2 (f59,f60) values(04,74);
163
insert into test.tb2 (f59,f60) values(15,87);
164
insert into test.tb2 (f59,f60) values(22,93);
165
insert into test.tb2 (f59,f60) values(394,41);
166
insert into test.tb2 (f59,f60) values(094,74);
167
insert into test.tb2 (f59,f60) values(195,87);
168
insert into test.tb2 (f59,f60) values(292,93);
169
insert into test.tb2 (f59,f60) values(0987,41) ;
170
insert into test.tb2 (f59,f60) values(7876,74) ;
171
INSERT INTO tb2 (f59,f61) VALUES(321,765 );
172
INSERT INTO tb2 (f59,f61) VALUES(9112,8771);
173
INSERT INTO tb2 (f59,f61) VALUES (500,900 ) ;
174
INSERT INTO tb2 (f59,f61) VALUES (500,900 ) ;
175
INSERT INTO tb2 (f59,f61) VALUES (500,900 ) ;
176
Insert into tb2 (f59,f60,f61) values (107,105,106) ;
177
Insert into tb2 (f59,f60,f61) values (109,108,104) ;
178
Insert into tb2 (f59,f60,f61) values (207,205,206) ;
179
Insert into tb2 (f59,f60,f61) values (209,208,204) ;
180
Insert into tb2 (f59,f60,f61) values (27,25,26) ;
181
Insert into tb2 (f59,f60,f61) values (29,28,24) ;
182
Insert into tb2 (f59,f60,f61) values (17,15,16) ;
183
Insert into tb2 (f59,f60,f61) values (19,18,14) ;
184
insert into tb2 (f59,f60,f61) values (107,105,106);
185
insert into tb2 (f59,f60,f61) values (109,108,104);
186
INSERT INTO tb2 (f59,f60) VALUES( 299,899 );
187
INSERT INTO tb2 (f59,f60) VALUES( 242,79 );
188
INSERT INTO tb2 (f59,f60) VALUES( 424,89 );
189
SELECT * FROM tb2 ORDER BY f59, f60, f61;
190
f59 f60 f61 f62 f63 f64 f65 f66 f67 f68 f69 f70 f71 f72 f73 f74 f75 f76 f77 f78 f79 f80 f81 f82 f83 f84 f85 f86 f87 f88 f89 f90 f91 f92 f93 f94 f95 f96 f97 f98 f99 f100 f101 f102 f103 f104 f105 f106 f107 f108 f109 f110 f111 f112 f113 f114 f115 f116 f117
191
1 1 0000000001 0000000000000000000000000000000000000000000000000000000000000001 0000000001 0000000000000000000000000000000000000000000000000000000000000001 -5 0.000000000000000000000000000000 1 0.000000000000000000000000000000 0000000001 000000000000000000000000000000000.000000000000000000000000000000 0000000001 000000000000000000000000000000000.000000000000000000000000000000 -1.17549435e-38 1.175494352e-38 00000001.175494352e-38 00000001.175494352e-38 -1.17549435e-38 1.175494352e-38 00000001.175494352e-38 00000001.175494352e-38 -1.17549e-38 1.17549e-38 01.17549e-38 01.17549e-38 -1.17549e-38 -1.17549e-38 1.17549e-38 1.17549e-38 01.17549e-38 01.17549e-38 01.17549e-38 01.17549e-38 -1.17549e-38 -1.17549435e-38 1.17549e-38 1.175494352e-38 01.17549e-38 00000001.175494352e-38 01.17549e-38 00000001.175494352e-38 1000-01-01 838:59:58 1970-01-02 00:00:01 1970-01-02 00:00:01 1902 1902 1902 2enum 2set