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 2005/11/07 15:20:49 UTC
[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by BerntJohnsen
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
------------------------------------------------------------------------------
||T321-07||PARAMETERS view||<#FF0000>No||N/A|| ||
||'''T632'''||'''IN predicate with one list element'''||N/A||<#00FF00>Yes|| ||
+ ||'''Feature ID'''||'''Feature name'''||'''SQL-99 Outside Core'''||'''SQL-2003 Optional'''||'''Note''' ||
+ ||B011||Embedded Ada||N/A||<#FF0000>No|| ||
+ ||B012||Embedded C||N/A||<#FF0000>No|| ||
+ ||B013||Embedded COBOL||N/A||<#FF0000>No|| ||
+ ||B014||Embedded Fortran||N/A||<#FF0000>No|| ||
+ ||B015||Embedded MUMPS||N/A||<#FF0000>No|| ||
+ ||B016||Embedded Pascal||N/A||<#FF0000>No|| ||
+ ||B017||Embedded PL/I||N/A||<#FF0000>No|| ||
+ ||B021||Direct SQL||N/A||<#FF0000>No|| ||
+ ||B031||Basic dynamic SQL||N/A||<#FF0000>No|| ||
+ ||B032||Extended dynamic SQL||N/A||<#FF0000>No|| ||
+ ||B032-01||<describe input statement>||N/A||<#FF0000>No|| ||
+ ||B033||Untyped SQL-invoked function arguments||N/A||<#FF0000>No|| ||
+ ||B034||Dynamic specification of cursor attributes||N/A||<#FF0000>No|| ||
+ ||B041||Extensions to embedded SQL exception declarations||N/A||<#FF0000>No|| ||
+ ||B051||Enhanced execution rights||N/A||<#FF0000>No|| ||
+ ||B111||Module language Ada||N/A||<#FF0000>No|| ||
+ ||B112||Module language C||N/A||<#FF0000>No|| ||
+ ||B113||Module language COBOL||N/A||<#FF0000>No|| ||
+ ||B114||Module language Fortran||N/A||<#FF0000>No|| ||
+ ||B115||Module language MUMPS||N/A||<#FF0000>No|| ||
+ ||B116||Module language Pascal||N/A||<#FF0000>No|| ||
+ ||B117||Module language PL/I||N/A||<#FF0000>No|| ||
+ ||B121||Routine language Ada||N/A||<#FF0000>No|| ||
+ ||B122||Routine language C||N/A||<#FF0000>No|| ||
+ ||B123||Routine language COBOL||N/A||<#FF0000>No|| ||
+ ||B124||Routine language Fortran||N/A||<#FF0000>No|| ||
+ ||B125||Routine language MUMPS||N/A||<#FF0000>No|| ||
+ ||B126||Routine language Pascal||N/A||<#FF0000>No|| ||
+ ||B127||Routine language PL/I||N/A||<#FF0000>No|| ||
+ ||B128||Routine language SQL||N/A||<#FF0000>No|| ||
+ ||F032||CASCADE drop behavior|| || || ||
+ ||F033||ALTER TABLE statement: DROP COLUMN clause|| || || ||
+ ||F034||Extended REVOKE statement|| || || ||
+ ||F034-01||REVOKE statement performed by other than the owner of a schema object|| || || ||
+ ||F034-02||REVOKE statement: GRANT OPTION FOR clause || || || ||
+ ||F034-03||REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION|| || || ||
+ ||F052||Intervals and datetime arithmetic|| || || ||
+ ||F053||OVERLAPS predicate||N/A|| || ||
+ ||F111||Isolation levels other than SERIALIZABLE||<#00FF00>Yes||<#00FF00>Yes|| ||
+ ||F111-01||READ UNCOMMITTED isolation level||<#00FF00>Yes||<#00FF00>Yes|| ||
+ ||F111-02||READ COMMITTED isolation level||<#00FF00>Yes||<#00FF00>Yes|| ||
+ ||F111-03||REPEATABLE READ isolation level||<#00FF00>Yes||<#00FF00>Yes|| ||
+ ||F121||Basic diagnostics management|| || || ||
+ ||F121-01||GET DIAGNOSTICS statement|| || || ||
+ ||F121-02||SET TRANSACTION statement: DIAGNOSTICS SIZE clause|| || || ||
+ ||F171||Multiple schemas per user|| || || ||
+ ||F191||Referential delete actions|| || || ||
+ ||F222||INSERT statement: DEFAULT VALUES clause|| || || ||
+ ||F231||Privilege tables|| || || ||
+ ||F231-01||TABLE_PRIVILEGES view|| || || ||
+ ||F231-02||COLUMN_PRIVILEGES view|| || || ||
+ ||F231-03||USAGE_PRIVILEGES view|| || || ||
+ ||F251||Domain support|| || || ||
+ ||F262||Extended CASE expression||N/A|| || ||
+ ||F271||Compound character literals|| || || ||
+ ||F281||LIKE enhancements|| || || ||
+ ||F291||UNIQUE predicate|| || || ||
+ ||F301||CORRESPONDING in query expressions|| || || ||
+ ||F302||INTERSECT table operator|| || || ||
+ ||F302-01||INTERSECT DISTINCT table operator|| || || ||
+ ||F302-02||INTERSECT ALL table operator|| || || ||
+ ||F304||EXCEPT ALL table operator|| || || ||
+ ||F312||MERGE statement||N/A|| || ||
+ ||F321||User authorization|| || || ||
+ ||F341||Usage tables|| || || ||
+ ||F361||Subprogram support|| || || ||
+ ||F381||Extended schema manipulation|| || || ||
+ ||F381-01||ALTER TABLE statement: ALTER COLUMN clause|| || || ||
+ ||F381-02||ALTER TABLE statement: ADD CONSTRAINT clause|| || || ||
+ ||F381-03||ALTER TABLE statement: DROP CONSTRAINT clause|| || || ||
+ ||F391||Long identifiers|| || || ||
+ ||F392||Unicode escapes in identifiers||N/A|| || ||
+ ||F393||Unicode escapes in literals||N/A|| || ||
+ ||F401||Extended joined table|| || || ||
+ ||F401-01||NATURAL JOIN|| || || ||
+ ||F401-02||FULL OUTER JOIN|| || || ||
+ ||F401-04||CROSS JOIN|| || || ||
+ ||F402||Named column joins for LOBs, arrays, and multisets||N/A|| || ||
+ ||F411||Time zone specification|| || || ||
+ ||F421||National character|| || || ||
+ ||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|| || || ||
+ ||F431-03||FETCH LAST|| || || ||
+ ||F431-04||FETCH PRIOR|| || || ||
+ ||F431-05||FETCH ABSOLUTE|| || || ||
+ ||F431-06||FETCH RELATIVE|| || || ||
+ ||F441||Extended set function support|| || || ||
+ ||F442||Mixed column references in set functions||N/A|| || ||
+ ||F451||Character set definition|| || || ||
+ ||F461||Named character sets|| || || ||
+ ||F491||Constraint management|| || || ||
+ ||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|| || || ||
+ ||F555||Enhanced seconds precision|| || || ||
+ ||F561||Full value expressions|| || || ||
+ ||F571||Truth value tests|| || || ||
+ ||F591||Derived tables|| || || ||
+ ||F611||Indicator data types|| || || ||
+ ||F641||Row and table constructors|| || || ||
+ ||F651||Catalog name qualifiers|| || || ||
+ ||F661||Simple tables|| || || ||
+ ||F671||Subqueries in CHECK|| || || ||
+ ||F672||Retrospective check constraints||N/A|| || ||
+ ||F691||Collation and translation|| || || ||
+ ||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|| || || ||
+ ||F711||ALTER domain|| || || ||
+ ||F721||Deferrable constraints|| || || ||
+ ||F731||INSERT column privileges|| || || ||
+ ||F741||Referential MATCH types|| || || ||
+ ||F751||View CHECK enhancements|| || || ||
+ ||F761||Session management|| || || ||
+ ||F771||Connection management|| || || ||
+ ||F781||Self-referencing operations|| || || ||
+ ||F791||Insensitive cursors||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC||
+ ||F801||Full set function || || || ||
+ ||F811||Extended flagging|| ||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|| || || ||
+ ||F821||Local table references|| || || ||
+ ||F831||Full cursor update|| || || ||
+ ||F831-01||Updateable scrollable cursors|| || || ||
+ ||F831-02||Updateable ordered cursors|| || || ||
+ ||S023||Basic structured types|| || || ||
+ ||S024||Enhanced structured types|| || || ||
+ ||S025||Final structured types||N/A|| || ||
+ ||S026||Self-referencing structured types||N/A|| || ||
+ ||S027||Create method by specific method name||N/A|| || ||
+ ||S028||Permutable UDT options list||N/A|| || ||
+ ||S041||Basic reference types|| || || ||
+ ||S043||Enhanced reference types|| || || ||
+ ||S051||Create table of type|| || || ||
+ ||S071||SQL paths in function and type name resolution|| || || ||
+ ||S081||Subtables|| || || ||
+ ||S091||Basic array support|| || || ||
+ ||S091-01||Arrays of built-in data types|| || || ||
+ ||S091-02||Arrays of distinct types|| || || ||
+ ||S091-03||Array expressions|| || || ||
+ ||S092||Arrays of user-defined types|| || || ||
+ ||S094||Arrays of reference types|| || || ||
+ ||S095||Array constructors by query||N/A|| || ||
+ ||S096||Optional array bounds||N/A|| || ||
+ ||S097||Array element assignment||N/A|| || ||
+ ||S111||ONLY in query expressions|| || || ||
+ ||S151||Type predicate|| || || ||
+ ||S161||Subtype treatment|| || || ||
+ ||S162||Subtype treatment for references||N/A|| || ||
+ ||S201||SQL-invoked routines on arrays|| || || ||
+ ||S201-01||Array parameters|| || || ||
+ ||S201-02||Array as result type of functions|| || || ||
+ ||S202||SQL-invoked routines on multisets||N/A|| || ||
+ ||S211||User-defined cast functions|| || || ||
+ ||S231||Structured type locators|| || || ||
+ ||S232||Array locators|| || || ||
+ ||S233||Multiset locators||N/A|| || ||
+ ||S241||Transform functions|| || || ||
+ ||S242||Alter transform statement||N/A|| || ||
+ ||S251||User-defined orderings|| || || ||
+ ||S261||Specific type method|| || || ||
+ ||S271||Basic multiset support||N/A|| || ||
+ ||S272||Multisets of user-defined types||N/A|| || ||
+ ||S274||Multisets of reference types||N/A|| || ||
+ ||S275||Advanced multiset support||N/A|| || ||
+ ||S281||Nested collection types||N/A|| || ||
+ ||S291||Unique constraint on entire row||N/A|| || ||
+ ||T011||Timestamp in Information Schema|| || || ||
+ ||T031||BOOLEAN data type|| || || ||
+ ||T041||Basic LOB data type support|| || || ||
+ ||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> || || || ||
+ ||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|| || || ||
+ ||T052||MAX and MIN for row types||N/A|| || ||
+ ||T053||Explicit aliases for all-fields reference||N/A|| || ||
+ ||T061||UCS support||N/A|| || ||
+ ||T071||BIGINT data type||N/A|| || ||
+ ||T111||Updatable joins, unions, and columns|| || || ||
+ ||T121||WITH (excluding RECURSIVE) in query expression|| || || ||
+ ||T122||WITH (excluding RECURSIVE) in subquery||N/A|| || ||
+ ||T131||Recursive query|| || || ||
+ ||T132||Recursive query in subquery||N/A|| || ||
+ ||T141||SIMILAR predicate|| || || ||
+ ||T151||DISTINCT predicate|| || || ||
+ ||T152||DISTINCT predicate with negation||N/A|| || ||
+ ||T171||LIKE clause in table definition|| || || ||
+ ||T172||AS subquery clause in table definition||N/A|| || ||
+ ||T173||Extended LIKE clause in table definition||N/A|| || ||
+ ||T174||Identity columns||N/A|| || ||
+ ||T175||Generated columns||N/A|| || ||
+ ||T176||Sequence generator support||N/A|| || ||
+ ||T191||Referential action RESTRICT|| || || ||
+ ||T201||Comparable data types for referential constraints|| || || ||
+ ||T211||Basic trigger capability|| || || ||
+ ||T211-01||Triggers activated on UPDATE, INSERT, or DELETE of one base table.|| || || ||
+ ||T211-02||BEFORE triggers|| || || ||
+ ||T211-03||AFTER triggers|| || || ||
+ ||T211-04||FOR EACH ROW triggers|| || || ||
+ ||T211-05||Ability to specify a search condition that shall be True before the trigger is invoked.|| || || ||
+ ||T211-06||Support for run-time rules for the interaction of triggers and constraints.|| || || ||
+ ||T211-07||TRIGGER privilege|| || || ||
+ ||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|| || || ||
+ ||T251||SET TRANSACTION statement: LOCAL option|| || || ||
+ ||T261||Chained transactions|| || || ||
+ ||T271||Savepoints|| || || ||
+ ||T272||Enhanced savepoint management||N/A|| || ||
+ ||T281||SELECT privilege with column granularity|| || || ||
+ ||T301||Functional dependencies|| || || ||
+ ||T312||OVERLAY function|| || || ||
+ ||T322||Overloading of SQL-invoked functions and procedures|| || || ||
+ ||T323||Explicit security for external routines|| || || ||
+ ||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|| || || ||
+ ||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|| || || ||
+ ||T461||Symmetric BETWEEN predicate|| || || ||
+ ||T471||Result sets return value|| || || ||
+ ||T491||LATERAL derived table|| || || ||
+ ||T501||Enhanced EXISTS predicate|| || || ||
+ ||T511||Transaction counts|| || || ||
+ ||T541||Updatable table references|| ||N/A|| ||
+ ||T551||Optional key words for default syntax|| || || ||
+ ||T561||Holdable locators|| || || ||
+ ||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|| || || ||
+ ||T601||Local cursor references|| || || ||
+ ||T611||Elementary OLAP operations||N/A|| || ||
+ ||T612||Advanced OLAP operations||N/A|| || ||
+ ||T613||Sampling||N/A|| || ||
+ ||T621||Enhanced numeric functions||N/A|| || ||
+ ||T641||Multiple column assignment||N/A|| || ||
+ ||T651||SQL-schema statements in SQL routines|| || || ||
+ ||T652||SQL-dynamic statements in SQL routines|| || || ||
+ ||T653||SQL-schema statements in external routines|| || || ||
+ ||T654||SQL-dynamic statements in external routines|| || || ||
+ ||T655||Cyclically dependent routines|| || || ||
+