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

Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.1, 10.2, 10.3, 10.4
    • Fix Version/s: 10.1, 10.2, 10.3, 10.4
    • Component/s: Server
    • 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.

        Attachments

          Issue Links

            Activity

              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: