Autocomplete Does Not Work With New And Old In Triggers

[hiero]

The autocomplete functionality does not work with NEW and OLD in triggers. Should be relatively easy to implement and would make life easier. I'm currently testing 6.1RC Enterprise Edition.

Regards,

Frank

[peterlaursen]

true

The database (keywords.db) user for autocomplete and syntax highlighting is not complete for the latest MySQL versions. Keywords are not version specific either. This is planned for version 6.2.

About NEW and OLD keywords

http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html

“The OLD and NEW keywords enable you to access columns in the rows affected by a trigger. (OLD and NEW are not case sensitive.) In an INSERT trigger, only NEW.col_name can be used; there is no old row. In a DELETE trigger, only OLD.col_name can be used; there is no new row. In an UPDATE trigger, you can use OLD.col_name to refer to the columns of a row before it is updated and NEW.col_name to refer to the columns of the row after it is updated. “

But you can add your own keywords – refer to

http://webyog.com/faq/content/8/93/en/can-…o_complete.html

And if it is very importabt for you we can of course add those two with 6.1 FINAL too!

[hiero]

I really would be happy to get the NEW and OLD keyword support already in 6.1 Final as I'm working quite often with triggers referencing fields based on these two keywords.

[Author]

Posts