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

mysqldump --system=all self deletion protection current user wrong

    XMLWordPrintable

Details

    Description

      DELIMITER |
      		 
      /*M!100101 IF current_user()="'root'@'localhost'" THEN
      		 
        SIGNAL SQLSTATE '45000' SET MYSQL_ERRNO=30001, MESSAGE_TEXT="Don't remove current user 'root'@'localhost''";
      		 
      END IF */|

      This isn't quite right, the quoting in the string literal quoting is too much. current_user is just 'root@localhost' rather than the quoted form.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-42117 mariadb-dump current-user guard compares incompatible account representations and cannot fire

          • Major - Major loss of function.
          • Closed

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              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.