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 Wed, 21 Nov 2007 12:47:23 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||<#FF0000>No || ||
  ||'''T191'''||'''Referential action RESTRICT'''|| || || ||
  ||'''T201'''||'''Comparable data types for referential constraints'''|| || || ||
- ||'''T211'''||'''Basic trigger capability'''||<#FFFF00>Yes*||<#FFFF00>Yes*||10.2
and earlier. Need to specify non standard MODE DB2SQL (see [http://issues.apache.org/jira/browse/DERBY-1770
DERBY-1770]). Also, the REFERENCING part is not quite compliant. The optional ROW keyword
is not allowed, and NEW TABLE/OLD TABLE must be written NEW_TABLE/OLD_TABLE||
+ ||'''T211'''||'''Basic trigger capability'''||<#FFFF00>Yes*||<#FFFF00>Yes*||10.2
and earlier: Need to specify non standard MODE DB2SQL (see [http://issues.apache.org/jira/browse/DERBY-1770
DERBY-1770]). Also, the REFERENCING part is not quite compliant. The optional ROW keyword
is not allowed, and NEW TABLE/OLD TABLE must be written NEW_TABLE/OLD_TABLE||
  ||T211-01||Triggers activated on UPDATE, INSERT, or DELETE of one base table.||<#00FF00>Yes||<#00FF00>Yes||
||
  ||T211-02||BEFORE triggers||<#FFFF00>Yes*||<#FFFF00>Yes*||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|| ||

Mime
View raw message