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/08/17 10:52:34 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

------------------------------------------------------------------------------
  ||E091-07||DISTINCT qualifier||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||'''E101'''||'''Basic data manipulation'''||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E101-01||INSERT statement||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E101-03||Searched UPDATE statement||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E101-04||Searched DELETE statement||<#00FF00>Yes||<#00FF00>Yes||   ||
+ ||E101-03||Searched UPDATE statement||<#00FF00>Yes||<#FFFF00>Partial||''correlation name'' not supported||
+ ||E101-04||Searched DELETE statement||<#00FF00>Yes||<#FFFF00>Partial||''correlation name'' not supported||
  ||'''E111'''||'''Single row select statement'''||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||'''E121'''||'''Basic cursor support'''||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC  ||
  ||E121-01||Declare cursor||<#FF0000>No||<#FF0000>No||   ||
  ||E121-02||ORDER BY columns need not be in select list||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E121-03||Value expressions in ORDER BY clause||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E121-04||OPEN statement||<#FF0000>No||<#FF0000>No||   ||
- ||E121-06||Positioned UPDATE statement||<#00FF00>Yes||<#00FF00>Yes||   ||
+ ||E121-06||Positioned UPDATE statement||<#00FF00>Yes||<#FFFF00>Partial||''correlation name'' not supported||
- ||E121-07||Positioned DELETE statement||<#00FF00>Yes||<#00FF00>Yes||   ||
+ ||E121-07||Positioned DELETE statement||<#00FF00>Yes||<#FFFF00>Partial||''correlation name'' not supported||
  ||E121-08||CLOSE statement||<#FF0000>No||<#FF0000>No||   ||
  ||E121-10||FETCH statement||<#FF0000>No||<#FF0000>No||   ||
  ||E121-17||WITH HOLD cursors||<#FF0000>No||<#FF0000>No||   ||