Trigger or routine body could be corrupted on export or editing

[nijel]

Steps to reproduce

Add trigger:

Trigger name: sqlinj
Definition: set @a='aaa''aaa'
Click "Go".

Then click on "Edit" or "Export"

Edit Result:
set @a='aaa'aaa'

Export Result:
FOR EACH ROW set @a='aaa'aaa'

Expected behaviour

The trigger should still be set @a='aaa''aaa'

Actual behaviour

Quote is truncated.

[nijel]

This is known MySQL/MariaDB bug, we have no means to fix this (there is no way to tell what was the body originally).

See reports there:

• http://bugs.mysql.com/bug.php?id=58342 (not fixed in MySQL server)
• https://jira.mariadb.org/browse/MDEV-7231 (fixed in MariaDB 10.1.12)