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

ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist inconsistency/regression (on optimized builds)

    XMLWordPrintable

Details

    Description

      SELECT user,host FROM mysql.user;
      SELECT USER(),CURRENT_USER();
      DELETE FROM mysql.user WHERE user like '%';
      SELECT user,host FROM mysql.user;
      FLUSH PRIVILEGES;  
      SELECT USER(),CURRENT_USER();
      # Following query will produce ERROR 1449 on 10.4.14 and 10.5.4 (opt+dbg on both), 
      # And "OK" on 10.1.46, 10.2.33, and 10.3.24 (dbg+opt both tested on all) and MySQL 5.5.62, 5.6.47, 5.7.29, and 8.0.19 (opt tested on all)
      SELECT * FROM mysql.user;  
      

      10.5.4 4080e3acefd7e58d88c2f3539fb6a0fb359cf057

      10.5.4>SELECT * FROM mysql.user;  
      ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            Roel Roel Van de Paar
            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.