enterprise-support team mailing list archive

Thread
Date

[Bug 1528569] [NEW] sql_mode is not retained when dumping triggers

To: enterprise-support@xxxxxxxxxxxxxxxxxxx
From: Kenny Gryp <gryp@xxxxxxxx>
Date: Tue, 22 Dec 2015 13:34:17 -0000
Reply-to: Bug 1528569 <1528569@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

Public bug reported:

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   
```

** Affects: mydumper
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1528569

Title:
  sql_mode is not retained when dumping triggers

To manage notifications about this bug go to:
https://bugs.launchpad.net/mydumper/+bug/1528569/+subscriptions