sql_mode is not retained when dumping triggers

Bug #1528569 reported by Kenny Gryp
6
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_CLIENT=@@CHARACTER_SET_CLIENT;
SET @PREV_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @PREV_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET character_set_client = latin1;
SET character_set_results = latin1;
SET collation_connection = latin1_swedish_ci;
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.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.