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/05 14:43:42 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

------------------------------------------------------------------------------
  ||'''T053'''||'''Explicit aliases for all-fields reference'''||N/A||<#FF0000>No|| ||
  ||'''T061'''||'''UCS support'''||N/A||<#FF0000>No|| ||
  ||'''T071'''||'''BIGINT data type'''||N/A||<#00FF00>Yes|| ||
- ||'''T111'''||'''Updatable joins, unions, and columns'''|| || || ||
+ ||'''T111'''||'''Updatable joins, unions, and columns'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T121'''||'''WITH (excluding RECURSIVE) in query expression'''|| || || ||
+ ||'''T121'''||'''WITH (excluding RECURSIVE) in query expression'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T122'''||'''WITH (excluding RECURSIVE) in subquery'''||N/A|| || ||
+ ||'''T122'''||'''WITH (excluding RECURSIVE) in subquery'''||N/A||<#FF0000>No|| ||
- ||'''T131'''||'''Recursive query'''|| || || ||
+ ||'''T131'''||'''Recursive query'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T132'''||'''Recursive query in subquery'''||N/A|| || ||
+ ||'''T132'''||'''Recursive query in subquery'''||N/A||<#FF0000>No|| ||
  ||'''T141'''||'''SIMILAR predicate'''|| || || ||
  ||'''T151'''||'''DISTINCT predicate'''|| || || ||
  ||'''T152'''||'''DISTINCT predicate with negation'''||N/A|| || ||
- ||'''T171'''||'''LIKE clause in table definition'''|| || || ||
+ ||'''T171'''||'''LIKE clause in table definition'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T172'''||'''AS subquery clause in table definition'''||N/A|| || ||
+ ||'''T172'''||'''AS subquery clause in table definition'''||N/A||<#FF0000>No|| ||
- ||'''T173'''||'''Extended LIKE clause in table definition'''||N/A|| || ||
+ ||'''T173'''||'''Extended LIKE clause in table definition'''||N/A||<#FF0000>No|| ||
  ||'''T174'''||'''Identity columns'''||N/A||<#FFFF00>Sort of || MAXVALUE and CYCLE not supported. Deviation from standard: A comma (",") is required before INCREMENT. ||
  ||'''T175'''||'''Generated columns'''||N/A||<#FF0000>No || ||
  ||'''T176'''||'''Sequence generator support'''||N/A||<#FF0000>No || ||
@@ -411, +411 @@

  ||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.||<#00FF00>Yes||<#00FF00>Yes||I think....||
  ||'''T212'''||'''Enhanced trigger capability'''|| || || ||
- ||'''T231'''||'''Sensitive cursors'''|| || || ||
+ ||'''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|| ||
  ||'''T261'''||'''Chained transactions'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T271'''||'''Savepoints'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''T272'''||'''Enhanced savepoint management'''||N/A||<#FF0000>No|| ||
  ||'''T281'''||'''SELECT privilege with column granularity'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T301'''||'''Functional dependencies'''|| || || ||
+ ||'''T301'''||'''Functional dependencies'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T312'''||'''OVERLAY function'''|| || || ||
+ ||'''T312'''||'''OVERLAY function'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T322'''||'''Overloading of SQL-invoked functions and procedures'''|| || || ||
  ||'''T323'''||'''Explicit security for external routines'''|| || || ||
- ||'''T324'''||'''Explicit security for SQL routines'''||N/A|| || ||
+ ||'''T324'''||'''Explicit security for SQL routines'''||N/A||<#FF0000>No|| ||
- ||'''T325'''||'''Qualified SQL parameter references'''||N/A|| || ||
+ ||'''T325'''||'''Qualified SQL parameter references'''||N/A||<#FF0000>No|| ||
  ||'''T326'''||'''Table functions'''||N/A|| || ||
  ||'''T331'''||'''Basic roles'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T332'''||'''Extended roles'''||<#FF0000>No||<#FF0000>No|| ||
@@ -434, +434 @@

  ||'''T434'''||'''GROUP BY DISINCT'''||N/A|| || ||
  ||'''T441'''||'''ABS and MOD functions'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''T461'''||'''Symmetric BETWEEN predicate'''|| || || ||
- ||'''T471'''||'''Result sets return value'''|| || || ||
+ ||'''T471'''||'''Result sets return value'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T491'''||'''LATERAL derived table'''|| || || ||
+ ||'''T491'''||'''LATERAL derived table'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T501'''||'''Enhanced EXISTS predicate'''|| || || ||
- ||'''T511'''||'''Transaction counts'''|| || || ||
+ ||'''T511'''||'''Transaction counts'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T541'''||'''Updatable table references'''|| ||N/A|| ||
+ ||'''T541'''||'''Updatable table references'''||<#FF0000>No||N/A|| ||
- ||'''T551'''||'''Optional key words for default syntax'''|| || || ||
+ ||'''T551'''||'''Optional key words for default syntax'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T561'''||'''Holdable locators'''|| || || ||
- ||'''T571'''||'''Array-returning external SQL-invoked functions'''|| || || ||
+ ||'''T571'''||'''Array-returning external SQL-invoked functions'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T572'''||'''Multiset-returning external SQL-invoked functions'''||N/A|| || ||
+ ||'''T572'''||'''Multiset-returning external SQL-invoked functions'''||N/A||<#FF0000>No|| ||
- ||'''T581'''||'''Regular expression substring function'''|| || || ||
+ ||'''T581'''||'''Regular expression substring function'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T591'''||'''UNIQUE constraints of possibly null columns'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T601'''||'''Local cursor references'''|| || || ||
  ||'''T611'''||'''Elementary OLAP operations'''||N/A|| || ||
  ||'''T612'''||'''Advanced OLAP operations'''||N/A|| || ||
- ||'''T613'''||'''Sampling'''||N/A|| || ||
+ ||'''T613'''||'''Sampling'''||N/A||<#FF0000>No|| ||
- ||'''T621'''||'''Enhanced numeric functions'''||N/A|| || ||
+ ||'''T621'''||'''Enhanced numeric functions'''||N/A||<#FF0000>No|| ||
- ||'''T641'''||'''Multiple column assignment'''||N/A|| || ||
+ ||'''T641'''||'''Multiple column assignment'''||N/A||<#FF0000>No|| ||
- ||'''T651'''||'''SQL-schema statements in SQL routines'''|| || || ||
+ ||'''T651'''||'''SQL-schema statements in SQL routines'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T652'''||'''SQL-dynamic statements in SQL routines'''|| || || ||
+ ||'''T652'''||'''SQL-dynamic statements in SQL routines'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T653'''||'''SQL-schema statements in external routines'''|| || || ||
+ ||'''T653'''||'''SQL-schema statements in external routines'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T654'''||'''SQL-dynamic statements in external routines'''|| || || ||
+ ||'''T654'''||'''SQL-dynamic statements in external routines'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T655'''||'''Cyclically dependent routines'''|| || || ||
+ ||'''T655'''||'''Cyclically dependent routines'''||<#FF0000>No||<#FF0000>No|| ||