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

Bad error ER_VIEW_INVALID returned upon attempt to insert into mysql.user

    XMLWordPrintable

Details

    Description

      MDEV-19650 introduced a new definer for mysql.user view, with just enough permissions to perform valid operations on the view.

      A side effect of it is that an attempt to insert into the view (which is an invalid operation) started producing a bad error code. Instead of the former accurate ER_NON_INSERTABLE_TABLE ("The target table user of the INSERT is not insertable-into") it now returns the less user-friendly ER_VIEW_INVALID ("View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them").

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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