1
DROP TABLE IF EXISTS t5;
2
CREATE TABLE t5(c1 BIT(2) PRIMARY KEY) ENGINE = <default_engine>;
3
INSERT INTO t5 VALUES (0), (1), (2);
4
SELECT HEX(c1) FROM t5 ORDER BY c1;
9
SELECT HEX(c1) FROM t5 WHERE c1 = b'1' ORDER BY c1;
12
SELECT HEX(c1) FROM t5 WHERE c1 <=> b'1' ORDER BY c1;
15
SELECT HEX(c1) FROM t5 WHERE c1 != b'1' ORDER BY c1;
19
SELECT HEX(c1) FROM t5 WHERE c1 >= '1' ORDER BY c1;
23
SELECT HEX(c1) FROM t5 WHERE c1 <= '1' ORDER BY c1;
27
SELECT HEX(c1) FROM t5 WHERE c1 < '1' ORDER BY c1;
30
SELECT HEX(c1) FROM t5 WHERE c1 > '0' ORDER BY c1;
35
CREATE TABLE t5(c1 FLOAT(5,2) PRIMARY KEY) ENGINE = <default_engine>;
36
INSERT INTO t5 VALUES (95.95), (-10.10), (1), (0);
37
SELECT c1 FROM t5 ORDER BY c1;
43
SELECT c1 FROM t5 WHERE c1 >= '95' ORDER BY c1;
46
SELECT c1 FROM t5 WHERE c1 <= '10.10' ORDER BY c1;
51
SELECT c1 FROM t5 WHERE c1 != '1' ORDER BY c1;
56
SELECT c1 FROM t5 WHERE c1 < '1' ORDER BY c1;
60
SELECT c1 FROM t5 WHERE c1 > '0' ORDER BY c1;
65
CREATE TABLE t5(c1 TINYINT PRIMARY KEY) ENGINE = <default_engine>;
66
INSERT INTO t5 VALUES (95), (10),(11),(-8);
67
SELECT c1 FROM t5 ORDER BY c1;
73
SELECT c1 FROM t5 WHERE c1 = '10' ORDER BY c1;
76
SELECT c1 FROM t5 WHERE c1 <=> '10' ORDER BY c1;
79
SELECT c1 FROM t5 WHERE c1 >= '95' ORDER BY c1;
82
SELECT c1 FROM t5 WHERE c1 <= '11' ORDER BY c1;
87
SELECT c1 FROM t5 WHERE c1 != '-8' ORDER BY c1;
92
SELECT c1 FROM t5 WHERE c1 < '11' ORDER BY c1;
96
SELECT c1 FROM t5 WHERE c1 > '10' ORDER BY c1;
101
CREATE TABLE t5(c1 SMALLINT PRIMARY KEY) ENGINE = <default_engine>;
102
INSERT INTO t5 VALUES (395), (-200), (100), (111);
103
SELECT c1 FROM t5 ORDER BY c1;
109
SELECT c1 FROM t5 WHERE c1 = '100' ORDER BY c1;
112
SELECT c1 FROM t5 WHERE c1 <=> '100' ORDER BY c1;
115
SELECT c1 FROM t5 WHERE c1 >= '395' ORDER BY c1;
118
SELECT c1 FROM t5 WHERE c1 <= '-200' ORDER BY c1;
121
SELECT c1 FROM t5 WHERE c1 != '100' ORDER BY c1;
126
SELECT c1 FROM t5 WHERE c1 < '111' ORDER BY c1;
130
SELECT c1 FROM t5 WHERE c1 > '111' ORDER BY c1;
134
CREATE TABLE t5(c1 MEDIUMINT PRIMARY KEY) ENGINE = <default_engine>;
135
INSERT INTO t5 VALUES (-8388607), (311),(215),(88608);
136
SELECT c1 FROM t5 ORDER BY c1;
142
SELECT c1 FROM t5 WHERE c1 = '311' ORDER BY c1;
145
SELECT c1 FROM t5 WHERE c1 <=> '311' ORDER BY c1;
148
SELECT c1 FROM t5 WHERE c1 >= '215' ORDER BY c1;
153
SELECT c1 FROM t5 WHERE c1 <= '88608' ORDER BY c1;
159
SELECT c1 FROM t5 WHERE c1 != '-8388607' ORDER BY c1;
164
SELECT c1 FROM t5 WHERE c1 < '215' ORDER BY c1;
167
SELECT c1 FROM t5 WHERE c1 > '215' ORDER BY c1;
172
CREATE TABLE t5(c1 INT PRIMARY KEY) ENGINE = <default_engine>;
173
INSERT INTO t5 VALUES (-2147483647), (1011),(15),(9388607);
174
SELECT c1 FROM t5 ORDER BY c1;
180
SELECT c1 FROM t5 WHERE c1 = '9388607' ORDER BY c1;
183
SELECT c1 FROM t5 WHERE c1 <=> '9388607' ORDER BY c1;
186
SELECT c1 FROM t5 WHERE c1 >= '15' ORDER BY c1;
191
SELECT c1 FROM t5 WHERE c1 <= '1011' ORDER BY c1;
196
SELECT c1 FROM t5 WHERE c1 != '-2147483647' ORDER BY c1;
201
SELECT c1 FROM t5 WHERE c1 < '15' ORDER BY c1;
204
SELECT c1 FROM t5 WHERE c1 > '15' ORDER BY c1;
209
CREATE TABLE t5(c1 BIGINT PRIMARY KEY) ENGINE = <default_engine>;
210
INSERT INTO t5 VALUES (-9223372036854775807), (12011),(500),(3372036854775808);
211
SELECT c1 FROM t5 ORDER BY c1;
217
SELECT c1 FROM t5 WHERE c1 = '-9223372036854775807' ORDER BY c1;
220
SELECT c1 FROM t5 WHERE c1 <=> '-9223372036854775807' ORDER BY c1;
223
SELECT c1 FROM t5 WHERE c1 >= '12011' ORDER BY c1;
227
SELECT c1 FROM t5 WHERE c1 <= '500' ORDER BY c1;
231
SELECT c1 FROM t5 WHERE c1 != '3372036854775808' ORDER BY c1;
236
SELECT c1 FROM t5 WHERE c1 < '12011' ORDER BY c1;
240
SELECT c1 FROM t5 WHERE c1 > '12011' ORDER BY c1;
244
CREATE TABLE t5(c1 DOUBLE(5,2) PRIMARY KEY) ENGINE = <default_engine>;
245
INSERT INTO t5 VALUES (95.95), (11.11),(5),(-908.92);
246
SELECT c1 FROM t5 ORDER BY c1;
252
SELECT c1 FROM t5 WHERE c1 = '11.11' ORDER BY c1;
255
SELECT c1 FROM t5 WHERE c1 <=> '11.11' ORDER BY c1;
258
SELECT c1 FROM t5 WHERE c1 >= '5' ORDER BY c1;
263
SELECT c1 FROM t5 WHERE c1 <= '95.95' ORDER BY c1;
269
SELECT c1 FROM t5 WHERE c1 != '-908.92' ORDER BY c1;
274
SELECT c1 FROM t5 WHERE c1 < '95.95' ORDER BY c1;
279
SELECT c1 FROM t5 WHERE c1 > '-908.92' ORDER BY c1;
285
CREATE TABLE t5(c1 NUMERIC(5,2) PRIMARY KEY) ENGINE = <default_engine>;
286
INSERT INTO t5 VALUES (95.95), (11.11),(5),(-908.92);
287
SELECT c1 FROM t5 ORDER BY c1;
293
SELECT c1 FROM t5 WHERE c1 = '11.11' ORDER BY c1;
296
SELECT c1 FROM t5 WHERE c1 <=> '11.11' ORDER BY c1;
299
SELECT c1 FROM t5 WHERE c1 >= '5' ORDER BY c1;
304
SELECT c1 FROM t5 WHERE c1 <= '95.95' ORDER BY c1;
310
SELECT c1 FROM t5 WHERE c1 != '-908.92' ORDER BY c1;
315
SELECT c1 FROM t5 WHERE c1 < '95.95' ORDER BY c1;
320
SELECT c1 FROM t5 WHERE c1 > '-908.92' ORDER BY c1;
326
CREATE TABLE t5(c1 DECIMAL(5,2) PRIMARY KEY) ENGINE = <default_engine>;
327
INSERT INTO t5 VALUES (95.95), (11.11),(5),(-908.92);
328
SELECT c1 FROM t5 ORDER BY c1;
334
SELECT c1 FROM t5 WHERE c1 = '11.11' ORDER BY c1;
337
SELECT c1 FROM t5 WHERE c1 <=> '11.11' ORDER BY c1;
340
SELECT c1 FROM t5 WHERE c1 >= '5' ORDER BY c1;
345
SELECT c1 FROM t5 WHERE c1 <= '95.95' ORDER BY c1;
351
SELECT c1 FROM t5 WHERE c1 != '-908.92' ORDER BY c1;
356
SELECT c1 FROM t5 WHERE c1 < '95.95' ORDER BY c1;
361
SELECT c1 FROM t5 WHERE c1 > '-908.92' ORDER BY c1;