[MDEV-7996] CURRENT_USER definer does not replicate for triggers Created: 2015-04-15  Updated: 2015-04-23  Resolved: 2015-04-23

Status: Closed
Project: MariaDB Server
Component/s: wsrep
Affects Version/s: 10.0.17-galera
Fix Version/s: 10.0.19-galera

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Node 1:

MariaDB [test]> CREATE TABLE definer_current_user (f1 INTEGER, trigger_user VARCHAR(100)) ENGINE=InnoDB;
Query OK, 0 rows affected (0.10 sec)
 
MariaDB [test]> CREATE DEFINER=current_user TRIGGER definer_current_user BEFORE INSERT ON definer_current_user FOR EACH ROW SET NEW.trigger_user = CURRENT_USER();
Query OK, 0 rows affected (0.06 sec)
 

Node 2:

MariaDB [test]> show tables;
+----------------------+
| Tables_in_test       |
+----------------------+
| definer_current_user |
+----------------------+
1 row in set (0.00 sec)
 
MariaDB [test]> INSERT INTO definer_current_user (f1) VALUES (1);
ERROR 1449 (HY000): The user specified as a definer ('*current_user'@'%') does not exist
 



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2015-04-15 ]

5.5.42-galera is not affected.

Comment by Nirbhay Choubey (Inactive) [ 2015-04-16 ]

http://lists.askmonty.org/pipermail/commits/2015-April/007760.html

Comment by Jan Lindström (Inactive) [ 2015-04-21 ]

Ok to push.

Comment by Nirbhay Choubey (Inactive) [ 2015-04-23 ]

https://github.com/MariaDB/server/commit/0095697784a12cbb269238b354ac6f31800418fb

Generated at Thu Feb 08 07:23:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.