db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "SQLvsDerbyFeatures" by BerntJohnsen
Date Thu, 04 May 2006 12:05:46 GMT
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||
||

Mime
View raw message