db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1547440 - in /db/derby/docs/trunk/src/ref: rrefdropfunctionstatement.dita rrefdropprocedurestatement.dita rrefsqlj34148.dita rrefsqlj61102.dita rrefsqljdropsynonym.dita rrefsqljdroptype.dita
Date Tue, 03 Dec 2013 15:38:43 GMT
Author: chaase3
Date: Tue Dec  3 15:38:42 2013
New Revision: 1547440

URL: http://svn.apache.org/r1547440
Log:
DERBY-6420  Clarify how DROP statements work on trigger dependencies

Modified 6 Reference Manual topics.

Patch: DERBY-6420-2.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita
    db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita
    db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
    db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
    db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita
    db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita

Modified: db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita?rev=1547440&r1=1547439&r2=1547440&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita Tue Dec  3 15:38:42 2013
@@ -36,7 +36,8 @@ implied schema</li>
 <i><xref
 href="rrefsqljgenerationclause.dita#rrefsqljgenerationclause">generationClause</xref></i>
 of a generated column</li>
-<li>If you try to drop a user-defined function that is invoked in a view</li>
+<li>If you try to drop a user-defined function that is invoked in a view or
+trigger</li>
 </ul>
 </section>
 </refbody>

Modified: db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita?rev=1547440&r1=1547439&r2=1547440&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita Tue Dec  3 15:38:42 2013
@@ -25,10 +25,16 @@ href="rrefprocedurename.dita#rrefprocedu
 </codeblock>
 <p>Identifies the particular procedure to be dropped, and is valid only if there
 is exactly one procedure instance with the <i>procedureName</i> in the schema.
-The identified procedure can have any number of parameters defined for it. If no
-procedure with the indicated name in the named or implied schema, an error
-(SQLSTATE 42704) will occur. An error will also occur if there is more than one
-specific instance of the procedure in the named or implied schema.</p>
+The identified procedure can have any number of parameters defined for it.</p>
+<p>An error will occur in any of the following circumstances:</p>
+<ul>
+<li>If no procedure with the indicated name exists in the named or implied
+schema (the error is SQLSTATE 42704)</li>
+<li>If there is more than one specific instance of the procedure in the named or
+implied schema</li>
+<li>If you try to drop a user-defined procedure that is invoked in a
+trigger</li>
+</ul>
 </section>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj34148.dita?rev=1547440&r1=1547439&r2=1547440&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj34148.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj34148.dita Tue Dec  3 15:38:42 2013
@@ -30,8 +30,11 @@ limitations under the License.
 <section id="sqlj38361"><title>Statement dependency system</title> <p>Triggers,
 constraints (primary, unique, check and references from the table being dropped)
 and indexes on the table are silently dropped. The existence of an open cursor
-that references table being dropped cause the DROP TABLE statement to generate
-an error, and the table is not dropped.</p> <p>Dropping a table invalidates
+that references a table being dropped causes the DROP TABLE statement to
+generate an error, and the table is not dropped.</p>
+<p>The DROP TABLE statement will also generate an error if the table is used in
+a view or trigger.</p>
+<p>Dropping a table invalidates
 statements that depend on the table. (Invalidating a statement causes it to
 be recompiled upon the next execution. See <xref href="crefsqlj22771.dita#crefsqlj22771"></xref>.)</p>
</section>
 </refbody>

Modified: db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj61102.dita?rev=1547440&r1=1547439&r2=1547440&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj61102.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj61102.dita Tue Dec  3 15:38:42 2013
@@ -31,8 +31,8 @@ href="rrefviewname.dita#rrefviewname">vi
 <example><title>Example</title>
 <codeblock><b>DROP VIEW AnIdentifier</b></codeblock> </example>
 <section><title>Statement dependency system</title> <p>Any statements
-referencing the view are invalidated on a DROP VIEW statement. DROP VIEW is
-disallowed if there are any views or open cursors dependent on the view.</p>
+referencing the view are invalidated on a DROP VIEW statement. DROP VIEW fails
+if there are any views, triggers, or open cursors dependent on the view.</p>
 <p>Normally, you must drop a view before you drop any objects that the view
 depends on. However, if you issue an ALTER TABLE DROP COLUMN command with the
 CASCADE option, any views that depend on the column will be dropped. Also, if

Modified: db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita?rev=1547440&r1=1547439&r2=1547440&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita Tue Dec  3 15:38:42 2013
@@ -25,7 +25,10 @@ limitations under the License.
 </keywords>
 </metadata></prolog>
 <refbody>
-<section> <p>Drops the specified synonym from a table or view.</p></section>
+<section> <p>Drops the specified synonym from a table or view.</p>
+<p>An error will occur if there are any views or triggers dependent on the
+table or view defined by the synonym.</p>
+</section>
 <refsyn><title>Syntax</title> <codeblock><b>DROP SYNONYM <i><xref
 href="rrefsynonymname.dita#rrefsynonymname">synonymName</xref></i></b></codeblock>
</refsyn>
 </refbody>

Modified: db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita?rev=1547440&r1=1547439&r2=1547440&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita Tue Dec  3 15:38:42 2013
@@ -44,6 +44,8 @@ includes the following restrictions:</p>
 <ul>
 <li>Table columns: No table columns have this UDT.</li>
 <li>Views: No view definition involves expressions which have this UDT.</li>
+<li>Triggers: No trigger definition involves expressions which have this
+UDT.</li>
 <li>Constraints: No constraints reference expressions of this UDT.</li>
 <li>Generated columns: No generated columns reference expressions of this
 UDT.</li>



Mime
View raw message