Details
Major
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Hi Daniel,
I'm not sure I quite understand your point, could you please clarify?
You set @var (a user-defined variable), but you expect @@var to be updated (a session environment variable). I don't think it works for any variable, gtid or not, do you have a reason to expect that it would?
quite right. I've mixed up those concepts. session variable Gtid_domain_id is able to be set in a procedure.
bug invalid
non-priv user
mysql> select @last_gtid -> ; +------------+ | @last_gtid | +------------+ | NULL | +------------+ 1 row in set (0.00 sec) mysql> use db; Database changed mysql> update users set login='user_disabled' where id=14; Query OK, 0 rows affected (0.11 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql> select @@last_gtid -> ; +-----------------+ | @@last_gtid | +-----------------+ | 0-12301-1050230 | +-----------------+ mysql> show session variables like 'gtid_domain_id'; +----------------+-------+ | Variable_name | Value | +----------------+-------+ | gtid_domain_id | 0 | +----------------+-------+ 1 row in set (0.00 sec) mysql> select @gtid_domain_id; +-----------------+ | @gtid_domain_id | +-----------------+ | 59 | +-----------------+ 1 row in set (0.00 sec)