Bug #12535 QB and trigger code
Submitted: 11 Aug 2005 20:07 Modified: 9 Sep 2005 9:09
Reporter: Robin Schumacher Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.13 OS:Windows (Win XP)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[11 Aug 2005 20:07] Robin Schumacher 
Description:
QB won't execute code to build trigger

How to repeat:
Execute the following:

DELIMITER //
DROP TRIGGER t_encrypt_ssn
//
CREATE TRIGGER t_encrypt_ssn BEFORE INSERT ON customer
FOR EACH ROW
BEGIN
     SET NEW.customer_ssn = aes_encrypt(NEW.customer_ssn,'password');
END
//
DELIMITER ;

Get error messages about delimiter statement:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER //
DROP TRIGGER t_encrypt_ssn
//
CREATE TRIGGER t_encrypt_ssn BEFOR' at line 1
[11 Aug 2005 20:13] Robin Schumacher 
Updated description
[11 Aug 2005 20:38] Jorge del Conde 
Verified w/QB 1.1.13
[9 Sep 2005 9:09] Vladimir Kolesnikov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html