Bug #12639 Change using-triggers.html, so it is correlated to create-trigger.html

• Submitted: 18 Aug 2005 11:09
• Modified: 18 Aug 2005 23:41
• Reporter: Gleb Paharenko
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• CPU Architecture: Any

[18 Aug 2005 11:09] Gleb Paharenko

Description:
At 
  http://dev.mysql.com/doc/mysql/en/using-triggers.html

we have:
" The trigger cannot refer directly to tables by name, including the table with which the trigger is associated. You can, however, use the keywords OLD and NEW. OLD refers to an existing row to be deleted or a row to be updated before the update occurs. NEW refers to a new row to be inserted or an updated row after the update occurs."

And at
  http://dev.mysql.com/doc/mysql/en/create-trigger.html

"Note: Before MySQL 5.0.10, triggers may not contain direct references to tables by name. Beginning with MySQL 5.0.10, you may write triggers such as the one named testref shown in this example:"

How to repeat:
see above

Suggested fix:
Add the same "Note:.." to http://dev.mysql.com/doc/mysql/en/using-triggers.html

[18 Aug 2005 23:41] Paul DuBois

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).