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 Fri, 06 Jan 2006 14:10:03 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

------------------------------------------------------------------------------
  ||'''T011'''||'''Timestamp in Information Schema'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T031'''||'''BOOLEAN data type'''||<#FF0000>No||<#FF0000>No|| Due for 10.2?
[http://issues.apache.org/jira/browse/DERBY-499 Issue DERBY-499] ||
  ||'''T041'''||'''Basic LOB data type support'''||<#00FF00>Yes||<#00FF00>Yes||
||
- ||T041-01|| BLOB data type -- Subclause 5.2, "<token> and <separator>": The
<reserved word>s BINARY, BLOB, LARGE, and OBJECT -- Subclause 5.3, "<literal>":
<binary string literal> -- Subclause 6.1, "<data type>": The BINARY LARGE OBJECT
data type -- Subclause 6.28, "<string value expression>": For values of type BINARY
LARGE OBJECT -- Subclause 13.6, "Data type correspondences": Type correspondences for BINARY
LARGE OBJECT for all supported languages|| || || ||
+ ||T041-01|| BLOB data type -- Subclause 5.2, "<token> and <separator>": The
<reserved word>s BINARY, BLOB, LARGE, and OBJECT -- Subclause 5.3, "<literal>":
<binary string literal> -- Subclause 6.1, "<data type>": The BINARY LARGE OBJECT
data type -- Subclause 6.28, "<string value expression>": For values of type BINARY
LARGE OBJECT -- Subclause 13.6, "Data type correspondences": Type correspondences for BINARY
LARGE OBJECT for all supported languages||<#00FF00>Yes||<#00FF00>Yes|| ||
- ||T041-02|| CLOB data type -- Subclause 5.2, "<token> and <separator>": The
<reserved word>s CHARACTER, CLOB, LARGE, and OBJECT -- Subclause 6.1, "<data type>":
The CHARACTER LARGE OBJECT data type -- Subclause 6.28, "<string value expression>":
For values of type CHARACTER LARGE OBJECT -- Subclause 13.6, "Data type correspondences":
Type correspondences for CHARACTER LARGE OBJECT for all supported languages -- The implicit
casting among the fixed-length and variable-length character string types supported by subfeature
E021-10 is extended to support the character large object type|| || || ||
+ ||T041-02|| CLOB data type -- Subclause 5.2, "<token> and <separator>": The
<reserved word>s CHARACTER, CLOB, LARGE, and OBJECT -- Subclause 6.1, "<data type>":
The CHARACTER LARGE OBJECT data type -- Subclause 6.28, "<string value expression>":
For values of type CHARACTER LARGE OBJECT -- Subclause 13.6, "Data type correspondences":
Type correspondences for CHARACTER LARGE OBJECT for all supported languages -- The implicit
casting among the fixed-length and variable-length character string types supported by subfeature
E021-10 is extended to support the character large object type||<#00FF00>Yes||<#00FF00>Yes||
||
- ||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> || || || ||
+ ||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>Sort of||<#FFFF00>Sort of||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|| || ||
||
+ ||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>"|| || || ||
+ ||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'''|| || || ||
  ||'''T051'''||'''Row types'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T052'''||'''MAX and MIN for row types'''||N/A||<#FF0000>No|| ||

Mime
View raw message