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

cannot set session gtid_domain_id in stored procedure (SECURITY DEFINER)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.14
    • N/A
    • OTHER
    • None
    • wheezy x86_64

    Description

      CREATE PROCEDURE setdomain() DETERMINISTIC SQL SECURITY DEFINER
      BEGIN
      set @gtid_domain_id=59;
      END
       
      set global init_connect='call  mysql.setdomain();';

      non-priv user:

      mysql>  select @gtid_domain_id;
      +-----------------+
      | @gtid_domain_id |
      +-----------------+
      |              59 |
      +-----------------+
      1 row in set (0.00 sec)
       
      mysql> show session variables like 'gtid_domain_id';
      +----------------+-------+
      | Variable_name  | Value |
      +----------------+-------+
      | gtid_domain_id | 0     |
      +----------------+-------+
      1 row in set (0.00 sec)

      Binary events logged as this user use gtid_domain_id =0 instead of 59.

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.