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

------------------------------------------------------------------------------
  ||'''F521'''||'''Assertions'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F531'''||'''Temporary tables'''||<#FFFF00>Partial||<#FFFF00>Partial|| Global tables ||
  ||'''F555'''||'''Enhanced seconds precision'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F561'''||'''Full value expressions'''|| || || ||
+ ||'''F561'''||'''Full value expressions'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F571'''||'''Truth value tests'''||<#FF0000>No||<#FF0000>No|| Due for 10.2? [http://issues.apache.org/jira/browse/DERBY-499 Issue DERBY-499]||
  ||'''F591'''||'''Derived tables'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''F611'''||'''Indicator data types'''||<#FF0000>No||<#FF0000>No|| ||
@@ -303, +303 @@

  ||'''F721'''||'''Deferrable constraints'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F731'''||'''INSERT column privileges'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F741'''||'''Referential MATCH types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F751'''||'''View CHECK enhancements'''|| || || ||
+ ||'''F751'''||'''View CHECK enhancements'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F761'''||'''Session management'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F771'''||'''Connection management'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F781'''||'''Self-referencing operations'''|| || || ||
+ ||'''F781'''||'''Self-referencing operations'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''F791'''||'''Insensitive cursors'''||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC||
- ||'''F801'''||'''Full set function '''|| || || ||
+ ||'''F801'''||'''Full set function '''||<#FFFF00>Partial||<#FFFF00>Partial||DISTICT on 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'''|| || || ||