1DROP TABLE IF EXISTS t5; 2CREATE TABLE t5(c1 BIT(2) PRIMARY KEY) ENGINE = <default_engine>; 3INSERT INTO t5 VALUES (0), (1), (2); 4SELECT HEX(c1) FROM t5 ORDER BY c1; 5HEX(c1) 60 71 82 9SELECT HEX(c1) FROM t5 WHERE c1 = b'1' ORDER BY c1; 10HEX(c1) 111 12SELECT HEX(c1) FROM t5 WHERE c1 <=> b'1' ORDER BY c1; 13HEX(c1) 141 15SELECT HEX(c1) FROM t5 WHERE c1 != b'1' ORDER BY c1; 16HEX(c1) 170 182 19SELECT HEX(c1) FROM t5 WHERE c1 >= '1' ORDER BY c1; 20HEX(c1) 211 222 23SELECT HEX(c1) FROM t5 WHERE c1 <= '1' ORDER BY c1; 24HEX(c1) 250 261 27SELECT HEX(c1) FROM t5 WHERE c1 < '1' ORDER BY c1; 28HEX(c1) 290 30SELECT HEX(c1) FROM t5 WHERE c1 > '0' ORDER BY c1; 31HEX(c1) 321 332 34DROP TABLE t5; 35CREATE TABLE t5(c1 FLOAT(5,2) PRIMARY KEY) ENGINE = <default_engine>; 36INSERT INTO t5 VALUES (95.95), (-10.10), (1), (0); 37SELECT c1 FROM t5 ORDER BY c1; 38c1 39-10.10 400.00 411.00 4295.95 43SELECT c1 FROM t5 WHERE c1 >= '95' ORDER BY c1; 44c1 4595.95 46SELECT c1 FROM t5 WHERE c1 <= '10.10' ORDER BY c1; 47c1 48-10.10 490.00 501.00 51SELECT c1 FROM t5 WHERE c1 != '1' ORDER BY c1; 52c1 53-10.10 540.00 5595.95 56SELECT c1 FROM t5 WHERE c1 < '1' ORDER BY c1; 57c1 58-10.10 590.00 60SELECT c1 FROM t5 WHERE c1 > '0' ORDER BY c1; 61c1 621.00 6395.95 64DROP TABLE t5; 65CREATE TABLE t5(c1 TINYINT PRIMARY KEY) ENGINE = <default_engine>; 66INSERT INTO t5 VALUES (95), (10),(11),(-8); 67SELECT c1 FROM t5 ORDER BY c1; 68c1 69-8 7010 7111 7295 73SELECT c1 FROM t5 WHERE c1 = '10' ORDER BY c1; 74c1 7510 76SELECT c1 FROM t5 WHERE c1 <=> '10' ORDER BY c1; 77c1 7810 79SELECT c1 FROM t5 WHERE c1 >= '95' ORDER BY c1; 80c1 8195 82SELECT c1 FROM t5 WHERE c1 <= '11' ORDER BY c1; 83c1 84-8 8510 8611 87SELECT c1 FROM t5 WHERE c1 != '-8' ORDER BY c1; 88c1 8910 9011 9195 92SELECT c1 FROM t5 WHERE c1 < '11' ORDER BY c1; 93c1 94-8 9510 96SELECT c1 FROM t5 WHERE c1 > '10' ORDER BY c1; 97c1 9811 9995 100DROP TABLE t5; 101CREATE TABLE t5(c1 SMALLINT PRIMARY KEY) ENGINE = <default_engine>; 102INSERT INTO t5 VALUES (395), (-200), (100), (111); 103SELECT c1 FROM t5 ORDER BY c1; 104c1 105-200 106100 107111 108395 109SELECT c1 FROM t5 WHERE c1 = '100' ORDER BY c1; 110c1 111100 112SELECT c1 FROM t5 WHERE c1 <=> '100' ORDER BY c1; 113c1 114100 115SELECT c1 FROM t5 WHERE c1 >= '395' ORDER BY c1; 116c1 117395 118SELECT c1 FROM t5 WHERE c1 <= '-200' ORDER BY c1; 119c1 120-200 121SELECT c1 FROM t5 WHERE c1 != '100' ORDER BY c1; 122c1 123-200 124111 125395 126SELECT c1 FROM t5 WHERE c1 < '111' ORDER BY c1; 127c1 128-200 129100 130SELECT c1 FROM t5 WHERE c1 > '111' ORDER BY c1; 131c1 132395 133DROP TABLE t5; 134CREATE TABLE t5(c1 MEDIUMINT PRIMARY KEY) ENGINE = <default_engine>; 135INSERT INTO t5 VALUES (-8388607), (311),(215),(88608); 136SELECT c1 FROM t5 ORDER BY c1; 137c1 138-8388607 139215 140311 14188608 142SELECT c1 FROM t5 WHERE c1 = '311' ORDER BY c1; 143c1 144311 145SELECT c1 FROM t5 WHERE c1 <=> '311' ORDER BY c1; 146c1 147311 148SELECT c1 FROM t5 WHERE c1 >= '215' ORDER BY c1; 149c1 150215 151311 15288608 153SELECT c1 FROM t5 WHERE c1 <= '88608' ORDER BY c1; 154c1 155-8388607 156215 157311 15888608 159SELECT c1 FROM t5 WHERE c1 != '-8388607' ORDER BY c1; 160c1 161215 162311 16388608 164SELECT c1 FROM t5 WHERE c1 < '215' ORDER BY c1; 165c1 166-8388607 167SELECT c1 FROM t5 WHERE c1 > '215' ORDER BY c1; 168c1 169311 17088608 171DROP TABLE t5; 172CREATE TABLE t5(c1 INT PRIMARY KEY) ENGINE = <default_engine>; 173INSERT INTO t5 VALUES (-2147483647), (1011),(15),(9388607); 174SELECT c1 FROM t5 ORDER BY c1; 175c1 176-2147483647 17715 1781011 1799388607 180SELECT c1 FROM t5 WHERE c1 = '9388607' ORDER BY c1; 181c1 1829388607 183SELECT c1 FROM t5 WHERE c1 <=> '9388607' ORDER BY c1; 184c1 1859388607 186SELECT c1 FROM t5 WHERE c1 >= '15' ORDER BY c1; 187c1 18815 1891011 1909388607 191SELECT c1 FROM t5 WHERE c1 <= '1011' ORDER BY c1; 192c1 193-2147483647 19415 1951011 196SELECT c1 FROM t5 WHERE c1 != '-2147483647' ORDER BY c1; 197c1 19815 1991011 2009388607 201SELECT c1 FROM t5 WHERE c1 < '15' ORDER BY c1; 202c1 203-2147483647 204SELECT c1 FROM t5 WHERE c1 > '15' ORDER BY c1; 205c1 2061011 2079388607 208DROP TABLE t5; 209CREATE TABLE t5(c1 BIGINT PRIMARY KEY) ENGINE = <default_engine>; 210INSERT INTO t5 VALUES (-9223372036854775807), (12011),(500),(3372036854775808); 211SELECT c1 FROM t5 ORDER BY c1; 212c1 213-9223372036854775807 214500 21512011 2163372036854775808 217SELECT c1 FROM t5 WHERE c1 = '-9223372036854775807' ORDER BY c1; 218c1 219-9223372036854775807 220SELECT c1 FROM t5 WHERE c1 <=> '-9223372036854775807' ORDER BY c1; 221c1 222-9223372036854775807 223SELECT c1 FROM t5 WHERE c1 >= '12011' ORDER BY c1; 224c1 22512011 2263372036854775808 227SELECT c1 FROM t5 WHERE c1 <= '500' ORDER BY c1; 228c1 229-9223372036854775807 230500 231SELECT c1 FROM t5 WHERE c1 != '3372036854775808' ORDER BY c1; 232c1 233-9223372036854775807 234500 23512011 236SELECT c1 FROM t5 WHERE c1 < '12011' ORDER BY c1; 237c1 238-9223372036854775807 239500 240SELECT c1 FROM t5 WHERE c1 > '12011' ORDER BY c1; 241c1 2423372036854775808 243DROP TABLE t5; 244CREATE TABLE t5(c1 DOUBLE(5,2) PRIMARY KEY) ENGINE = <default_engine>; 245INSERT INTO t5 VALUES (95.95), (11.11),(5),(-908.92); 246SELECT c1 FROM t5 ORDER BY c1; 247c1 248-908.92 2495.00 25011.11 25195.95 252SELECT c1 FROM t5 WHERE c1 = '11.11' ORDER BY c1; 253c1 25411.11 255SELECT c1 FROM t5 WHERE c1 <=> '11.11' ORDER BY c1; 256c1 25711.11 258SELECT c1 FROM t5 WHERE c1 >= '5' ORDER BY c1; 259c1 2605.00 26111.11 26295.95 263SELECT c1 FROM t5 WHERE c1 <= '95.95' ORDER BY c1; 264c1 265-908.92 2665.00 26711.11 26895.95 269SELECT c1 FROM t5 WHERE c1 != '-908.92' ORDER BY c1; 270c1 2715.00 27211.11 27395.95 274SELECT c1 FROM t5 WHERE c1 < '95.95' ORDER BY c1; 275c1 276-908.92 2775.00 27811.11 279SELECT c1 FROM t5 WHERE c1 > '-908.92' ORDER BY c1; 280c1 2815.00 28211.11 28395.95 284DROP TABLE t5; 285CREATE TABLE t5(c1 NUMERIC(5,2) PRIMARY KEY) ENGINE = <default_engine>; 286INSERT INTO t5 VALUES (95.95), (11.11),(5),(-908.92); 287SELECT c1 FROM t5 ORDER BY c1; 288c1 289-908.92 2905.00 29111.11 29295.95 293SELECT c1 FROM t5 WHERE c1 = '11.11' ORDER BY c1; 294c1 29511.11 296SELECT c1 FROM t5 WHERE c1 <=> '11.11' ORDER BY c1; 297c1 29811.11 299SELECT c1 FROM t5 WHERE c1 >= '5' ORDER BY c1; 300c1 3015.00 30211.11 30395.95 304SELECT c1 FROM t5 WHERE c1 <= '95.95' ORDER BY c1; 305c1 306-908.92 3075.00 30811.11 30995.95 310SELECT c1 FROM t5 WHERE c1 != '-908.92' ORDER BY c1; 311c1 3125.00 31311.11 31495.95 315SELECT c1 FROM t5 WHERE c1 < '95.95' ORDER BY c1; 316c1 317-908.92 3185.00 31911.11 320SELECT c1 FROM t5 WHERE c1 > '-908.92' ORDER BY c1; 321c1 3225.00 32311.11 32495.95 325DROP TABLE t5; 326CREATE TABLE t5(c1 DECIMAL(5,2) PRIMARY KEY) ENGINE = <default_engine>; 327INSERT INTO t5 VALUES (95.95), (11.11),(5),(-908.92); 328SELECT c1 FROM t5 ORDER BY c1; 329c1 330-908.92 3315.00 33211.11 33395.95 334SELECT c1 FROM t5 WHERE c1 = '11.11' ORDER BY c1; 335c1 33611.11 337SELECT c1 FROM t5 WHERE c1 <=> '11.11' ORDER BY c1; 338c1 33911.11 340SELECT c1 FROM t5 WHERE c1 >= '5' ORDER BY c1; 341c1 3425.00 34311.11 34495.95 345SELECT c1 FROM t5 WHERE c1 <= '95.95' ORDER BY c1; 346c1 347-908.92 3485.00 34911.11 35095.95 351SELECT c1 FROM t5 WHERE c1 != '-908.92' ORDER BY c1; 352c1 3535.00 35411.11 35595.95 356SELECT c1 FROM t5 WHERE c1 < '95.95' ORDER BY c1; 357c1 358-908.92 3595.00 36011.11 361SELECT c1 FROM t5 WHERE c1 > '-908.92' ORDER BY c1; 362c1 3635.00 36411.11 36595.95 366DROP TABLE t5; 367