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 Thu, 05 Jan 2006 11:58:25 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

------------------------------------------------------------------------------
  ||'''F251'''||'''Domain support'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F262'''||'''Extended CASE expression'''||N/A|| || ||
  ||'''F271'''||'''Compound character literals'''||<#FF0000>No||<#FF0000>No||
||
- ||'''F281'''||'''LIKE enhancements'''|| || || ||
+ ||'''F281'''||'''LIKE enhancements'''||<#FFFF00>Partial||<#FFFF00>Partial||
The <escape character> have to be a <value specification>||
  ||'''F291'''||'''UNIQUE predicate'''|| || || ||
  ||'''F301'''||'''CORRESPONDING in query expressions'''||<#FF0000>No||<#FF0000>No||
||
  ||'''F302'''||'''INTERSECT table operator'''||<#00FF00>Yes||<#00FF00>Yes|| ||
@@ -261, +261 @@

  ||'''F401'''||'''Extended joined table'''||<#FF0000>No||<#FF0000>No|| ||
  ||F401-01||NATURAL JOIN||<#FF0000>No||<#FF0000>No|| ||
  ||F401-02||FULL OUTER JOIN||<#FF0000>No||<#FF0000>No|| ||
- ||F401-04||CROSS JOIN|| || || ||
+ ||F401-04||CROSS JOIN||<#FF0000>No||<#FF0000>No||Note that `SELECT * FROM a
CROSS JOIN b` is identical to `SELECT * FROM a,b` (without a WHERE-clause)||
  ||'''F402'''||'''Named column joins for LOBs, arrays, and multisets'''||N/A|| || ||
  ||'''F411'''||'''Time zone specification'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F421'''||'''National character'''||<#FF0000>No||<#FF0000>No|| ||
@@ -442, +442 @@

  ||'''T653'''||'''SQL-schema statements in external routines'''|| || || ||
  ||'''T654'''||'''SQL-dynamic statements in external routines'''|| || || ||
  ||'''T655'''||'''Cyclically dependent routines'''|| || || ||
- 1
  

Mime
View raw message