[MDEV-4107] SET default_storage_engine = IF(..) produces ER_TRUNCATED_WRONG_VALUE Created: 2013-01-29  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.1, 5.5.29
Fix Version/s: 5.5

Type: Bug Priority: Trivial
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: upstream

Issue Links:
Relates

 Description   

The problem is reproducible on MySQL 5.5-5.6 and filed as http://bugs.mysql.com/bug.php?id=68211

set @@default_storage_engine = IF(2=1,'MyISAM','InnoDB');
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
show warnings;
+---------+------+---------------------------------------------+
| Level   | Code | Message                                     |
+---------+------+---------------------------------------------+
| Warning | 1292 | Truncated incorrect INTEGER value: 'InnoDB' |
+---------+------+---------------------------------------------+
1 row in set (0.00 sec)
 
select @@default_storage_engine;
+--------------------------+
| @@default_storage_engine |
+--------------------------+
| InnoDB                   |
+--------------------------+
1 row in set (0.00 sec)
 
set @@default_storage_engine = IF(2=2,'MyISAM','InnoDB');
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
show warnings;
+---------+------+---------------------------------------------+
| Level   | Code | Message                                     |
+---------+------+---------------------------------------------+
| Warning | 1292 | Truncated incorrect INTEGER value: 'MyISAM' |
+---------+------+---------------------------------------------+
1 row in set (0.00 sec)
 
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.

Test case:

set @@default_storage_engine = IF(2=1,'MyISAM','InnoDB');


Generated at Thu Feb 08 06:53:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.