Commenting out Trigger Deletes it

[Mike Harris]

Greetings!

At work currently, and while debugging a trigger that wasn't working, I noticed a bug which has happened twice now (once live, damn me for not making a backup first, and 2nd time as a test).

When you multiline comment a trigger and hit apply, the trigger is deleted. Now, one could simply comment between "BEGIN" and "END" and not have a problem, which is what I should have done, but in my haste I commented the entire block of code. This consistently happens every time I do it.

I understand why it's doing this, because commenting out "CREATE TRIGGER" is going to wipe it out, but perhaps we could add some dummy-proof things in the editor for dummies like me who wipe their trigger out by trying to do it? Perhaps we could implement a syntax error detector, such as when you try to write a bad SELECT statement?

Thank you!