CAST(hugeNegativeWideDecimal AS SIGNED) returns 0 or NULL

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (d1 DECIMAL(30,0), d2 DECIMAL(30,0) NOT NULL) ENGINE=ColumnStore;

INSERT INTO t1 VALUES (-1e20,-1e20),(1e20,1e20);

SELECT d1, CAST(d1 AS SIGNED), CAST(d2 AS SIGNED) FROM t1;

+------------------------+---------------------+---------------------+

| d1                     | CAST(d1 AS SIGNED)  | CAST(d2 AS SIGNED)  |

+------------------------+---------------------+---------------------+

| -100000000000000000000 |                NULL |                   0 |

|  100000000000000000000 | 9223372036854775807 | 9223372036854775807 |

+------------------------+---------------------+---------------------+

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (d1 DECIMAL(30,0), d2 DECIMAL(30,0) NOT NULL) ENGINE=InnoDB;

INSERT INTO t1 VALUES (-1e20,-1e20),(1e20,1e20);

SELECT d1, CAST(d1 AS SIGNED), CAST(d2 AS SIGNED) FROM t1;

+------------------------+----------------------+----------------------+

| d1                     | CAST(d1 AS SIGNED)   | CAST(d2 AS SIGNED)   |

+------------------------+----------------------+----------------------+

| -100000000000000000000 | -9223372036854775808 | -9223372036854775808 |

|  100000000000000000000 |  9223372036854775807 |  9223372036854775807 |

+------------------------+----------------------+----------------------+