Below is the list of changes that have just been committed into a local
mysqldoc repository of heikki. When heikki does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.2852 05/06/22 17:10:10 heikki@stripped +2 -0
triggers.xml, innodb.xml:
Document that currently TRIGGERs are not activated by cascaded FOREIGN KEY operations
refman/triggers.xml
1.2 05/06/22 17:10:00 heikki@stripped +6 -0
Document that currently TRIGGERs are not activated by cascaded FOREIGN KEY operations
refman/innodb.xml
1.5 05/06/22 17:09:59 heikki@stripped +9 -0
Document that currently TRIGGERs are not activated by cascaded FOREIGN KEY operations
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: heikki
# Host: hundin.mysql.fi
# Root: /home/heikki/bk
--- 1.4/refman/innodb.xml Thu Jun 16 19:25:07 2005
+++ 1.5/refman/innodb.xml Wed Jun 22 17:09:59 2005
@@ -2028,6 +2028,11 @@
are only checked after the WHOLE SQL statement has been processed.
</para>
+ <para>
+ <emphasis role="bold">Note</emphasis>: Currently, triggers are not
+ activated by cascaded foreign key actions.
+ </para>
+
<para>
A simple example that relates <literal>parent</literal> and
<literal>child</literal> tables through a single-column foreign key:
@@ -6356,6 +6361,10 @@
<literal>UNIV_PAGE_SIZE</literal> and
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
+ </para></listitem>
+
+ <listitem><para>
+ Currently, triggers are not activated by cascaded foreign key actions.
</para></listitem>
</itemizedlist>
--- 1.1/refman/triggers.xml Thu Jun 16 02:46:58 2005
+++ 1.2/refman/triggers.xml Wed Jun 22 17:10:00 2005
@@ -99,6 +99,12 @@
</para>
<para>
+ <emphasis role="bold">Note</emphasis>: Currently, triggers are not
+ activated by cascaded foreign key actions. This limitation will be lifted
+ as soon as possible.
+ </para>
+
+ <para>
Although direct table references are not allowed in the triggered
statement, you can refer to columns in the table associated with the
trigger by using the names <literal>OLD</literal> and
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (heikki:1.2852) | Heikki Tuuri | 22 Jun |