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/12/11 15:39:37 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

------------------------------------------------------------------------------
  ||E061-01||Comparison predicate||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E061-02||BETWEEN predicate||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E061-03||IN predicate with list of values||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E061-04||LIKE predicate||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E061-05||LIKE predicate: ESCAPE clause||<#00FF00>Yes||<#00FF00>Yes||   ||
+ ||E061-04||LIKE predicate||<#FFFF00>Yes*||<#FFFF00>Partial|| Direct column references in patterns not supported.  [http://issues.apache.org/jira/browse/DERBY-2147 Issue DERBY-2147]||
+ ||E061-05||LIKE predicate: ESCAPE clause||<#FFFF00>Partial*||<#FFFF00>Yes*|| Direct column references in escape clause not supported.  [http://issues.apache.org/jira/browse/DERBY-2147 Issue DERBY-2147] ||
  ||E061-06||NULL predicate||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E061-07||Quantified comparison predicate||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E061-08||EXISTS predicate||<#00FF00>Yes||<#00FF00>Yes||   ||