Debian Codegraph @

mysql-test/suite/storage_engine/col_opt_zerofill.result

raw
1 #
2 # Fixed point columns (NUMERIC, DECIMAL)
3 #
4 DROP TABLE IF EXISTS t1;
5 CREATE TABLE t1 (d DECIMAL ZEROFILL <CUSTOM_COL_OPTIONS>,
6 d0 DECIMAL(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
7 d1_1 DECIMAL(1,1) ZEROFILL <CUSTOM_COL_OPTIONS>,
8 d10_2 DECIMAL(10,2) ZEROFILL <CUSTOM_COL_OPTIONS>,
9 d60_10 DECIMAL(60,10) ZEROFILL <CUSTOM_COL_OPTIONS>,
10 n NUMERIC ZEROFILL <CUSTOM_COL_OPTIONS>,
11 n0_0 NUMERIC(0,0) ZEROFILL <CUSTOM_COL_OPTIONS>,
12 n1 NUMERIC(1) ZEROFILL <CUSTOM_COL_OPTIONS>,
13 n20_4 NUMERIC(20,4) ZEROFILL <CUSTOM_COL_OPTIONS>,
14 n65_4 NUMERIC(65,4) ZEROFILL <CUSTOM_COL_OPTIONS>
15 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
16 SHOW COLUMNS IN t1;
17 Field Type Null Key Default Extra
18 d decimal(10,0) unsigned zerofill # # #
19 d0 decimal(10,0) unsigned zerofill # # #
20 d1_1 decimal(1,1) unsigned zerofill # # #
21 d10_2 decimal(10,2) unsigned zerofill # # #
22 d60_10 decimal(60,10) unsigned zerofill # # #
23 n decimal(10,0) unsigned zerofill # # #
24 n0_0 decimal(10,0) unsigned zerofill # # #
25 n1 decimal(1,0) unsigned zerofill # # #
26 n20_4 decimal(20,4) unsigned zerofill # # #
27 n65_4 decimal(65,4) unsigned zerofill # # #
28 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (100,123456,0.3,40000.25,123456789123456789.10001,1024,7000.0,8.0,999999.9,9223372036854775807);
29 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (0,0,0,0,0,0,0,0,0,0);
30 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (9999999999.0,9999999999.0,0.9,99999999.99,99999999999999999999999999999999999999999999999999.9999999999,9999999999.0,9999999999.0,9.0,9999999999999999.9999,9999999999999999999999999999999999999999999999999999999999999.9999);
31 SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
32 d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4
33 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
34 0000000100 0000123456 0.3 00040000.25 00000000000000000000000000000000123456789123456789.1000100000 0000001024 0000007000 8 0000000000999999.9000 0000000000000000000000000000000000000000009223372036854775807.0000
35 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
36 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (-100,-123456,-0.3,-40000.25,-123456789123456789.10001,-1024,-7000.0,-8.0,-999999.9,-9223372036854775807);
37 Warnings:
38 Warning 1264 Out of range value for column 'd' at row 1
39 Warning 1264 Out of range value for column 'd0' at row 1
40 Warning 1264 Out of range value for column 'd1_1' at row 1
41 Warning 1264 Out of range value for column 'd10_2' at row 1
42 Warning 1264 Out of range value for column 'd60_10' at row 1
43 Warning 1264 Out of range value for column 'n' at row 1
44 Warning 1264 Out of range value for column 'n0_0' at row 1
45 Warning 1264 Out of range value for column 'n1' at row 1
46 Warning 1264 Out of range value for column 'n20_4' at row 1
47 Warning 1264 Out of range value for column 'n65_4' at row 1
48 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (-9999999999.0,-9999999999.0,-0.9,-99999999.99,-99999999999999999999999999999999999999999999999999.9999999999,-9999999999.0,-9999999999.0,-9.0,-9999999999999999.9999,-9999999999999999999999999999999999999999999999999999999999999.9999);
49 Warnings:
50 Warning 1264 Out of range value for column 'd' at row 1
51 Warning 1264 Out of range value for column 'd0' at row 1
52 Warning 1264 Out of range value for column 'd1_1' at row 1
53 Warning 1264 Out of range value for column 'd10_2' at row 1
54 Warning 1264 Out of range value for column 'd60_10' at row 1
55 Warning 1264 Out of range value for column 'n' at row 1
56 Warning 1264 Out of range value for column 'n0_0' at row 1
57 Warning 1264 Out of range value for column 'n1' at row 1
58 Warning 1264 Out of range value for column 'n20_4' at row 1
59 Warning 1264 Out of range value for column 'n65_4' at row 1
60 SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
61 d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4
62 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
63 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
64 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
65 0000000100 0000123456 0.3 00040000.25 00000000000000000000000000000000123456789123456789.1000100000 0000001024 0000007000 8 0000000000999999.9000 0000000000000000000000000000000000000000009223372036854775807.0000
66 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
67 SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1 WHERE n20_4 = 9999999999999999.9999 OR d < 100;
68 d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4
69 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
70 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
71 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
72 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
73 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) SELECT n65_4, n65_4, n65_4, n65_4, n65_4, n65_4, n65_4, n65_4, n65_4, n65_4 FROM t1 WHERE n65_4 = ( SELECT MAX(n65_4) FROM t1 );
74 Warnings:
75 Warning 1264 Out of range value for column 'd' at row 1
76 Warning 1264 Out of range value for column 'd0' at row 1
77 Warning 1264 Out of range value for column 'd1_1' at row 1
78 Warning 1264 Out of range value for column 'd10_2' at row 1
79 Warning 1264 Out of range value for column 'd60_10' at row 1
80 Warning 1264 Out of range value for column 'n' at row 1
81 Warning 1264 Out of range value for column 'n0_0' at row 1
82 Warning 1264 Out of range value for column 'n1' at row 1
83 Warning 1264 Out of range value for column 'n20_4' at row 1
84 SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
85 d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4
86 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
87 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
88 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
89 0000000100 0000123456 0.3 00040000.25 00000000000000000000000000000000123456789123456789.1000100000 0000001024 0000007000 8 0000000000999999.9000 0000000000000000000000000000000000000000009223372036854775807.0000
90 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
91 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
92 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (10000000000.0,10000000000.0,1.1,100000000.99,100000000000000000000000000000000000000000000000000.0,10000000000.0,10000000000.0,10.0,10000000000000000.9999,10000000000000000000000000000000000000000000000000000000000000.9999);
93 Warnings:
94 Warning 1264 Out of range value for column 'd' at row 1
95 Warning 1264 Out of range value for column 'd0' at row 1
96 Warning 1264 Out of range value for column 'd1_1' at row 1
97 Warning 1264 Out of range value for column 'd10_2' at row 1
98 Warning 1264 Out of range value for column 'd60_10' at row 1
99 Warning 1264 Out of range value for column 'n' at row 1
100 Warning 1264 Out of range value for column 'n0_0' at row 1
101 Warning 1264 Out of range value for column 'n1' at row 1
102 Warning 1264 Out of range value for column 'n20_4' at row 1
103 Warning 1264 Out of range value for column 'n65_4' at row 1
104 SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
105 d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4
106 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
107 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
108 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
109 0000000100 0000123456 0.3 00040000.25 00000000000000000000000000000000123456789123456789.1000100000 0000001024 0000007000 8 0000000000999999.9000 0000000000000000000000000000000000000000009223372036854775807.0000
110 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
111 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
112 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
113 INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4) VALUES (9999999999.1,9999999999.1,1.9,99999999.001,99999999999999999999999999999999999999999999999999.99999999991,9999999999.1,9999999999.1,9.1,9999999999999999.00001,9999999999999999999999999999999999999999999999999999999999999.11111);
114 Warnings:
115 Note 1265 Data truncated for column 'd' at row 1
116 Note 1265 Data truncated for column 'd0' at row 1
117 Warning 1264 Out of range value for column 'd1_1' at row 1
118 Note 1265 Data truncated for column 'd10_2' at row 1
119 Note 1265 Data truncated for column 'd60_10' at row 1
120 Note 1265 Data truncated for column 'n' at row 1
121 Note 1265 Data truncated for column 'n0_0' at row 1
122 Note 1265 Data truncated for column 'n1' at row 1
123 Note 1265 Data truncated for column 'n20_4' at row 1
124 Note 1265 Data truncated for column 'n65_4' at row 1
125 SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
126 d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4
127 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
128 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
129 0000000000 0000000000 0.0 00000000.00 00000000000000000000000000000000000000000000000000.0000000000 0000000000 0000000000 0 0000000000000000.0000 0000000000000000000000000000000000000000000000000000000000000.0000
130 0000000100 0000123456 0.3 00040000.25 00000000000000000000000000000000123456789123456789.1000100000 0000001024 0000007000 8 0000000000999999.9000 0000000000000000000000000000000000000000009223372036854775807.0000
131 9999999999 9999999999 0.9 99999999.00 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.0000 9999999999999999999999999999999999999999999999999999999999999.1111
132 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
133 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
134 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999
135 ALTER TABLE t1 ADD COLUMN n66 NUMERIC(66);
136 ERROR 42000: Too big precision 66 specified for 'n66'. Maximum is 65.
137 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(66,6);
138 ERROR 42000: Too big precision 66 specified for 'n66_6'. Maximum is 65.
139 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(66,66);
140 ERROR 42000: Too big scale 66 specified for 'n66_66'. Maximum is 30.
141 DROP TABLE t1;
142 CREATE TABLE t1 (a DECIMAL ZEROFILL <CUSTOM_COL_OPTIONS>,
143 b NUMERIC ZEROFILL <CUSTOM_COL_OPTIONS>
144 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
145 SHOW COLUMNS IN t1;
146 Field Type Null Key Default Extra
147 a decimal(10,0) unsigned zerofill # # # #
148 b decimal(10,0) unsigned zerofill # # # #
149 INSERT INTO t1 (a,b) VALUES (1.1,1234);
150 Warnings:
151 Note 1265 Data truncated for column 'a' at row 1
152 SELECT a,b FROM t1;
153 a b
154 0000000001 0000001234
155 DROP TABLE t1;
156 #
157 # Floating point columns (FLOAT, DOUBLE)
158 #
159 DROP TABLE IF EXISTS t1;
160 CREATE TABLE t1 (f FLOAT ZEROFILL <CUSTOM_COL_OPTIONS>,
161 f0 FLOAT(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
162 r1_1 REAL(1,1) ZEROFILL <CUSTOM_COL_OPTIONS>,
163 f23_0 FLOAT(23) ZEROFILL <CUSTOM_COL_OPTIONS>,
164 f20_3 FLOAT(20,3) ZEROFILL <CUSTOM_COL_OPTIONS>,
165 d DOUBLE ZEROFILL <CUSTOM_COL_OPTIONS>,
166 d1_0 DOUBLE(1,0) ZEROFILL <CUSTOM_COL_OPTIONS>,
167 d10_10 DOUBLE PRECISION (10,10) ZEROFILL <CUSTOM_COL_OPTIONS>,
168 d53 DOUBLE(53,0) ZEROFILL <CUSTOM_COL_OPTIONS>,
169 d53_10 DOUBLE(53,10) ZEROFILL <CUSTOM_COL_OPTIONS>
170 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
171 SHOW COLUMNS IN t1;
172 Field Type Null Key Default Extra
173 f float unsigned zerofill # # #
174 f0 float unsigned zerofill # # #
175 r1_1 double(1,1) unsigned zerofill # # #
176 f23_0 float unsigned zerofill # # #
177 f20_3 float(20,3) unsigned zerofill # # #
178 d double unsigned zerofill # # #
179 d1_0 double(1,0) unsigned zerofill # # #
180 d10_10 double(10,10) unsigned zerofill # # #
181 d53 double(53,0) unsigned zerofill # # #
182 d53_10 double(53,10) unsigned zerofill # # #
183 INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10) VALUES (12345.12345,12345.12345,0.9,123456789.123,56789.987,11111111.111,8.0,0.0123456789,1234566789123456789,99999999999999999.99999999);
184 SELECT f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10 FROM t1;
185 f 0000012345.1
186 d 000000000011111111.111
187 d10_10 0.0123456789
188 d1_0 8
189 d53 00000000000000000000000000000000001234566789123456800
190 d53_10 000000000000000000000000100000000000000000.0000000000
191 f0 0000012345.1
192 f20_3 0000000000056789.988
193 f23_0 000123457000
194 r1_1 0.9
195 INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10) VALUES (0,0,0,0,0,0,0,0,0,0);
196 INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10) VALUES (
197 99999999999999999999999999999999999999,
198 99999999999999999999999999999999999999.9999999999999999,
199 0.9,
200 99999999999999999999999999999999999999.9,
201 99999999999999999.999,
202 999999999999999999999999999999999999999999999999999999999999999999999999999999999,
203 9,
204 0.9999999999,
205 1999999999999999999999999999999999999999999999999999999,
206 19999999999999999999999999999999999999999999.9999999999
207 );
208 Warnings:
209 Warning 1264 Out of range value for column 'd53' at row 1
210 Warning 1264 Out of range value for column 'd53_10' at row 1
211 SELECT f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10 FROM t1;
212 f 0000012345.1
213 d 0000000000000000000000
214 d 0000000000000000001e81
215 d 000000000011111111.111
216 d10_10 0.0000000000
217 d10_10 0.0123456789
218 d10_10 0.9999999999
219 d1_0 0
220 d1_0 8
221 d1_0 9
222 d53 00000000000000000000000000000000000000000000000000000
223 d53 00000000000000000000000000000000001234566789123456800
224 d53 100000000000000000000000000000000000000000000000000000
225 d53_10 000000000000000000000000000000000000000000.0000000000
226 d53_10 000000000000000000000000100000000000000000.0000000000
227 d53_10 10000000000000000000000000000000000000000000.0000000000
228 f 000000000000
229 f 000000001e38
230 f0 000000000000
231 f0 000000001e38
232 f0 0000012345.1
233 f20_3 0000000000000000.000
234 f20_3 0000000000056789.988
235 f20_3 99999998430674940.000
236 f23_0 000000000000
237 f23_0 000000001e38
238 f23_0 000123457000
239 r1_1 0.0
240 r1_1 0.9
241 r1_1 0.9
242 INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10) VALUES (-999999999999999999999999,-99999999999.999999999999,-0.9,-999.99999999999999999999,-99999999999999999.999,-999999999999999999999999999999999999999999999999999999999999-0.999,-9,-.9999999999,-999999999999999999999999999999.99999999999999999999999,-9999999999999999999999999999999999999999999.9999999999);
243 Warnings:
244 Warning 1264 Out of range value for column 'f' at row 1
245 Warning 1264 Out of range value for column 'f0' at row 1
246 Warning 1264 Out of range value for column 'r1_1' at row 1
247 Warning 1264 Out of range value for column 'f23_0' at row 1
248 Warning 1264 Out of range value for column 'f20_3' at row 1
249 Warning 1264 Out of range value for column 'd' at row 1
250 Warning 1264 Out of range value for column 'd1_0' at row 1
251 Warning 1264 Out of range value for column 'd10_10' at row 1
252 Warning 1264 Out of range value for column 'd53' at row 1
253 Warning 1264 Out of range value for column 'd53_10' at row 1
254 SELECT f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10 FROM t1;
255 f 0000012345.1
256 d 0000000000000000000000
257 d 0000000000000000000000
258 d 0000000000000000001e81
259 d 000000000011111111.111
260 d10_10 0.0000000000
261 d10_10 0.0000000000
262 d10_10 0.0123456789
263 d10_10 0.9999999999
264 d1_0 0
265 d1_0 0
266 d1_0 8
267 d1_0 9
268 d53 00000000000000000000000000000000000000000000000000000
269 d53 00000000000000000000000000000000000000000000000000000
270 d53 00000000000000000000000000000000001234566789123456800
271 d53 100000000000000000000000000000000000000000000000000000
272 d53_10 000000000000000000000000000000000000000000.0000000000
273 d53_10 000000000000000000000000000000000000000000.0000000000
274 d53_10 000000000000000000000000100000000000000000.0000000000
275 d53_10 10000000000000000000000000000000000000000000.0000000000
276 f 000000000000
277 f 000000000000
278 f 000000001e38
279 f0 000000000000
280 f0 000000000000
281 f0 000000001e38
282 f0 0000012345.1
283 f20_3 0000000000000000.000
284 f20_3 0000000000000000.000
285 f20_3 0000000000056789.988
286 f20_3 99999998430674940.000
287 f23_0 000000000000
288 f23_0 000000000000
289 f23_0 000000001e38
290 f23_0 000123457000
291 r1_1 0.0
292 r1_1 0.0
293 r1_1 0.9
294 r1_1 0.9
295 SELECT MAX(f), MAX(f0), MAX(r1_1), MAX(f23_0), MAX(f20_3), MAX(d), MAX(d1_0), MAX(d10_10), MAX(d53), MAX(d53_10) FROM t1;
296 MAX(f) 9.999999680285692e37
297 MAX(d) 1e81
298 MAX(d10_10) 0.9999999999
299 MAX(d1_0) 9
300 MAX(d53) 100000000000000000000000000000000000000000000000000000
301 MAX(d53_10) 10000000000000000000000000000000000000000000.0000000000
302 MAX(f0) 9.999999680285692e37
303 MAX(f20_3) 99999998430674940.000
304 MAX(f23_0) 9.999999680285692e37
305 MAX(r1_1) 0.9
306 INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10) SELECT d53_10, d53_10, d53_10, d53_10, d53_10, d53_10, d53_10, d53_10, d53_10, d53_10 FROM t1 ORDER BY d53_10 DESC LIMIT 1;
307 Warnings:
308 Warning 1264 Out of range value for column 'f' at row 1
309 Warning 1264 Out of range value for column 'f0' at row 1
310 Warning 1264 Out of range value for column 'r1_1' at row 1
311 Warning 1264 Out of range value for column 'f23_0' at row 1
312 Warning 1264 Out of range value for column 'f20_3' at row 1
313 Warning 1264 Out of range value for column 'd1_0' at row 1
314 SELECT f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10 FROM t1;
315 f 0000012345.1
316 d 0000000000000000000000
317 d 0000000000000000000000
318 d 0000000000000000001e43
319 d 0000000000000000001e81
320 d 000000000011111111.111
321 d10_10 0.0000000000
322 d10_10 0.0000000000
323 d10_10 0.0123456789
324 d10_10 0.9999999999
325 d10_10 10000000000000000000000000000000000000000000.0000000000
326 d1_0 0
327 d1_0 0
328 d1_0 8
329 d1_0 9
330 d1_0 9
331 d53 00000000000000000000000000000000000000000000000000000
332 d53 00000000000000000000000000000000000000000000000000000
333 d53 00000000000000000000000000000000001234566789123456800
334 d53 00000000010000000000000000000000000000000000000000000
335 d53 100000000000000000000000000000000000000000000000000000
336 d53_10 000000000000000000000000000000000000000000.0000000000
337 d53_10 000000000000000000000000000000000000000000.0000000000
338 d53_10 000000000000000000000000100000000000000000.0000000000
339 d53_10 10000000000000000000000000000000000000000000.0000000000
340 d53_10 10000000000000000000000000000000000000000000.0000000000
341 f 000000000000
342 f 000000000000
343 f 000000001e38
344 f 003.40282e38
345 f0 000000000000
346 f0 000000000000
347 f0 000000001e38
348 f0 0000012345.1
349 f0 003.40282e38
350 f20_3 0000000000000000.000
351 f20_3 0000000000000000.000
352 f20_3 0000000000056789.988
353 f20_3 99999998430674940.000
354 f20_3 99999998430674940.000
355 f23_0 000000000000
356 f23_0 000000000000
357 f23_0 000000001e38
358 f23_0 000123457000
359 f23_0 003.40282e38
360 r1_1 0.0
361 r1_1 0.0
362 r1_1 0.9
363 r1_1 0.9
364 r1_1 0.9
365 INSERT INTO t1 (f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10) VALUES (
366 999999999999999999999999999999999999999,
367 999999999999999999999999999999999999999.9999999999999999,
368 1.9,
369 999999999999999999999999999999999999999.9,
370 999999999999999999.999,
371 9999999999999999999999999999999999999999999999999999999999999999999999999999999999,
372 99,
373 1.9999999999,
374 1999999999999999999999999999999999999999999999999999999,
375 19999999999999999999999999999999999999999999.9999999999
376 );
377 Warnings:
378 Warning 1916 Got overflow when converting '' to DECIMAL. Value truncated
379 Warning 1264 Out of range value for column 'f' at row 1
380 Warning 1264 Out of range value for column 'f0' at row 1
381 Warning 1264 Out of range value for column 'r1_1' at row 1
382 Warning 1264 Out of range value for column 'f23_0' at row 1
383 Warning 1264 Out of range value for column 'f20_3' at row 1
384 Warning 1264 Out of range value for column 'd1_0' at row 1
385 Warning 1264 Out of range value for column 'd10_10' at row 1
386 Warning 1264 Out of range value for column 'd53' at row 1
387 Warning 1264 Out of range value for column 'd53_10' at row 1
388 SELECT f,f0,r1_1,f23_0,f20_3,d,d1_0,d10_10,d53,d53_10 FROM t1;
389 f 0000012345.1
390 d 0000000000000000000000
391 d 0000000000000000000000
392 d 0000000000000000001e43
393 d 0000000000000000001e65
394 d 0000000000000000001e81
395 d 000000000011111111.111
396 d10_10 0.0000000000
397 d10_10 0.0000000000
398 d10_10 0.0123456789
399 d10_10 0.9999999999
400 d10_10 0.9999999999
401 d10_10 10000000000000000000000000000000000000000000.0000000000
402 d1_0 0
403 d1_0 0
404 d1_0 8
405 d1_0 9
406 d1_0 9
407 d1_0 9
408 d53 00000000000000000000000000000000000000000000000000000
409 d53 00000000000000000000000000000000000000000000000000000
410 d53 00000000000000000000000000000000001234566789123456800
411 d53 00000000010000000000000000000000000000000000000000000
412 d53 100000000000000000000000000000000000000000000000000000
413 d53 100000000000000000000000000000000000000000000000000000
414 d53_10 000000000000000000000000000000000000000000.0000000000
415 d53_10 000000000000000000000000000000000000000000.0000000000
416 d53_10 000000000000000000000000100000000000000000.0000000000
417 d53_10 10000000000000000000000000000000000000000000.0000000000
418 d53_10 10000000000000000000000000000000000000000000.0000000000
419 d53_10 10000000000000000000000000000000000000000000.0000000000
420 f 000000000000
421 f 000000000000
422 f 000000001e38
423 f 003.40282e38
424 f 003.40282e38
425 f0 000000000000
426 f0 000000000000
427 f0 000000001e38
428 f0 0000012345.1
429 f0 003.40282e38
430 f0 003.40282e38
431 f20_3 0000000000000000.000
432 f20_3 0000000000000000.000
433 f20_3 0000000000056789.988
434 f20_3 99999998430674940.000
435 f20_3 99999998430674940.000
436 f20_3 99999998430674940.000
437 f23_0 000000000000
438 f23_0 000000000000
439 f23_0 000000001e38
440 f23_0 000123457000
441 f23_0 003.40282e38
442 f23_0 003.40282e38
443 r1_1 0.0
444 r1_1 0.0
445 r1_1 0.9
446 r1_1 0.9
447 r1_1 0.9
448 r1_1 0.9
449 ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0);
450 # ERROR: Statement succeeded (expected results: ER_TOO_BIG_DISPLAYWIDTH)
451 # ------------ UNEXPECTED RESULT ------------
452 # [ ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0) ]
453 # The statement|command succeeded unexpectedly.
454 # ALTER TABLE or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors.
455 # You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
456 # Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
457 # Also, this problem may cause a chain effect (more errors of different kinds in the test).
458 # -------------------------------------------
459 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(256,1);
460 ERROR 42000: Too big precision 256 specified for 'n66_6'. Maximum is 65.
461 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(40,35);
462 ERROR 42000: Too big scale 35 specified for 'n66_66'. Maximum is 30.
463 DROP TABLE t1;
464 CREATE TABLE t1 (a DOUBLE ZEROFILL <CUSTOM_COL_OPTIONS>,
465 b FLOAT ZEROFILL <CUSTOM_COL_OPTIONS>
466 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
467 SHOW COLUMNS IN t1;
468 Field Type Null Key Default Extra
469 a double unsigned zerofill # # # #
470 b float unsigned zerofill # # # #
471 INSERT INTO t1 (a,b) VALUES (1,1234.5);
472 SELECT a,b FROM t1;
473 a b
474 0000000000000000000001 0000001234.5
475 DROP TABLE t1;
476 #
477 # INT columns
478 #
479 DROP TABLE IF EXISTS t1;
480 CREATE TABLE t1 (i INT ZEROFILL <CUSTOM_COL_OPTIONS>,
481 i0 INT(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
482 i1 INT(1) ZEROFILL <CUSTOM_COL_OPTIONS>,
483 i20 INT(20) ZEROFILL <CUSTOM_COL_OPTIONS>,
484 t TINYINT ZEROFILL <CUSTOM_COL_OPTIONS>,
485 t0 TINYINT(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
486 t1 TINYINT(1) ZEROFILL <CUSTOM_COL_OPTIONS>,
487 t20 TINYINT(20) ZEROFILL <CUSTOM_COL_OPTIONS>,
488 s SMALLINT ZEROFILL <CUSTOM_COL_OPTIONS>,
489 s0 SMALLINT(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
490 s1 SMALLINT(1) ZEROFILL <CUSTOM_COL_OPTIONS>,
491 s20 SMALLINT(20) ZEROFILL <CUSTOM_COL_OPTIONS>,
492 m MEDIUMINT ZEROFILL <CUSTOM_COL_OPTIONS>,
493 m0 MEDIUMINT(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
494 m1 MEDIUMINT(1) ZEROFILL <CUSTOM_COL_OPTIONS>,
495 m20 MEDIUMINT(20) ZEROFILL <CUSTOM_COL_OPTIONS>,
496 b BIGINT ZEROFILL <CUSTOM_COL_OPTIONS>,
497 b0 BIGINT(0) ZEROFILL <CUSTOM_COL_OPTIONS>,
498 b1 BIGINT(1) ZEROFILL <CUSTOM_COL_OPTIONS>,
499 b20 BIGINT(20) ZEROFILL <CUSTOM_COL_OPTIONS>
500 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
501 SHOW COLUMNS IN t1;
502 Field Type Null Key Default Extra
503 i int(10) unsigned zerofill # # #
504 i0 int(10) unsigned zerofill # # #
505 i1 int(1) unsigned zerofill # # #
506 i20 int(20) unsigned zerofill # # #
507 t tinyint(3) unsigned zerofill # # #
508 t0 tinyint(3) unsigned zerofill # # #
509 t1 tinyint(1) unsigned zerofill # # #
510 t20 tinyint(20) unsigned zerofill # # #
511 s smallint(5) unsigned zerofill # # #
512 s0 smallint(5) unsigned zerofill # # #
513 s1 smallint(1) unsigned zerofill # # #
514 s20 smallint(20) unsigned zerofill # # #
515 m mediumint(8) unsigned zerofill # # #
516 m0 mediumint(8) unsigned zerofill # # #
517 m1 mediumint(1) unsigned zerofill # # #
518 m20 mediumint(20) unsigned zerofill # # #
519 b bigint(20) unsigned zerofill # # #
520 b0 bigint(20) unsigned zerofill # # #
521 b1 bigint(1) unsigned zerofill # # #
522 b20 bigint(20) unsigned zerofill # # #
523 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);
524 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
525 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (2147483647,2147483647,2147483647,2147483647,127,127,127,127,32767,32767,32767,32767,8388607,8388607,8388607,8388607,9223372036854775807,9223372036854775807,9223372036854775807,9223372036854775807);
526 SELECT i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20 FROM t1;
527 i i0 i1 i20 t t0 t1 t20 s s0 s1 s20 m m0 m1 m20 b b0 b1 b20
528 0000000000 0000000000 0 00000000000000000000 000 000 0 00000000000000000000 00000 00000 0 00000000000000000000 00000000 00000000 0 00000000000000000000 00000000000000000000 00000000000000000000 0 00000000000000000000
529 0000000001 0000000002 3 00000000000000000004 005 006 7 00000000000000000008 00009 00010 11 00000000000000000012 00000013 00000014 15 00000000000000000016 00000000000000000017 00000000000000000018 19 00000000000000000020
530 2147483647 2147483647 2147483647 00000000002147483647 127 127 127 00000000000000000127 32767 32767 32767 00000000000000032767 08388607 08388607 8388607 00000000000008388607 09223372036854775807 09223372036854775807 9223372036854775807 09223372036854775807
531 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (-2147483648,-2147483648,-2147483648,-2147483648,-128,-128,-128,-128,-32768,-32768,-32768,-32768,-8388608,-8388608,-8388608,-8388608,-9223372036854775808,-9223372036854775808,-9223372036854775808,-9223372036854775808);
532 Warnings:
533 Warning 1264 Out of range value for column 'i' at row 1
534 Warning 1264 Out of range value for column 'i0' at row 1
535 Warning 1264 Out of range value for column 'i1' at row 1
536 Warning 1264 Out of range value for column 'i20' at row 1
537 Warning 1264 Out of range value for column 't' at row 1
538 Warning 1264 Out of range value for column 't0' at row 1
539 Warning 1264 Out of range value for column 't1' at row 1
540 Warning 1264 Out of range value for column 't20' at row 1
541 Warning 1264 Out of range value for column 's' at row 1
542 Warning 1264 Out of range value for column 's0' at row 1
543 Warning 1264 Out of range value for column 's1' at row 1
544 Warning 1264 Out of range value for column 's20' at row 1
545 Warning 1264 Out of range value for column 'm' at row 1
546 Warning 1264 Out of range value for column 'm0' at row 1
547 Warning 1264 Out of range value for column 'm1' at row 1
548 Warning 1264 Out of range value for column 'm20' at row 1
549 Warning 1264 Out of range value for column 'b' at row 1
550 Warning 1264 Out of range value for column 'b0' at row 1
551 Warning 1264 Out of range value for column 'b1' at row 1
552 Warning 1264 Out of range value for column 'b20' at row 1
553 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (4294967295,4294967295,4294967295,4294967295,255,255,255,255,65535,65535,65535,65535,16777215,16777215,16777215,16777215,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615);
554 SELECT i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20 FROM t1;
555 i i0 i1 i20 t t0 t1 t20 s s0 s1 s20 m m0 m1 m20 b b0 b1 b20
556 0000000000 0000000000 0 00000000000000000000 000 000 0 00000000000000000000 00000 00000 0 00000000000000000000 00000000 00000000 0 00000000000000000000 00000000000000000000 00000000000000000000 0 00000000000000000000
557 0000000000 0000000000 0 00000000000000000000 000 000 0 00000000000000000000 00000 00000 0 00000000000000000000 00000000 00000000 0 00000000000000000000 00000000000000000000 00000000000000000000 0 00000000000000000000
558 0000000001 0000000002 3 00000000000000000004 005 006 7 00000000000000000008 00009 00010 11 00000000000000000012 00000013 00000014 15 00000000000000000016 00000000000000000017 00000000000000000018 19 00000000000000000020
559 2147483647 2147483647 2147483647 00000000002147483647 127 127 127 00000000000000000127 32767 32767 32767 00000000000000032767 08388607 08388607 8388607 00000000000008388607 09223372036854775807 09223372036854775807 9223372036854775807 09223372036854775807
560 4294967295 4294967295 4294967295 00000000004294967295 255 255 255 00000000000000000255 65535 65535 65535 00000000000000065535 16777215 16777215 16777215 00000000000016777215 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
561 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (-2147483649,-2147483649,-2147483649,-2147483649,-129,-129,-129,-129,-32769,-32769,-32769,-32769,-8388609,-8388609,-8388609,-8388609,-9223372036854775809,-9223372036854775809,-9223372036854775809,-9223372036854775809);
562 Warnings:
563 Warning 1264 Out of range value for column 'i' at row 1
564 Warning 1264 Out of range value for column 'i0' at row 1
565 Warning 1264 Out of range value for column 'i1' at row 1
566 Warning 1264 Out of range value for column 'i20' at row 1
567 Warning 1264 Out of range value for column 't' at row 1
568 Warning 1264 Out of range value for column 't0' at row 1
569 Warning 1264 Out of range value for column 't1' at row 1
570 Warning 1264 Out of range value for column 't20' at row 1
571 Warning 1264 Out of range value for column 's' at row 1
572 Warning 1264 Out of range value for column 's0' at row 1
573 Warning 1264 Out of range value for column 's1' at row 1
574 Warning 1264 Out of range value for column 's20' at row 1
575 Warning 1264 Out of range value for column 'm' at row 1
576 Warning 1264 Out of range value for column 'm0' at row 1
577 Warning 1264 Out of range value for column 'm1' at row 1
578 Warning 1264 Out of range value for column 'm20' at row 1
579 Warning 1264 Out of range value for column 'b' at row 1
580 Warning 1264 Out of range value for column 'b0' at row 1
581 Warning 1264 Out of range value for column 'b1' at row 1
582 Warning 1264 Out of range value for column 'b20' at row 1
583 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (4294967296,4294967296,4294967296,4294967296,256,256,256,256,65536,65536,65536,65536,16777216,16777216,16777216,16777216,18446744073709551616,18446744073709551616,18446744073709551616,18446744073709551616);
584 Warnings:
585 Warning 1264 Out of range value for column 'i' at row 1
586 Warning 1264 Out of range value for column 'i0' at row 1
587 Warning 1264 Out of range value for column 'i1' at row 1
588 Warning 1264 Out of range value for column 'i20' at row 1
589 Warning 1264 Out of range value for column 't' at row 1
590 Warning 1264 Out of range value for column 't0' at row 1
591 Warning 1264 Out of range value for column 't1' at row 1
592 Warning 1264 Out of range value for column 't20' at row 1
593 Warning 1264 Out of range value for column 's' at row 1
594 Warning 1264 Out of range value for column 's0' at row 1
595 Warning 1264 Out of range value for column 's1' at row 1
596 Warning 1264 Out of range value for column 's20' at row 1
597 Warning 1264 Out of range value for column 'm' at row 1
598 Warning 1264 Out of range value for column 'm0' at row 1
599 Warning 1264 Out of range value for column 'm1' at row 1
600 Warning 1264 Out of range value for column 'm20' at row 1
601 Warning 1264 Out of range value for column 'b' at row 1
602 Warning 1264 Out of range value for column 'b0' at row 1
603 Warning 1264 Out of range value for column 'b1' at row 1
604 Warning 1264 Out of range value for column 'b20' at row 1
605 INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) SELECT b,b,b,b,b,b,b,b,b,b,b,b,b,b,b,b,b,b,b,b FROM t1 WHERE b IN (-9223372036854775808,9223372036854775807,18446744073709551615);
606 Warnings:
607 Warning 1264 Out of range value for column 'i' at row 1
608 Warning 1264 Out of range value for column 'i0' at row 1
609 Warning 1264 Out of range value for column 'i1' at row 1
610 Warning 1264 Out of range value for column 'i20' at row 1
611 Warning 1264 Out of range value for column 't' at row 1
612 Warning 1264 Out of range value for column 't0' at row 1
613 Warning 1264 Out of range value for column 't1' at row 1
614 Warning 1264 Out of range value for column 't20' at row 1
615 Warning 1264 Out of range value for column 's' at row 1
616 Warning 1264 Out of range value for column 's0' at row 1
617 Warning 1264 Out of range value for column 's1' at row 1
618 Warning 1264 Out of range value for column 's20' at row 1
619 Warning 1264 Out of range value for column 'm' at row 1
620 Warning 1264 Out of range value for column 'm0' at row 1
621 Warning 1264 Out of range value for column 'm1' at row 1
622 Warning 1264 Out of range value for column 'm20' at row 1
623 Warning 1264 Out of range value for column 'i' at row 2
624 Warning 1264 Out of range value for column 'i0' at row 2
625 Warning 1264 Out of range value for column 'i1' at row 2
626 Warning 1264 Out of range value for column 'i20' at row 2
627 Warning 1264 Out of range value for column 't' at row 2
628 Warning 1264 Out of range value for column 't0' at row 2
629 Warning 1264 Out of range value for column 't1' at row 2
630 Warning 1264 Out of range value for column 't20' at row 2
631 Warning 1264 Out of range value for column 's' at row 2
632 Warning 1264 Out of range value for column 's0' at row 2
633 Warning 1264 Out of range value for column 's1' at row 2
634 Warning 1264 Out of range value for column 's20' at row 2
635 Warning 1264 Out of range value for column 'm' at row 2
636 Warning 1264 Out of range value for column 'm0' at row 2
637 Warning 1264 Out of range value for column 'm1' at row 2
638 Warning 1264 Out of range value for column 'm20' at row 2
639 Warning 1264 Out of range value for column 'i' at row 3
640 Warning 1264 Out of range value for column 'i0' at row 3
641 Warning 1264 Out of range value for column 'i1' at row 3
642 Warning 1264 Out of range value for column 'i20' at row 3
643 Warning 1264 Out of range value for column 't' at row 3
644 Warning 1264 Out of range value for column 't0' at row 3
645 Warning 1264 Out of range value for column 't1' at row 3
646 Warning 1264 Out of range value for column 't20' at row 3
647 Warning 1264 Out of range value for column 's' at row 3
648 Warning 1264 Out of range value for column 's0' at row 3
649 Warning 1264 Out of range value for column 's1' at row 3
650 Warning 1264 Out of range value for column 's20' at row 3
651 Warning 1264 Out of range value for column 'm' at row 3
652 Warning 1264 Out of range value for column 'm0' at row 3
653 Warning 1264 Out of range value for column 'm1' at row 3
654 Warning 1264 Out of range value for column 'm20' at row 3
655 SELECT i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20 FROM t1;
656 i i0 i1 i20 t t0 t1 t20 s s0 s1 s20 m m0 m1 m20 b b0 b1 b20
657 0000000000 0000000000 0 00000000000000000000 000 000 0 00000000000000000000 00000 00000 0 00000000000000000000 00000000 00000000 0 00000000000000000000 00000000000000000000 00000000000000000000 0 00000000000000000000
658 0000000000 0000000000 0 00000000000000000000 000 000 0 00000000000000000000 00000 00000 0 00000000000000000000 00000000 00000000 0 00000000000000000000 00000000000000000000 00000000000000000000 0 00000000000000000000
659 0000000000 0000000000 0 00000000000000000000 000 000 0 00000000000000000000 00000 00000 0 00000000000000000000 00000000 00000000 0 00000000000000000000 00000000000000000000 00000000000000000000 0 00000000000000000000
660 0000000001 0000000002 3 00000000000000000004 005 006 7 00000000000000000008 00009 00010 11 00000000000000000012 00000013 00000014 15 00000000000000000016 00000000000000000017 00000000000000000018 19 00000000000000000020
661 2147483647 2147483647 2147483647 00000000002147483647 127 127 127 00000000000000000127 32767 32767 32767 00000000000000032767 08388607 08388607 8388607 00000000000008388607 09223372036854775807 09223372036854775807 9223372036854775807 09223372036854775807
662 4294967295 4294967295 4294967295 00000000004294967295 255 255 255 00000000000000000255 65535 65535 65535 00000000000000065535 16777215 16777215 16777215 00000000000016777215 09223372036854775807 09223372036854775807 9223372036854775807 09223372036854775807
663 4294967295 4294967295 4294967295 00000000004294967295 255 255 255 00000000000000000255 65535 65535 65535 00000000000000065535 16777215 16777215 16777215 00000000000016777215 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
664 4294967295 4294967295 4294967295 00000000004294967295 255 255 255 00000000000000000255 65535 65535 65535 00000000000000065535 16777215 16777215 16777215 00000000000016777215 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
665 4294967295 4294967295 4294967295 00000000004294967295 255 255 255 00000000000000000255 65535 65535 65535 00000000000000065535 16777215 16777215 16777215 00000000000016777215 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
666 4294967295 4294967295 4294967295 00000000004294967295 255 255 255 00000000000000000255 65535 65535 65535 00000000000000065535 16777215 16777215 16777215 00000000000016777215 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615
667 ALTER TABLE t1 ADD COLUMN i257 INT(257);
668 ERROR 42000: Display width out of range for 'i257' (max = 255)
669 DROP TABLE t1;
670 CREATE TABLE t1 (t TINYINT ZEROFILL <CUSTOM_COL_OPTIONS>,
671 s SMALLINT ZEROFILL <CUSTOM_COL_OPTIONS>,
672 m MEDIUMINT ZEROFILL <CUSTOM_COL_OPTIONS>,
673 i INT ZEROFILL <CUSTOM_COL_OPTIONS>,
674 b BIGINT ZEROFILL <CUSTOM_COL_OPTIONS>
675 ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
676 SHOW COLUMNS IN t1;
677 Field Type Null Key Default Extra
678 t tinyint(3) unsigned zerofill # # # #
679 s smallint(5) unsigned zerofill # # # #
680 m mediumint(8) unsigned zerofill # # # #
681 i int(10) unsigned zerofill # # # #
682 b bigint(20) unsigned zerofill # # # #
683 INSERT INTO t1 (t,s,m,i,b) VALUES (1,10,100,1000,0);
684 SELECT t,s,m,i,b FROM t1;
685 t s m i b
686 001 00010 00000100 0000001000 00000000000000000000
687 DROP TABLE t1;