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 2009/03/23 12:58:24 UTC

[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by KristianWaagan

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 KristianWaagan:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

------------------------------------------------------------------------------
  ||'''S281'''||'''Nested collection types'''||N/A||<#FF0000>No|| ||
  ||'''S291'''||'''Unique constraint on entire row'''||N/A||<#FF0000>No|| ||
  ||'''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] ||
+ ||'''T031'''||'''BOOLEAN data type'''||<#FF0000>No||<#FF0000>No|| Due for 10.6? [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||<#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||<#00FF00>Yes||<#00FF00>Yes|| ||