CREATE TABLE test.test01 (
  val int(5) DEFAULT NULL,
  val_int decimal(5, 0) DEFAULT NULL
)
ENGINE = INNODB
CHARACTER SET utf8
COLLATE utf8_general_ci;

INSERT INTO test01 (val_int) 
SELECT CAST('1111111' AS DECIMAL(5,0));

INSERT INTO test01 (val) 
SELECT CAST('1111111' AS DECIMAL(5,0));

D:\DB\mariadb\bin>mysql -uroot -p
Enter password: *****
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.1.8-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test;
Database changed
MariaDB [test]> select version();
+----------------+
| version()      |
+----------------+
| 10.1.8-MariaDB |
+----------------+
1 row in set (0.00 sec)

MariaDB [test]> select * from test01;
+-------+---------+
| val   | val_int |
+-------+---------+
| 99999 |    NULL |
|  NULL |   99999 |
+-------+---------+
2 rows in set (0.00 sec);
MariaDB [test]> select @@sql_mode;
+--------------------------------------------+
| @@sql_mode                                 |
+--------------------------------------------+
| NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]>