MariaDB [test]> create table i1 (a decimal(38,10));

Query OK, 0 rows affected (0.057 sec)

MariaDB [test]> create table i2 as select floor(a), ceil(a) from i1;

Query OK, 0 rows affected (0.019 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [test]> show create table i2;

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

| Table | Create Table                                                                                                                               |

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

| i2    | CREATE TABLE `i2` (

  `floor(a)` decimal(28,0) DEFAULT NULL,

  `ceil(a)` decimal(28,0) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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

1 row in set (0.001 sec)

MariaDB [test]> insert into i1 values (9999999999999999999999999999.9999999999), (-9999999999999999999999999999.9999999999);

Query OK, 2 rows affected (0.002 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> create table i3 as select floor(a), ceil(a) from i1;

ERROR 1264 (22003): Out of range value for column 'ceil(a)' at row 1

MariaDB [test]> create table i3 as select floor(a) from i1;

ERROR 1264 (22003): Out of range value for column 'floor(a)' at row 2