Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8578

Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION

        Details

        • Type: Bug
        • Status: Confirmed
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1
        • Fix Version/s: 10.1
        • Component/s: OTHER
        • Labels:
          None

          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-6858 enforce_storage_engine option

                • Major - Major loss of function.
                • Closed

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      jplindst Jan Lindström
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: