410
CREATE TABLE t1 (a DOUBLE);
411
INSERT INTO t1 VALUES (-1.1), (1.1),
417
# Check numbers with absolute values > 2^53 - 1
418
# (see comments for MAX_EXACT_INTEGER)
419
(-1e16 - 0.5), (1e16 + 0.5),
420
(-1e16 - 1.5), (1e16 + 1.5);
421
SELECT a, ROUND(a) FROM t1;
435
-1e16 -10000000000000000
436
1e16 10000000000000000
437
-1.0000000000000002e16 -10000000000000002
438
1.0000000000000002e16 10000000000000002
411
441
SELECT 1e308 + 1e308;