Limitation on DOUBLE or REAL length is ignored with INSERT .. SELECT

CREATE TABLE t1 (d1 DOUBLE(5,2), d2 DOUBLE(10,2)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (10000000.55, 10000000.55);

Warnings:

Warning	1264	Out of range value for column 'd1' at row 1

# As expected, d1 is truncated:

SELECT * FROM t1;

d1	d2

999.99	10000000.55

INSERT INTO t1 SELECT d2, d2 FROM t1;

# Now d1 is not truncated, and no warnings:

SELECT * FROM t1;

d1	d2

999.99	10000000.55

10000000.55	10000000.55

CREATE TABLE t1 (d1 DOUBLE(5,2), d2 DOUBLE(10,2)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (10000000.55, 10000000.55);

INSERT INTO t1 SELECT d2, d2 FROM t1;

SELECT * FROM t1;