sql_mode is not retained when dumping triggers
Bug #1528569 reported by
Kenny Gryp
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Data Dumper |
Triaged
|
Medium
|
Max Bubenick |
Bug Description
The sql_mode is not retained when loading the triggers (probably same with stored procs). This causes them to behave differently.
Maybe we should also include the sql_mode it was dumped from before creating the triggers:
```
SET @PREV_CHARACTER
SET @PREV_CHARACTER
SET @PREV_COLLATION
SET character_
SET character_
SET collation_
CREATE DEFINER=`user`@`%` TRIGGER TABLE AFTER INSERT ON TABLE
FOR EACH ROW BEGIN
```
Changed in mydumper: | |
assignee: | nobody → Max Bubenick (max-bubenick) |
Changed in mydumper: | |
status: | New → Triaged |
importance: | Undecided → Medium |
milestone: | none → 0.9.3 |
To post a comment you must log in.