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 Wed, 06 Sep 2006 08:05: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

------------------------------------------------------------------------------
  ||T041-03|| POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types
-- Subclause 6.27, "<numeric value function>": The <position expression> for expressions
of type BINARY LARGE OBJECT and CHARACTER LARGE OBJECT -- Subclause 6.27, "<numeric value
function>": The <char length expression> for expressions of type CHARACTER LARGE
OBJECT -- Subclause 6.27, "<numeric value function>": The <octet length expression>
for expressions of type BINARY LARGE OBJECT and CHARACTER LARGE OBJECT -- Subclause 6.29,
"<string value function>": The <fold> function for expressions of type CHARACTER
LARGE OBJECT -- Subclause 6.29, "<string value function>": The <trim function>
for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.29, "<string value function>":
The <blob trim function> -- Subclause 6.29, "<string value function>": The <character
substring function> for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.29, "<string
value function>": The <blob
  substring function> ||<#FFFF00>Yes*||<#FFFF00>Yes*||Not standard SQL syntax.
See notes on features E021-04, E021-06, E021-09 and E021-11||
  ||T041-04|| Concatenation of LOB data types -- Subclause 6.28, "<string value expression>":
The <concatenation> expression for expressions of type CHARACTER LARGE OBJECT -- Subclause
6.28, "<string value expression>": The <blob concatenation> expression||<#00FF00>Yes||<#00FF00>Yes||
||
  ||T041-05|| LOB locator: non-holdable -- Subclause 13.3, "<externally-invoked procedure>":
<locator indication> -- Subclause 14.14, "<free locator statement>"||<#FF0000>No||<#FF0000>No||
||
- ||'''T042'''||'''Extended LOB data type support'''|| || || ||
+ ||'''T042'''||'''Extended LOB data type support'''||<#FFFF00>Partial||<#FFFF00>Partial||CAST
and string value functions implemented. No comparision or ordering. ||
  ||'''T051'''||'''Row types'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T052'''||'''MAX and MIN for row types'''||N/A||<#FF0000>No|| ||
  ||'''T053'''||'''Explicit aliases for all-fields reference'''||N/A||<#FF0000>No||
||
@@ -390, +390 @@

  ||'''T122'''||'''WITH (excluding RECURSIVE) in subquery'''||N/A||<#FF0000>No|| ||
  ||'''T131'''||'''Recursive query'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T132'''||'''Recursive query in subquery'''||N/A||<#FF0000>No|| ||
- ||'''T141'''||'''SIMILAR predicate'''|| || || ||
+ ||'''T141'''||'''SIMILAR predicate'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T151'''||'''DISTINCT predicate'''|| || || ||
+ ||'''T151'''||'''DISTINCT predicate'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T152'''||'''DISTINCT predicate with negation'''||N/A|| || ||
+ ||'''T152'''||'''DISTINCT predicate with negation'''||N/A||<#FF0000>No || ||
  ||'''T171'''||'''LIKE clause in table definition'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T172'''||'''AS subquery clause in table definition'''||N/A||<#FF0000>No|| ||
  ||'''T173'''||'''Extended LIKE clause in table definition'''||N/A||<#FF0000>No|| ||
@@ -446, +446 @@

  ||'''T581'''||'''Regular expression substring function'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T591'''||'''UNIQUE constraints of possibly null columns'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T601'''||'''Local cursor references'''|| || || ||
- ||'''T611'''||'''Elementary OLAP operations'''||N/A|| || ||
+ ||'''T611'''||'''Elementary OLAP operations'''||N/A||<#FF0000>No|| ||
- ||'''T612'''||'''Advanced OLAP operations'''||N/A|| || ||
+ ||'''T612'''||'''Advanced OLAP operations'''||N/A||<#FF0000>No|| ||
  ||'''T613'''||'''Sampling'''||N/A||<#FF0000>No|| ||
  ||'''T621'''||'''Enhanced numeric functions'''||N/A||<#FF0000>No|| ||
  ||'''T641'''||'''Multiple column assignment'''||N/A||<#FF0000>No|| ||

Mime
View raw message