[MDEV-8578] Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION Created: 2015-08-07  Updated: 2023-04-27

Status: Confirmed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Rucha Deodhar
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-6858 enforce_storage_engine option Closed

 Description    

MariaDB [test]> select @@enforce_storage_engine;
 
+--------------------------+
 
| @@enforce_storage_engine |
 
+--------------------------+
 
| InnoDB                   |
 
+--------------------------+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> set sql_mode=NO_ENGINE_SUBSTITUTION;
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> create table t (i int) engine=MyISAM;
 
ERROR 1286 (42000): Unknown storage engine 'MyISAM'

It is of course expected that CREATE would produce an error, just not the error. If there is no suitable one, maybe it should be created.



 Comments   
Comment by Sergei Golubchik [ 2021-10-10 ]

let's use ER_OPTION_PREVENTS_STATEMENT

Generated at Thu Feb 08 07:28:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.