Description:
MySQL [(none)]> set @@default_storage_engine = IF(2=1,'MyISAM','InnoDB');
Query OK, 0 rows affected, 1 warning (0.00 sec)
MySQL [(none)]> show warnings;
+---------+------+---------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------+
| Warning | 1292 | Truncated incorrect INTEGER value: 'InnoDB' |
+---------+------+---------------------------------------------+
1 row in set (0.00 sec)
MySQL [(none)]> select @@default_storage_engine;
+--------------------------+
| @@default_storage_engine |
+--------------------------+
| InnoDB |
+--------------------------+
1 row in set (0.00 sec)
MySQL [(none)]> set @@default_storage_engine = IF(2=2,'MyISAM','InnoDB');
Query OK, 0 rows affected, 1 warning (0.00 sec)
MySQL [(none)]> show warnings;
+---------+------+---------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------+
| Warning | 1292 | Truncated incorrect INTEGER value: 'MyISAM' |
+---------+------+---------------------------------------------+
1 row in set (0.00 sec)
MySQL [(none)]> select @@default_storage_engine;
+--------------------------+
| @@default_storage_engine |
+--------------------------+
| MyISAM |
+--------------------------+
1 row in set (0.00 sec)
It's harmless as it seems, just weird how it comes up with INTEGER.
How to repeat:
set @@default_storage_engine = IF(2=1,'MyISAM','InnoDB');