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

sys.ps_setup_save and dependent procedures fail with ER_ILLEGAL_HA_CREATE_OPTION

    XMLWordPrintable

    Details

      Description

      call sys.ps_setup_save(0);
      

      10.7 1866fb05

      mysqltest: At line 1: query 'call sys.ps_setup_save(0)' failed: ER_ILLEGAL_HA_CREATE_OPTION (1478): Table storage engine 'PERFORMANCE_SCHEMA' does not support the create option 'TEMPORARY'
      

      Correspondingly, procedures which call it also fail (at least sys.diagnostics).

      The problem was introduced by this commit in 10.7.1:

      commit f7216fa63d69448c3de1532a1dd197d0f28faefd (HEAD)
      Author: Anel Husakovic
      Date:   Wed Jun 10 09:07:15 2020 +0200
       
          MDEV-12914: Engine for temporary tables which are implicitly created as RocksDB is substituted silently
      

        Attachments

          Activity

            People

            Assignee:
            anel Anel Husakovic
            Reporter:
            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.