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 Tue, 03 Jul 2007 12:37:20 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

------------------------------------------------------------------------------
  ||E021-06||SUBSTRING function||<#FFFF00>Yes*||<#FFFF00>Yes*||Called SUBSTR.
xNo FROM...FOR, just commas. {fn SUBSTRING(....)} is according to JDBC specification.  ||
  ||E021-07||Character concatenation||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E021-08||UPPER and LOWER functions||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E021-09||TRIM function||<#FFFF00>Yes (10.3)||<#FFFF00>Yes (10.3)|| Earlier
versions (10.0 - 10.2): Simple LTRIM and RTRIM. {fn LTRIM(...)} and {fn RTRIM(...)} is according
to JDBC specification.  ||
+ ||E021-09||TRIM function||<#00FF00>Yes (10.3)||<#00FF00>Yes (10.3)|| Earlier
versions (10.0 - 10.2): Simple LTRIM and RTRIM. {fn LTRIM(...)} and {fn RTRIM(...)} is according
to JDBC specification.  ||
  ||E021-10||Implicit casting among the character data types||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||E021-11||POSITION function||<#FFFF00>Yes*||<#FFFF00>Yes*||Called LOCATE. {fn
LOCATE(...)} is according to JDBC specification.  ||
  ||E021-12||Character comparison||<#00FF00>Yes||<#00FF00>Yes||   ||
@@ -55, +55 @@

  ||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||<#FFFF00>Partial||<#FFFF00>Partial|| Direct column
references in patterns not supported.  [http://issues.apache.org/jira/browse/DERBY-2147 Issue
DERBY-2147]||
+ ||E061-04||LIKE predicate||<#00FF00>Yes (10.3)||<#00FF00>Yes (10.3)|| In earlier
versions (10-0 - 10.2): Direct column references in patterns was not supported.  [http://issues.apache.org/jira/browse/DERBY-2147
Issue DERBY-2147]||
- ||E061-05||LIKE predicate: ESCAPE clause||<#FFFF00>Partial||<#FFFF00>Partial||
Direct column references in escape clause not supported.  [http://issues.apache.org/jira/browse/DERBY-2147
Issue DERBY-2147] ||
+ ||E061-05||LIKE predicate: ESCAPE clause||<#00FF00>Yes (10.3)||<#00FF00>Yes
(10.3)|| In earlier versions (10-0 - 10.2): Direct column references in escape clause was
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||   ||

Mime
View raw message