Author: paul
Date: 2007-02-22 20:10:55 +0100 (Thu, 22 Feb 2007)
New Revision: 5030
Log:
r20367@polar: paul | 2007-02-22 13:06:56 -0600
Describe operation of triggers for BLACKHOLE tables. (Guiseppe, Serg)
Modified:
trunk/refman-5.0/se-blackhole.xml
trunk/refman-5.1/se-blackhole.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:20366
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16721
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:20367
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16721
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/refman-5.0/se-blackhole.xml
===================================================================
--- trunk/refman-5.0/se-blackhole.xml 2007-02-22 19:10:36 UTC (rev 5029)
+++ trunk/refman-5.0/se-blackhole.xml 2007-02-22 19:10:55 UTC (rev 5030)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 0; 814 bytes
@@ -116,6 +116,15 @@
</para>
<para>
+ <literal>INSERT</literal> triggers for <literal>BLACKHOLE</literal>
+ tables work as expected. However, because the
+ <literal>BLACKHOLE</literal> table does not actually store any data,
+ <literal>UPDATE</literal> and <literal>DELETE</literal> triggers are
+ not activated: The <literal>FOR ANY ROW</literal> clause in the
+ trigger definition does not apply because there are no rows.
+ </para>
+
+ <para>
Other possible uses for the <literal>BLACKHOLE</literal> storage
engine include:
</para>
Modified: trunk/refman-5.1/se-blackhole.xml
===================================================================
--- trunk/refman-5.1/se-blackhole.xml 2007-02-22 19:10:36 UTC (rev 5029)
+++ trunk/refman-5.1/se-blackhole.xml 2007-02-22 19:10:55 UTC (rev 5030)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 0; 814 bytes
@@ -115,6 +115,15 @@
</para>
<para>
+ <literal>INSERT</literal> triggers for <literal>BLACKHOLE</literal>
+ tables work as expected. However, because the
+ <literal>BLACKHOLE</literal> table does not actually store any data,
+ <literal>UPDATE</literal> and <literal>DELETE</literal> triggers are
+ not activated: The <literal>FOR ANY ROW</literal> clause in the
+ trigger definition does not apply because there are no rows.
+ </para>
+
+ <para>
Other possible uses for the <literal>BLACKHOLE</literal> storage
engine include:
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5030 - in trunk: . refman-5.0 refman-5.1 | paul | 22 Feb |
