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 10:49:17 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

------------------------------------------------------------------------------
  ||'''F261'''||'''CASE expression'''||<#FFFF00>Sort of||<#FFFF00>Sort of||  
||
  ||F261-01||Simple CASE||<#FF0000>No||<#FF0000>No||   ||
  ||F261-02||Searched CASE||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||F261-03||NULLIF function||<#FFFF00>Sort of||<#FFFF00>Sort of||Works only for
CHAR types. See also [http://issues.apache.org/jira/browse/DERBY-7 issue DERBY-7] ||
+ ||F261-03||NULLIF function||<#FFFF00>Partial||<#FFFF00>Partial||Works only for
CHAR types. See also [http://issues.apache.org/jira/browse/DERBY-7 issue DERBY-7] ||
  ||F261-04||COALESCE function||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||'''F311'''||'''Schema definition statement'''||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||F311-01||Create schema||<#00FF00>Yes||<#00FF00>Yes||   ||
@@ -239, +239 @@

  ||F231-03||USAGE_PRIVILEGES view||<#FF0000>No||<#FF0000>No|| ||
  ||'''F251'''||'''Domain support'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F262'''||'''Extended CASE expression'''||N/A|| || ||
- ||'''F271'''||'''Compound character literals'''|| || || ||
+ ||'''F271'''||'''Compound character literals'''||<#FF0000>No||<#FF0000>No||
||
  ||'''F281'''||'''LIKE enhancements'''|| || || ||
  ||'''F291'''||'''UNIQUE predicate'''|| || || ||
- ||'''F301'''||'''CORRESPONDING in query expressions'''|| || || ||
+ ||'''F301'''||'''CORRESPONDING in query expressions'''||<#FF0000>No||<#FF0000>No||
||
  ||'''F302'''||'''INTERSECT table operator'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||F302-01||INTERSECT DISTINCT table operator||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||F302-02||INTERSECT ALL table operator||<#00FF00>Yes||<#00FF00>Yes|| ||
@@ -251, +251 @@

  ||'''F321'''||'''User authorization'''|| || || ||
  ||'''F341'''||'''Usage tables'''|| || || ||
  ||'''F361'''||'''Subprogram support'''|| || || ||
- ||'''F381'''||'''Extended schema manipulation'''|| || || ||
+ ||'''F381'''||'''Extended schema manipulation'''||<#FFFF00>Partial||<#FFFF00>Partial||
||
- ||F381-01||ALTER TABLE statement: ALTER COLUMN clause|| || || ||
+ ||F381-01||ALTER TABLE statement: ALTER COLUMN clause||<#FFFF00>Partial||<#FFFF00>Partial||
||
- ||F381-02||ALTER TABLE statement: ADD CONSTRAINT clause|| || || ||
+ ||F381-02||ALTER TABLE statement: ADD CONSTRAINT clause||<#FFFF00>Partial||<#FFFF00>Partial||
||
- ||F381-03||ALTER TABLE statement: DROP CONSTRAINT clause|| || || ||
+ ||F381-03||ALTER TABLE statement: DROP CONSTRAINT clause||<#00FF00>Yes||<#00FF00>Yes||
||
- ||'''F391'''||'''Long identifiers'''|| || || ||
+ ||'''F391'''||'''Long identifiers'''||<#00FF00>Yes||<#00FF00>Yes|| ||
- ||'''F392'''||'''Unicode escapes in identifiers'''||N/A|| || ||
+ ||'''F392'''||'''Unicode escapes in identifiers'''||N/A||<#FF0000>No|| ||
- ||'''F393'''||'''Unicode escapes in literals'''||N/A|| || ||
+ ||'''F393'''||'''Unicode escapes in literals'''||N/A||<#FF0000>No|| ||
- ||'''F401'''||'''Extended joined table'''|| || || ||
+ ||'''F401'''||'''Extended joined table'''||<#FF0000>No||<#FF0000>No|| ||
- ||F401-01||NATURAL JOIN|| || || ||
- ||F401-02||FULL OUTER JOIN|| || || ||
+ ||F401-01||NATURAL JOIN||<#FF0000>No||<#FF0000>No|| ||
+ ||F401-02||FULL OUTER JOIN||<#FF0000>No||<#FF0000>No|| ||
  ||F401-04||CROSS JOIN|| || || ||
  ||'''F402'''||'''Named column joins for LOBs, arrays, and multisets'''||N/A|| || ||
- ||'''F411'''||'''Time zone specification'''|| || || ||
+ ||'''F411'''||'''Time zone specification'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F421'''||'''National character'''|| || || ||
+ ||'''F421'''||'''National character'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F431'''||'''Read-only scrollable cursors'''||<#FFFF00>Sort of||<#FFFF00>Sort
of||Through JDBC. Only insensitive cursors.||
  ||F431-01||FETCH with explicit NEXT|| || || ||
  ||F431-02||FETCH FIRST|| || || ||
@@ -274, +274 @@

  ||F431-06||FETCH RELATIVE|| || || ||
  ||'''F441'''||'''Extended set function support'''|| || || ||
  ||'''F442'''||'''Mixed column references in set functions'''||N/A|| || ||
- ||'''F451'''||'''Character set definition'''|| || || ||
+ ||'''F451'''||'''Character set definition'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F461'''||'''Named character sets'''|| || || ||
- ||'''F491'''||'''Constraint management'''|| || || ||
+ ||'''F491'''||'''Constraint management'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''F502'''||'''Enhanced documentation tables'''|| || || ||
  ||F502-01||SQL_SIZING_PROFILES view|| || || ||
  ||F502-02||SQL_IMPLEMENTATION_INFO view|| || || ||
  ||F502-03||SQL_PACKAGES view|| || || ||
  ||'''F521'''||'''Assertions'''|| || || ||
- ||'''F531'''||'''Temporary tables'''|| || || ||
+ ||'''F531'''||'''Temporary tables'''||<#FFFF00>Partial||<#FFFF00>Partial|| Global
tables ||
- ||'''F555'''||'''Enhanced seconds precision'''|| || || ||
+ ||'''F555'''||'''Enhanced seconds precision'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F561'''||'''Full value expressions'''|| || || ||
- ||'''F571'''||'''Truth value tests'''|| || || ||
- ||'''F591'''||'''Derived tables'''|| || || ||
+ ||'''F571'''||'''Truth value tests'''||<#FF0000>No||<#FF0000>No|| Due for 10.2?
[http://issues.apache.org/jira/browse/DERBY-499 Issue DERBY-499]||
+ ||'''F591'''||'''Derived tables'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''F611'''||'''Indicator data types'''|| || || ||
- ||'''F641'''||'''Row and table constructors'''|| || || ||
+ ||'''F641'''||'''Row and table constructors'''||<#00FF00>Yes||<#00FF00>Yes||
||
  ||'''F651'''||'''Catalog name qualifiers'''|| || || ||
- ||'''F661'''||'''Simple tables'''|| || || ||
+ ||'''F661'''||'''Simple tables'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F671'''||'''Subqueries in CHECK'''|| || || ||
  ||'''F672'''||'''Retrospective check constraints'''||N/A|| || ||
- ||'''F691'''||'''Collation and translation'''|| || || ||
+ ||'''F691'''||'''Collation and translation'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F692'''||'''Enhanced collation support'''||N/A|| || ||
  ||'''F693'''||'''SQL-session and client module collations'''||N/A|| || ||
  ||'''F695'''||'''Translation support'''||N/A|| || ||
  ||'''F696'''||'''Additional translation documentation'''||N/A|| || ||
- ||'''F701'''||'''Referential update actions'''|| || || ||
+ ||'''F701'''||'''Referential update actions'''||<#FFFF00>Partial||<#FFFF00>Partial||
||
  ||'''F711'''||'''ALTER domain'''|| || || ||
- ||'''F721'''||'''Deferrable constraints'''|| || || ||
+ ||'''F721'''||'''Deferrable constraints'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F731'''||'''INSERT column privileges'''|| || || ||
  ||'''F741'''||'''Referential MATCH types'''|| || || ||
  ||'''F751'''||'''View CHECK enhancements'''|| || || ||
- ||'''F761'''||'''Session management'''|| || || ||
+ ||'''F761'''||'''Session management'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F771'''||'''Connection management'''|| || || ||
  ||'''F781'''||'''Self-referencing operations'''|| || || ||
  ||'''F791'''||'''Insensitive cursors'''||<#FFFF00>Sort of||<#FFFF00>Sort of||Through
JDBC||
@@ -359, +359 @@

  ||'''S291'''||'''Unique constraint on entire row'''||N/A|| || ||
  ||'''T011'''||'''Timestamp in Information Schema'''|| || || ||
  ||'''T031'''||'''BOOLEAN data type'''|| || || ||
- ||'''T041'''||'''Basic LOB data type support'''|| || || ||
+ ||'''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-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-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> || || || ||
@@ -398, +398 @@

  ||T211-08||Multiple triggers for the same event are executed in the order in which they
were created in the catalog.|| || || ||
  ||'''T212'''||'''Enhanced trigger capability'''|| || || ||
  ||'''T231'''||'''Sensitive cursors'''|| || || ||
- ||'''T241'''||'''START TRANSACTION statement'''|| || || ||
+ ||'''T241'''||'''START TRANSACTION statement'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T251'''||'''SET TRANSACTION statement: LOCAL option'''|| || || ||
  ||'''T261'''||'''Chained transactions'''|| || || ||
- ||'''T271'''||'''Savepoints'''|| || || ||
+ ||'''T271'''||'''Savepoints'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''T272'''||'''Enhanced savepoint management'''||N/A|| || ||
  ||'''T281'''||'''SELECT privilege with column granularity'''|| || || ||
  ||'''T301'''||'''Functional dependencies'''|| || || ||
@@ -411, +411 @@

  ||'''T324'''||'''Explicit security for SQL routines'''||N/A|| || ||
  ||'''T325'''||'''Qualified SQL parameter references'''||N/A|| || ||
  ||'''T326'''||'''Table functions'''||N/A|| || ||
- ||'''T331'''||'''Basic roles'''|| || || ||
- ||'''T332'''||'''Extended roles'''|| || || ||
+ ||'''T331'''||'''Basic roles'''||<#FF0000>No||<#FF0000>No|| ||
+ ||'''T332'''||'''Extended roles'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T351'''||'''Bracketed SQL comments (/*...*/ comments)'''|| || || ||
  ||'''T431'''||'''Extended grouping capabilities'''|| || || ||
  ||'''T432'''||'''Nested and concatenated GROUPING SETS'''||N/A|| || ||
  ||'''T433'''||'''Multiargument GROUPING function'''||N/A|| || ||
  ||'''T434'''||'''GROUP BY DISINCT'''||N/A|| || ||
- ||'''T441'''||'''ABS and MOD functions'''|| || || ||
+ ||'''T441'''||'''ABS and MOD functions'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''T461'''||'''Symmetric BETWEEN predicate'''|| || || ||
  ||'''T471'''||'''Result sets return value'''|| || || ||
  ||'''T491'''||'''LATERAL derived table'''|| || || ||
@@ -430, +430 @@

  ||'''T571'''||'''Array-returning external SQL-invoked functions'''|| || || ||
  ||'''T572'''||'''Multiset-returning external SQL-invoked functions'''||N/A|| || ||
  ||'''T581'''||'''Regular expression substring function'''|| || || ||
- ||'''T591'''||'''UNIQUE constraints of possibly null columns'''|| || || ||
+ ||'''T591'''||'''UNIQUE constraints of possibly null columns'''||<#FF0000>No||<#FF0000>No||
||
  ||'''T601'''||'''Local cursor references'''|| || || ||
  ||'''T611'''||'''Elementary OLAP operations'''||N/A|| || ||
  ||'''T612'''||'''Advanced OLAP operations'''||N/A|| || ||
@@ -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