sql_mode='STRICT_TRANS_TABLES' & SET @@var=<out-of-range>

STRICT_TRANS_TABLES_and_SET

MariaDB [test]> select @@version;
+----------------------+
| @@version            |
+----------------------+
| 10.2.3-MariaDB-debug |
+----------------------+
1 row in set (0.00 sec)

MariaDB [test]> select @@sql_mode;
+---------------------+
| @@sql_mode          |
+---------------------+
| STRICT_TRANS_TABLES |
+---------------------+
1 row in set (0.00 sec)

MariaDB [test]> SET @@global.table_definition_cache = 100;
ERROR 1231 (42000): Variable 'table_definition_cache' can't be set to the value of '100'


mysql> select @@version;
+--------------+
| @@version    |
+--------------+
| 5.7.16-debug |
+--------------+
1 row in set (0.00 sec)

mysql> select @@sql_mode;
+---------------------+
| @@sql_mode          |
+---------------------+
| STRICT_TRANS_TABLES |
+---------------------+
1 row in set (0.00 sec)

mysql> SET @@global.table_definition_cache = 100;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+---------------------------------------------------------+
| Level   | Code | Message                                                 |
+---------+------+---------------------------------------------------------+
| Warning | 1292 | Truncated incorrect table_definition_cache value: '100' |
+---------+------+---------------------------------------------------------+
1 row in set (0.00 sec)