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 KnutAndersHatlen
Date Mon, 16 Jun 2014 14:01:45 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "SQLvsDerbyFeatures" page has been changed by KnutAndersHatlen:
https://wiki.apache.org/db-derby/SQLvsDerbyFeatures?action=diff&rev1=76&rev2=77

  ||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. ||<#FF0000>No ||<#FF0000>No || ||
- ||T211-06 ||Support for run-time rules for the interaction of triggers and constraints.
|| || || ||
+ ||T211-06 ||Support for run-time rules for the interaction of triggers and constraints.
||<#FF0000>No ||<#FF0000>No || ||
  ||T211-07 ||TRIGGER privilege ||<#00FF00>Yes (10.2) ||<#00FF00>Yes (10.2) ||
||
  ||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''' || || || ||
+ ||'''T212''' ||'''Enhanced trigger capability''' ||<#00FF00>Yes ||<#00FF00>Yes
|| ||
  ||'''T231''' ||'''Sensitive cursors''' ||<#FF0000>No ||<#FF0000>No || ||
  ||'''T241''' ||'''START TRANSACTION statement''' ||<#FF0000>No ||<#FF0000>No
|| ||
  ||'''T251''' ||'''SET TRANSACTION statement: LOCAL option''' ||<#FF0000>No ||<#FF0000>No
|| ||
@@ -421, +421 @@

  ||'''T301''' ||'''Functional dependencies''' ||<#FF0000>No ||<#FF0000>No ||
||
  ||'''T312''' ||'''OVERLAY function''' ||<#FF0000>No ||<#FF0000>No || ||
  ||'''T322''' ||'''Overloading of SQL-invoked functions and procedures''' || || || ||
- ||'''T323''' ||'''Explicit security for external routines''' || || || ||
+ ||'''T323''' ||'''Explicit security for external routines''' ||<#00FF00>Yes ||<#00FF00>Yes
||From 10.7 ||
  ||'''T324''' ||'''Explicit security for SQL routines''' ||N/A ||<#FF0000>No || ||
  ||'''T325''' ||'''Qualified SQL parameter references''' ||N/A ||<#FF0000>No || ||
  ||'''T326''' ||'''Table functions''' ||N/A ||<#FFFF00>Partial || ||

Mime
View raw message