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 13:16: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

------------------------------------------------------------------------------
  ||'''F262'''||'''Extended CASE expression'''||N/A|| || ||
  ||'''F271'''||'''Compound character literals'''||<#FF0000>No||<#FF0000>No||
||
  ||'''F281'''||'''LIKE enhancements'''||<#FFFF00>Partial||<#FFFF00>Partial||
The <escape character> have to be a <value specification>||
- ||'''F291'''||'''UNIQUE predicate'''|| || || ||
+ ||'''F291'''||'''UNIQUE predicate'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''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|| ||
- ||'''F304'''||'''EXCEPT ALL table operator'''|| || || ||
+ ||'''F304'''||'''EXCEPT ALL table operator'''||<#00FF00>Yes||<#00FF00>Yes||
||
- ||'''F312'''||'''MERGE statement'''||N/A|| || ||
+ ||'''F312'''||'''MERGE statement'''||N/A||<#FF0000>No|| ||
- ||'''F321'''||'''User authorization'''|| || || ||
+ ||'''F321'''||'''User authorization'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F341'''||'''Usage tables'''|| || || ||
+ ||'''F341'''||'''Usage tables'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F361'''||'''Subprogram support'''|| || || ||
+ ||'''F361'''||'''Subprogram support'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F381'''||'''Extended schema manipulation'''||<#FFFF00>Partial||<#FFFF00>Partial||
||
  ||F381-01||ALTER TABLE statement: ALTER COLUMN clause||<#FFFF00>Partial||<#FFFF00>Partial||
||
  ||F381-02||ALTER TABLE statement: ADD CONSTRAINT clause||<#FFFF00>Partial||<#FFFF00>Partial||
||
@@ -262, +262 @@

  ||F401-01||NATURAL JOIN||<#FF0000>No||<#FF0000>No|| ||
  ||F401-02||FULL OUTER JOIN||<#FF0000>No||<#FF0000>No|| ||
  ||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|| || ||
+ ||'''F402'''||'''Named column joins for LOBs, arrays, and multisets'''||N/A||<#00FF00>Yes||
||
  ||'''F411'''||'''Time zone specification'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''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-01||FETCH with explicit NEXT||<#FF0000>No||<#FF0000>No|| ||
- ||F431-02||FETCH FIRST|| || || ||
- ||F431-03||FETCH LAST|| || || ||
- ||F431-04||FETCH PRIOR|| || || ||
- ||F431-05||FETCH ABSOLUTE|| || || ||
- ||F431-06||FETCH RELATIVE|| || || ||
+ ||F431-02||FETCH FIRST||<#FF0000>No||<#FF0000>No|| ||
+ ||F431-03||FETCH LAST||<#FF0000>No||<#FF0000>No|| ||
+ ||F431-04||FETCH PRIOR||<#FF0000>No||<#FF0000>No|| ||
+ ||F431-05||FETCH ABSOLUTE||<#FF0000>No||<#FF0000>No|| ||
+ ||F431-06||FETCH RELATIVE||<#FF0000>No||<#FF0000>No|| ||
- ||'''F441'''||'''Extended set function support'''|| || || ||
+ ||'''F441'''||'''Extended set function support'''||<#FF0000>No||<#FF0000>No||
||
- ||'''F442'''||'''Mixed column references in set functions'''||N/A|| || ||
+ ||'''F442'''||'''Mixed column references in set functions'''||N/A||<#FF0000>No|| ||
  ||'''F451'''||'''Character set definition'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F461'''||'''Named character sets'''|| || || ||
+ ||'''F461'''||'''Named character sets'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F491'''||'''Constraint management'''||<#00FF00>Yes||<#00FF00>Yes|| ||
- ||'''F502'''||'''Enhanced documentation tables'''|| || || ||
+ ||'''F502'''||'''Enhanced documentation tables'''||<#FF0000>No||<#FF0000>No||
||
- ||F502-01||SQL_SIZING_PROFILES view|| || || ||
+ ||F502-01||SQL_SIZING_PROFILES view||<#FF0000>No||<#FF0000>No|| ||
- ||F502-02||SQL_IMPLEMENTATION_INFO view|| || || ||
+ ||F502-02||SQL_IMPLEMENTATION_INFO view||<#FF0000>No||<#FF0000>No|| ||
- ||F502-03||SQL_PACKAGES view|| || || ||
- ||'''F521'''||'''Assertions'''|| || || ||
+ ||F502-03||SQL_PACKAGES view||<#FF0000>No||<#FF0000>No|| ||
+ ||'''F521'''||'''Assertions'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F531'''||'''Temporary tables'''||<#FFFF00>Partial||<#FFFF00>Partial|| Global
tables ||
  ||'''F555'''||'''Enhanced seconds precision'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F561'''||'''Full value expressions'''|| || || ||
  ||'''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'''|| || || ||
+ ||'''F611'''||'''Indicator data types'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F641'''||'''Row and table constructors'''||<#00FF00>Yes||<#00FF00>Yes||
||
- ||'''F651'''||'''Catalog name qualifiers'''|| || || ||
+ ||'''F651'''||'''Catalog name qualifiers'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F661'''||'''Simple tables'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F671'''||'''Subqueries in CHECK'''|| || || ||
  ||'''F672'''||'''Retrospective check constraints'''||N/A|| || ||
  ||'''F691'''||'''Collation and translation'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F692'''||'''Enhanced collation support'''||N/A|| || ||
+ ||'''F692'''||'''Enhanced collation support'''||N/A||<#FF0000>No|| ||
- ||'''F693'''||'''SQL-session and client module collations'''||N/A|| || ||
+ ||'''F693'''||'''SQL-session and client module collations'''||N/A||<#FF0000>No|| ||
- ||'''F695'''||'''Translation support'''||N/A|| || ||
+ ||'''F695'''||'''Translation support'''||N/A||<#FF0000>No|| ||
- ||'''F696'''||'''Additional translation documentation'''||N/A|| || ||
+ ||'''F696'''||'''Additional translation documentation'''||N/A||<#FF0000>No|| ||
  ||'''F701'''||'''Referential update actions'''||<#FFFF00>Partial||<#FFFF00>Partial||
||
- ||'''F711'''||'''ALTER domain'''|| || || ||
+ ||'''F711'''||'''ALTER domain'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F721'''||'''Deferrable constraints'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F731'''||'''INSERT column privileges'''|| || || ||
+ ||'''F731'''||'''INSERT column privileges'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F741'''||'''Referential MATCH types'''|| || || ||
+ ||'''F741'''||'''Referential MATCH types'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F751'''||'''View CHECK enhancements'''|| || || ||
  ||'''F761'''||'''Session management'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''F771'''||'''Connection management'''|| || || ||
+ ||'''F771'''||'''Connection management'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F781'''||'''Self-referencing operations'''|| || || ||
  ||'''F791'''||'''Insensitive cursors'''||<#FFFF00>Sort of||<#FFFF00>Sort of||Through
JDBC||
  ||'''F801'''||'''Full set function '''|| || || ||
- ||'''F811'''||'''Extended flagging'''|| ||N/A|| ||
+ ||'''F811'''||'''Extended flagging'''||<#FF0000>No||N/A|| ||
- ||'''F813'''||'''Extended flagging -- Part 1, Subclause 8.5, "SQL flagger": With "level
of flagging" specified to be Core SQL Flagging and "extent of checking" specified to be Catalog
Lookup'''|| || || ||
+ ||'''F813'''||'''Extended flagging -- Part 1, Subclause 8.5, "SQL flagger": With "level
of flagging" specified to be Core SQL Flagging and "extent of checking" specified to be Catalog
Lookup'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''F821'''||'''Local table references'''|| || || ||
- ||'''F831'''||'''Full cursor update'''|| || || ||
+ ||'''F831'''||'''Full cursor update'''||<#FFFF00>Partial||<#FFFF00>Partial||Update
and delete of forward only cursors. See issues [http://issues.apache.org/jira/browse/DERBY-98
98]  [http://issues.apache.org/jira/browse/DERBY-99 99] [http://issues.apache.org/jira/browse/DERBY-100
100] ||
- ||F831-01||Updateable scrollable cursors|| || || ||
+ ||F831-01||Updateable scrollable cursors||<#FF0000>No||<#FF0000>No||||
- ||F831-02||Updateable ordered cursors|| || || ||
+ ||F831-02||Updateable ordered cursors||<#FF0000>No||<#FF0000>No|| ||
- ||'''S023'''||'''Basic structured types'''|| || || ||
+ ||'''S023'''||'''Basic structured types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S024'''||'''Enhanced structured types'''|| || || ||
+ ||'''S024'''||'''Enhanced structured types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S025'''||'''Final structured types'''||N/A|| || ||
+ ||'''S025'''||'''Final structured types'''||N/A||<#FF0000>No|| ||
- ||'''S026'''||'''Self-referencing structured types'''||N/A|| || ||
+ ||'''S026'''||'''Self-referencing structured types'''||N/A||<#FF0000>No|| ||
- ||'''S027'''||'''Create method by specific method name'''||N/A|| || ||
+ ||'''S027'''||'''Create method by specific method name'''||N/A||<#FF0000>No|| ||
- ||'''S028'''||'''Permutable UDT options list'''||N/A|| || ||
+ ||'''S028'''||'''Permutable UDT options list'''||N/A||<#FF0000>No|| ||
- ||'''S041'''||'''Basic reference types'''|| || || ||
+ ||'''S041'''||'''Basic reference types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S043'''||'''Enhanced reference types'''|| || || ||
+ ||'''S043'''||'''Enhanced reference types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S051'''||'''Create table of type'''|| || || ||
+ ||'''S051'''||'''Create table of type'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S071'''||'''SQL paths in function and type name resolution'''|| || || ||
+ ||'''S071'''||'''SQL paths in function and type name resolution'''||<#FF0000>No||<#FF0000>No||
||
- ||'''S081'''||'''Subtables'''|| || || ||
+ ||'''S081'''||'''Subtables'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S091'''||'''Basic array support'''|| || || ||
+ ||'''S091'''||'''Basic array support'''||<#FF0000>No||<#FF0000>No|| ||
- ||S091-01||Arrays of built-in data types|| || || ||
+ ||S091-01||Arrays of built-in data types||<#FF0000>No||<#FF0000>No|| ||
- ||S091-02||Arrays of distinct types|| || || ||
+ ||S091-02||Arrays of distinct types||<#FF0000>No||<#FF0000>No|| ||
- ||S091-03||Array expressions|| || || ||
+ ||S091-03||Array expressions||<#FF0000>No||<#FF0000>No|| ||
- ||'''S092'''||'''Arrays of user-defined types'''|| || || ||
+ ||'''S092'''||'''Arrays of user-defined types'''||<#FF0000>No||<#FF0000>No||
||
- ||'''S094'''||'''Arrays of reference types'''|| || || ||
+ ||'''S094'''||'''Arrays of reference types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S095'''||'''Array constructors by query'''||N/A|| || ||
+ ||'''S095'''||'''Array constructors by query'''||N/A||<#FF0000>No|| ||
- ||'''S096'''||'''Optional array bounds'''||N/A|| || ||
+ ||'''S096'''||'''Optional array bounds'''||N/A||<#FF0000>No|| ||
- ||'''S097'''||'''Array element assignment'''||N/A|| || ||
+ ||'''S097'''||'''Array element assignment'''||N/A||<#FF0000>No|| ||
- ||'''S111'''||'''ONLY in query expressions'''|| || || ||
+ ||'''S111'''||'''ONLY in query expressions'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S151'''||'''Type predicate'''|| || || ||
+ ||'''S151'''||'''Type predicate'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S161'''||'''Subtype treatment'''|| || || ||
+ ||'''S161'''||'''Subtype treatment'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S162'''||'''Subtype treatment for references'''||N/A|| || ||
+ ||'''S162'''||'''Subtype treatment for references'''||N/A||<#FF0000>No|| ||
- ||'''S201'''||'''SQL-invoked routines on arrays'''|| || || ||
+ ||'''S201'''||'''SQL-invoked routines on arrays'''||<#FF0000>No||<#FF0000>No||
||
- ||S201-01||Array parameters|| || || ||
+ ||S201-01||Array parameters||<#FF0000>No||<#FF0000>No|| ||
- ||S201-02||Array as result type of functions|| || || ||
+ ||S201-02||Array as result type of functions||<#FF0000>No||<#FF0000>No|| ||
- ||'''S202'''||'''SQL-invoked routines on multisets'''||N/A|| || ||
+ ||'''S202'''||'''SQL-invoked routines on multisets'''||N/A||<#FF0000>No|| ||
- ||'''S211'''||'''User-defined cast functions'''|| || || ||
+ ||'''S211'''||'''User-defined cast functions'''||<#FF0000>No||<#FF0000>No||
||
- ||'''S231'''||'''Structured type locators'''|| || || ||
+ ||'''S231'''||'''Structured type locators'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S232'''||'''Array locators'''|| || || ||
+ ||'''S232'''||'''Array locators'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S233'''||'''Multiset locators'''||N/A|| || ||
+ ||'''S233'''||'''Multiset locators'''||N/A||<#FF0000>No|| ||
- ||'''S241'''||'''Transform functions'''|| || || ||
+ ||'''S241'''||'''Transform functions'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S242'''||'''Alter transform statement'''||N/A|| || ||
+ ||'''S242'''||'''Alter transform statement'''||N/A||<#FF0000>No|| ||
- ||'''S251'''||'''User-defined orderings'''|| || || ||
+ ||'''S251'''||'''User-defined orderings'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S261'''||'''Specific type method'''|| || || ||
+ ||'''S261'''||'''Specific type method'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''S271'''||'''Basic multiset support'''||N/A|| || ||
+ ||'''S271'''||'''Basic multiset support'''||N/A||<#FF0000>No|| ||
- ||'''S272'''||'''Multisets of user-defined types'''||N/A|| || ||
+ ||'''S272'''||'''Multisets of user-defined types'''||N/A||<#FF0000>No|| ||
- ||'''S274'''||'''Multisets of reference types'''||N/A|| || ||
+ ||'''S274'''||'''Multisets of reference types'''||N/A||<#FF0000>No|| ||
- ||'''S275'''||'''Advanced multiset support'''||N/A|| || ||
+ ||'''S275'''||'''Advanced multiset support'''||N/A||<#FF0000>No|| ||
- ||'''S281'''||'''Nested collection types'''||N/A|| || ||
+ ||'''S281'''||'''Nested collection types'''||N/A||<#FF0000>No|| ||
- ||'''S291'''||'''Unique constraint on entire row'''||N/A|| || ||
+ ||'''S291'''||'''Unique constraint on entire row'''||N/A||<#FF0000>No|| ||
- ||'''T011'''||'''Timestamp in Information Schema'''|| || || ||
+ ||'''T011'''||'''Timestamp in Information Schema'''||<#FF0000>No||<#FF0000>No||
||
- ||'''T031'''||'''BOOLEAN data type'''|| || || ||
+ ||'''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-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|| || || ||
@@ -366, +366 @@

  ||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-05|| LOB locator: non-holdable -- Subclause 13.3, "<externally-invoked procedure>":
<locator indication> -- Subclause 14.14, "<free locator statement>"|| || || ||
  ||'''T042'''||'''Extended LOB data type support'''|| || || ||
- ||'''T051'''||'''Row types'''|| || || ||
+ ||'''T051'''||'''Row types'''||<#FF0000>No||<#FF0000>No|| ||
- ||'''T052'''||'''MAX and MIN for row types'''||N/A|| || ||
+ ||'''T052'''||'''MAX and MIN for row types'''||N/A||<#FF0000>No|| ||
- ||'''T053'''||'''Explicit aliases for all-fields reference'''||N/A|| || ||
+ ||'''T053'''||'''Explicit aliases for all-fields reference'''||N/A||<#FF0000>No||
||
- ||'''T061'''||'''UCS support'''||N/A|| || ||
+ ||'''T061'''||'''UCS support'''||N/A||<#FF0000>No|| ||
- ||'''T071'''||'''BIGINT data type'''||N/A|| || ||
+ ||'''T071'''||'''BIGINT data type'''||N/A||<#00FF00>Yes|| ||
  ||'''T111'''||'''Updatable joins, unions, and columns'''|| || || ||
  ||'''T121'''||'''WITH (excluding RECURSIVE) in query expression'''|| || || ||
  ||'''T122'''||'''WITH (excluding RECURSIVE) in subquery'''||N/A|| || ||

Mime
View raw message