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/09/22 23:13:33 UTC

[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by DanDebrunner

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 DanDebrunner:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

------------------------------------------------------------------------------
  Legend:
  ||<#00FF00>Yes ||The feature is supported. ||
  ||<#FFFF00>Yes* ||The feature is supported (e.g. through JDBC) but not according to the SQL standard. See explanatory comment.||
- ||<#FFFF00>Partial ||The feature is partially supported. ||
+ ||<#FFFF00>Partial ||The feature is partiallyD supported. ||
  ||<#FF0000>No ||The feature is '''not''' supported.||
  ||N/A ||Does not apply. ||
  || ||Not yet documented on this page ('''You''' may contribute). ||
@@ -401, +401 @@

  ||'''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*||Need to specify non standard MODE DB2SQL||
+ ||'''T211'''||'''Basic trigger capability'''||<#FFFF00>Yes*||<#FFFF00>Yes*||Need to specify non standard MODE DB2SQL (see [http://issues.apache.org/jira/browse/DERBY-1770 DERBY-1770])||
  ||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|| ||