CREATE TABLE t1 (f1 double, f2 BIGINT);

INSERT INTO t1 SET f1 = -1.0e+30 ;
INSERT INTO t1 SET f1 = +1.0e+30 ;

# explicit CAST of double column content
SELECT f1 AS double_val, CAST(f1 AS   SIGNED INT) AS cast_val FROM t1;

##### statements for comparison
# explicit CAST of double constants
SELECT -1.0e+30 AS double_val, CAST(-1.0E+30 AS   SIGNED INT) as cast_val;
SELECT +1.0e+30 AS double_val, CAST(+1.0E+30 AS   SIGNED INT) as cast_val;
# implicit CAST of double column content
UPDATE t1 SET f2 = f1;
SELECT f1 AS double_val, f2 AS impl_cast_val FROM t1;