You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2006/05/04 14:05:46 UTC
[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by BerntJohnsen
Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.
The following page has been changed by BerntJohnsen:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
------------------------------------------------------------------------------
||'''T176'''||'''Sequence generator support'''||N/A|| || ||
||'''T191'''||'''Referential action RESTRICT'''|| || || ||
||'''T201'''||'''Comparable data types for referential constraints'''|| || || ||
- ||'''T211'''||'''Basic trigger capability'''|| || || ||
+ ||'''T211'''||'''Basic trigger capability'''||<#FFFF00>Sort of||<#FFFF00>Sort of||Need to specify non standard MODE DB2SQL||
- ||T211-01||Triggers activated on UPDATE, INSERT, or DELETE of one base table.|| || || ||
+ ||T211-01||Triggers activated on UPDATE, INSERT, or DELETE of one base table.||<#00FF00>Yes||<#00FF00>Yes|| ||
- ||T211-02||BEFORE triggers|| || || ||
- ||T211-03||AFTER triggers|| || || ||
- ||T211-04||FOR EACH ROW triggers|| || || ||
+ ||T211-02||BEFORE triggers||<#FFFF00>Sort of||<#FFFF00>Sort of||Need to specify non-standard ON CASCADE BEFORE. Before triggers cannot have INSERT, UPDATE or DELETE statements as their action.||
+ ||T211-03||AFTER triggers||<#00FF00>Yes||<#00FF00>Yes|| ||
+ ||T211-04||FOR EACH ROW triggers||<#00FF00>Yes||<#00FF00>Yes|| ||
- ||T211-05||Ability to specify a search condition that shall be True before the trigger is invoked.|| || || ||
+ ||T211-05||Ability to specify a search condition that shall be True before the trigger is invoked.||<#FF0000>No||<#FF0000>No|| ||
||T211-06||Support for run-time rules for the interaction of triggers and constraints.|| || || ||
- ||T211-07||TRIGGER privilege|| || || ||
+ ||T211-07||TRIGGER privilege||<#FF0000>No||<#FF0000>No|| ||
- ||T211-08||Multiple triggers for the same event are executed in the order in which they were created in the catalog.|| || || ||
+ ||T211-08||Multiple triggers for the same event are executed in the order in which they were created in the catalog.||<#00FF00>Yes||<#00FF00>Yes||I think....||
||'''T212'''||'''Enhanced trigger capability'''|| || || ||
||'''T231'''||'''Sensitive cursors'''|| || || ||
||'''T241'''||'''START TRANSACTION statement'''||<#FF0000>No||<#FF0000>No|| ||