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 Fri, 06 Jan 2006 13:55:59 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

------------------------------------------------------------------------------
  ||'''F801'''||'''Full set function '''||<#FFFF00>Partial||<#FFFF00>Partial||DISTINCT
in more than one aggregate function will not work, but SELECT DISTINCT with DISTINCT in one
aggregate function will work. ||
  ||'''F811'''||'''Extended flagging'''||<#FF0000>No||N/A|| ||
  ||'''F813'''||'''Extended flagging -- Part 1, Subclause 8.5, "SQL flagger": With "level
of flagging" specified to be Core SQL Flagging and "extent of checking" specified to be Catalog
Lookup'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F821'''||'''Local table references'''|| || || ||
+ ||'''F821'''||'''Local table references'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F831'''||'''Full cursor update'''||<#FFFF00>Partial||<#FFFF00>Partial||Update
and delete of forward only cursors. See issues [http://issues.apache.org/jira/browse/DERBY-98
98]  [http://issues.apache.org/jira/browse/DERBY-99 99] [http://issues.apache.org/jira/browse/DERBY-100
100] [http://issues.apache.org/jira/browse/DERBY-690 690]||
  ||F831-01||Updateable scrollable cursors||<#FF0000>No||<#FF0000>No||||
  ||F831-02||Updateable ordered cursors||<#FF0000>No||<#FF0000>No|| ||
@@ -399, +399 @@

  ||'''T212'''||'''Enhanced trigger capability'''|| || || ||
  ||'''T231'''||'''Sensitive cursors'''|| || || ||
  ||'''T241'''||'''START TRANSACTION statement'''||<#FF0000>No||<#FF0000>No||
||
- ||'''T251'''||'''SET TRANSACTION statement: LOCAL option'''|| || || ||
+ ||'''T251'''||'''SET TRANSACTION statement: LOCAL option'''||<#FF0000>No||<#FF0000>No||
||
- ||'''T261'''||'''Chained transactions'''|| || || ||
+ ||'''T261'''||'''Chained transactions'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T271'''||'''Savepoints'''||<#00FF00>Yes||<#00FF00>Yes|| ||
- ||'''T272'''||'''Enhanced savepoint management'''||N/A|| || ||
+ ||'''T272'''||'''Enhanced savepoint management'''||N/A||<#FF0000>No|| ||
- ||'''T281'''||'''SELECT privilege with column granularity'''|| || || ||
+ ||'''T281'''||'''SELECT privilege with column granularity'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T301'''||'''Functional dependencies'''|| || || ||
  ||'''T312'''||'''OVERLAY function'''|| || || ||
  ||'''T322'''||'''Overloading of SQL-invoked functions and procedures'''|| || || ||

Mime
View raw message