Re: Triggers now work (it's official)

[Markus Popp]

Hi,

that are some great things that are going on ;-). There's just one big question that I have about triggers - is it still up to date, that the SUPER privilege is required to let a user create triggers? Wouldn't that be a problem that it's impossible to give a non privileged user the permission to create triggers, without giving him also further unintended permissions (like e.g. killing processes)?

As for stored procedures (a little off topic here), I hope that in the final release it will be possible again to write self referencing SPs, use EXECUTE and PREPARE - and that it's possible to use variables in the LIMIT clause. These are very important features to make the language flexible.

For MySQL 5.1, I hope that SPs, UDFs and triggers also get extensive error handling features ;-).

Markus

--
Markus Popp, Web Developer, mysql.com
Oracle Austria