Bug #15356 TRIGGER

• Submitted: 30 Nov 2005 16:32
• Modified: 4 Dec 2005 15:18
• Reporter: ivan kulikov
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.13
• OS: Windows (Win XP sp0)
• CPU Architecture: Any

[30 Nov 2005 16:32] ivan kulikov

Description:
I created script with trigger.
MySql failed. Service mysql was stoped.
Window about error (send letter to microsoft) was shown.

How to repeat:
Run my script and error must repeat.

[30 Nov 2005 17:27] Valeriy Kravchuk

Thank you for a problem report. Please, try to use GA version of MySQL 5, 5.0.15 or 5.0.16. 5.0.13 is really old. I had tried to execute your script, and it work OK on XP with 5.0.15. The only thing I addes is use <your_database> before creating triggers. See explanation in http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html (triggers are database-related now, not global). And, surely, no crashes.

So, please, try newer version and inform about the results.

[2 Dec 2005 8:38] ivan kulikov

Thanks!!!
I tried to write CREATE TRIGGER <my_database_name>.<my_trigger_name>…..
                     instead
	        CREATE TRIGGER <my_trigger_name> …..
All ok.

But I wish you to do notification about wrong syntax instead mysql fail…

[4 Dec 2005 15:18] Valeriy Kravchuk

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

There is no crash in 5.0.15 on Windows XP even without that <database name>. before the trigger name. Please, check:

mysql> delimiter //
mysql> CREATE TRIGGER trigger_bI_PhisicalPersons BEFORE INSERT
    ->  ON Billing.PhisicalPersons
    ->  FOR EACH ROW
    ->  BEGIN
    ->          INSERT INTO Billing.Persons (PersonType) VALUES (1);
    ->  END
    ->  //
ERROR 1435 (HY000): Trigger in wrong schema
mysql> delimiter ;
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.15-nt |
+-----------+
1 row in set (0.00 sec)