[MDEV-8578] Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION - Jira

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.11, 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL), 11.6(EOL)
Fix Version/s: 10.5.27, 10.6.20, 10.11.10, 11.2.6, 11.4.4
Component/s: Server
Labels:
- enforce_storage_engine

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.

relates to

MDEV-6858 enforce_storage_engine option

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server