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

enforce_storage_engine cannot be set globally

Details

    • 10.1.6-1

    Description

      MariaDB [test]> set global enforce_storage_engine=MyISAM;
      		 
      ERROR 1228 (HY000): Variable 'enforce_storage_engine' is a SESSION variable and can't be used with SET GLOBAL

      I truly hope it's an oversight, although from the last comment to MDEV-6858, it seems it might have been done on purpose. It's understandable why a super-user should be able to overrule it sometimes on the session level, but the main goal of it is still being a server-wide rule.

      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

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Description {noformat}
            MariaDB [test]> set global enforce_storage_engine=MyISAM;
            ERROR 1228 (HY000): Variable 'enforce_storage_engine' is a SESSION variable and can't be used with SET GLOBAL
            {noformat}

            I truly hope it's an oversight, although from the last comment to MDEV-6858, it seems it might have been done on purpose. If so, I beg you to re-consider. It's understandable why a super-user should be able to overrule it sometimes on the session level, but the main goal of it is being a server-wide rule; making it session-only is utterly pointless.
            		{noformat}
            MariaDB [test]> set global enforce_storage_engine=MyISAM;
            ERROR 1228 (HY000): Variable 'enforce_storage_engine' is a SESSION variable and can't be used with SET GLOBAL
            {noformat}

            I truly hope it's an oversight, although from the last comment to MDEV-6858, it seems it might have been done on purpose. It's understandable why a super-user should be able to overrule it sometimes on the session level, but the main goal of it is still being a server-wide rule.
            elenst Elena Stepanova made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Sprint 10.1.6-1 [ 6 ]
            jplindst Jan Lindström (Inactive) made changes -
            Rank Ranked lower
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Jan Lindström [ jplindst ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.1.6 [ 19401 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 67703 ] MariaDB v4 [ 149207 ]
            Roel Roel Van de Paar made changes -
            Labels enforce_storage_engine

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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