From derby-commits-return-1794-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Thu Nov 10 12:26:08 2005 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 74273 invoked from network); 10 Nov 2005 12:26:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 Nov 2005 12:26:07 -0000 Received: (qmail 3069 invoked by uid 500); 10 Nov 2005 12:26:07 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 3032 invoked by uid 500); 10 Nov 2005 12:26:06 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 3021 invoked by uid 99); 10 Nov 2005 12:26:06 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Nov 2005 04:26:05 -0800 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id DE54821D for ; Thu, 10 Nov 2005 13:25:43 +0100 (CET) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Thu, 10 Nov 2005 12:25:43 -0000 Message-ID: <20051110122543.25306.28652@ajax.apache.org> Subject: [Db-derby Wiki] Update of "SQLvsDerbyFeatures" by BerntJohnsen X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 ------------------------------------------------------------------------------ |||||||||| || ||||||||||~+'''''SQL-99 Outside Core / SQL-2003 Optional'''''+~|| ||'''Feature ID'''||'''Feature name'''||'''SQL-99 Outside Core'''||'''SQL-2003 Optional'''||'''Note''' || - ||B011||Embedded Ada||N/A||<#FF0000>No|| || + ||'''B011'''||'''Embedded Ada'''||N/A||<#FF0000>No|| || - ||B012||Embedded C||N/A||<#FF0000>No|| || + ||'''B012'''||'''Embedded C'''||N/A||<#FF0000>No|| || - ||B013||Embedded COBOL||N/A||<#FF0000>No|| || + ||'''B013'''||'''Embedded COBOL'''||N/A||<#FF0000>No|| || - ||B014||Embedded Fortran||N/A||<#FF0000>No|| || + ||'''B014'''||'''Embedded Fortran'''||N/A||<#FF0000>No|| || - ||B015||Embedded MUMPS||N/A||<#FF0000>No|| || + ||'''B015'''||'''Embedded MUMPS'''||N/A||<#FF0000>No|| || - ||B016||Embedded Pascal||N/A||<#FF0000>No|| || + ||'''B016'''||'''Embedded Pascal'''||N/A||<#FF0000>No|| || - ||B017||Embedded PL/I||N/A||<#FF0000>No|| || + ||'''B017'''||'''Embedded PL/I'''||N/A||<#FF0000>No|| || - ||B021||Direct SQL||N/A||<#FF0000>No|| || + ||'''B021'''||'''Direct SQL'''||N/A||<#FF0000>No|| || - ||B031||Basic dynamic SQL||N/A||<#FF0000>No|| || + ||'''B031'''||'''Basic dynamic SQL'''||N/A||<#FF0000>No|| || - ||B032||Extended dynamic SQL||N/A||<#FF0000>No|| || + ||'''B032'''||'''Extended dynamic SQL'''||N/A||<#FF0000>No|| || ||B032-01|| ||N/A||<#FF0000>No|| || - ||B033||Untyped SQL-invoked function arguments||N/A||<#FF0000>No|| || + ||'''B033'''||'''Untyped SQL-invoked function arguments'''||N/A||<#FF0000>No|| || - ||B034||Dynamic specification of cursor attributes||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|| || + ||'''B041'''||'''Extensions to embedded SQL exception declarations'''||N/A||<#FF0000>No|| || - ||B051||Enhanced execution rights||N/A||<#FF0000>No|| || + ||'''B051'''||'''Enhanced execution rights'''||N/A||<#FF0000>No|| || - ||B111||Module language Ada||N/A||<#FF0000>No|| || + ||'''B111'''||'''Module language Ada'''||N/A||<#FF0000>No|| || - ||B112||Module language C||N/A||<#FF0000>No|| || + ||'''B112'''||'''Module language C'''||N/A||<#FF0000>No|| || - ||B113||Module language COBOL||N/A||<#FF0000>No|| || + ||'''B113'''||'''Module language COBOL'''||N/A||<#FF0000>No|| || - ||B114||Module language Fortran||N/A||<#FF0000>No|| || + ||'''B114'''||'''Module language Fortran'''||N/A||<#FF0000>No|| || - ||B115||Module language MUMPS||N/A||<#FF0000>No|| || + ||'''B115'''||'''Module language MUMPS'''||N/A||<#FF0000>No|| || - ||B116||Module language Pascal||N/A||<#FF0000>No|| || + ||'''B116'''||'''Module language Pascal'''||N/A||<#FF0000>No|| || - ||B117||Module language PL/I||N/A||<#FF0000>No|| || + ||'''B117'''||'''Module language PL/I'''||N/A||<#FF0000>No|| || - ||B121||Routine language Ada||N/A||<#FF0000>No|| || + ||'''B121'''||'''Routine language Ada'''||N/A||<#FF0000>No|| || - ||B122||Routine language C||N/A||<#FF0000>No|| || + ||'''B122'''||'''Routine language C'''||N/A||<#FF0000>No|| || - ||B123||Routine language COBOL||N/A||<#FF0000>No|| || + ||'''B123'''||'''Routine language COBOL'''||N/A||<#FF0000>No|| || - ||B124||Routine language Fortran||N/A||<#FF0000>No|| || + ||'''B124'''||'''Routine language Fortran'''||N/A||<#FF0000>No|| || - ||B125||Routine language MUMPS||N/A||<#FF0000>No|| || + ||'''B125'''||'''Routine language MUMPS'''||N/A||<#FF0000>No|| || - ||B126||Routine language Pascal||N/A||<#FF0000>No|| || + ||'''B126'''||'''Routine language Pascal'''||N/A||<#FF0000>No|| || - ||B127||Routine language PL/I||N/A||<#FF0000>No|| || + ||'''B127'''||'''Routine language PL/I'''||N/A||<#FF0000>No|| || - ||B128||Routine language SQL||N/A||<#FF0000>No|| || + ||'''B128'''||'''Routine language SQL'''||N/A||<#FF0000>No|| || - ||F032||CASCADE drop behavior||<#FF0000>No||<#FF0000>No|| || + ||'''F032'''||'''CASCADE drop behavior'''||<#FF0000>No||<#FF0000>No|| || - ||F033||ALTER TABLE statement: DROP COLUMN clause||<#FF0000>No||<#FF0000>No|| || + ||'''F033'''||'''ALTER TABLE statement: DROP COLUMN clause'''||<#FF0000>No||<#FF0000>No|| || - ||F034||Extended REVOKE statement||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464 Issue DERBY-464]|| + ||'''F034'''||'''Extended REVOKE statement'''||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464 Issue DERBY-464]|| ||F034-01||REVOKE statement performed by other than the owner of a schema object||<#FF0000>No||<#FF0000>No|| || ||F034-02||REVOKE statement: GRANT OPTION FOR clause ||<#FF0000>No||<#FF0000>No|| || ||F034-03||REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION||<#FF0000>No||<#FF0000>No|| || - ||F052||Intervals and datetime arithmetic||<#FF0000>No||<#FF0000>No|| || + ||'''F052'''||'''Intervals and datetime arithmetic'''||<#FF0000>No||<#FF0000>No|| || - ||F053||OVERLAPS predicate||N/A||<#FF0000>No|| || + ||'''F053'''||'''OVERLAPS predicate'''||N/A||<#FF0000>No|| || - ||F111||Isolation levels other than SERIALIZABLE||<#00FF00>Yes||<#00FF00>Yes|| || + ||'''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||<#FF0000>No||<#FF0000>No|| || + ||'''F121'''||'''Basic diagnostics management'''||<#FF0000>No||<#FF0000>No|| || ||F121-01||GET DIAGNOSTICS statement||<#FF0000>No||<#FF0000>No|| || ||F121-02||SET TRANSACTION statement: DIAGNOSTICS SIZE clause||<#FF0000>No||<#FF0000>No|| || - ||F171||Multiple schemas per user||<#FF0000>No||<#FF0000>No||Derby does not support SQL users|| + ||'''F171'''||'''Multiple schemas per user'''||<#FF0000>No||<#FF0000>No||Derby does not support SQL users|| - ||F191||Referential delete actions||<#FF0000>No||<#FF0000>No|| || + ||'''F191'''||'''Referential delete actions'''||<#FF0000>No||<#FF0000>No|| || - ||F222||INSERT statement: DEFAULT VALUES clause||<#FF0000>No||<#FF0000>No|| || + ||'''F222'''||'''INSERT statement: DEFAULT VALUES clause'''||<#FF0000>No||<#FF0000>No|| || - ||F231||Privilege tables||<#FF0000>No||<#FF0000>No|| || + ||'''F231'''||'''Privilege tables'''||<#FF0000>No||<#FF0000>No|| || ||F231-01||TABLE_PRIVILEGES view||<#FF0000>No||<#FF0000>No|| || ||F231-02||COLUMN_PRIVILEGES view||<#FF0000>No||<#FF0000>No|| || ||F231-03||USAGE_PRIVILEGES view||<#FF0000>No||<#FF0000>No|| || - ||F251||Domain support||<#FF0000>No||<#FF0000>No|| || + ||'''F251'''||'''Domain support'''||<#FF0000>No||<#FF0000>No|| || - ||F262||Extended CASE expression||N/A|| || || + ||'''F262'''||'''Extended CASE expression'''||N/A|| || || - ||F271||Compound character literals|| || || || + ||'''F271'''||'''Compound character literals'''|| || || || - ||F281||LIKE enhancements|| || || || + ||'''F281'''||'''LIKE enhancements'''|| || || || - ||F291||UNIQUE predicate|| || || || + ||'''F291'''||'''UNIQUE predicate'''|| || || || - ||F301||CORRESPONDING in query expressions|| || || || + ||'''F301'''||'''CORRESPONDING in query expressions'''|| || || || - ||F302||INTERSECT table operator|| || || || + ||'''F302'''||'''INTERSECT table operator'''||<#00FF00>Yes||<#00FF00>Yes|| || - ||F302-01||INTERSECT DISTINCT table operator|| || || || + ||F302-01||INTERSECT DISTINCT table operator||<#00FF00>Yes||<#00FF00>Yes|| || - ||F302-02||INTERSECT ALL table operator|| || || || + ||F302-02||INTERSECT ALL table operator||<#00FF00>Yes||<#00FF00>Yes|| || - ||F304||EXCEPT ALL table operator|| || || || + ||'''F304'''||'''EXCEPT ALL table operator'''|| || || || - ||F312||MERGE statement||N/A|| || || + ||'''F312'''||'''MERGE statement'''||N/A|| || || - ||F321||User authorization|| || || || + ||'''F321'''||'''User authorization'''|| || || || - ||F341||Usage tables|| || || || + ||'''F341'''||'''Usage tables'''|| || || || - ||F361||Subprogram support|| || || || + ||'''F361'''||'''Subprogram support'''|| || || || - ||F381||Extended schema manipulation|| || || || + ||'''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|| || || || + ||'''F391'''||'''Long identifiers'''|| || || || - ||F392||Unicode escapes in identifiers||N/A|| || || + ||'''F392'''||'''Unicode escapes in identifiers'''||N/A|| || || - ||F393||Unicode escapes in literals||N/A|| || || + ||'''F393'''||'''Unicode escapes in literals'''||N/A|| || || - ||F401||Extended joined table|| || || || + ||'''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|| || || + ||'''F402'''||'''Named column joins for LOBs, arrays, and multisets'''||N/A|| || || - ||F411||Time zone specification|| || || || + ||'''F411'''||'''Time zone specification'''|| || || || - ||F421||National character|| || || || + ||'''F421'''||'''National character'''|| || || || - ||F431||Read-only scrollable cursors||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC. Only insensitive cursors.|| + ||'''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|| || || || + ||'''F441'''||'''Extended set function support'''|| || || || - ||F442||Mixed column references in set functions||N/A|| || || + ||'''F442'''||'''Mixed column references in set functions'''||N/A|| || || - ||F451||Character set definition|| || || || + ||'''F451'''||'''Character set definition'''|| || || || - ||F461||Named character sets|| || || || + ||'''F461'''||'''Named character sets'''|| || || || - ||F491||Constraint management|| || || || + ||'''F491'''||'''Constraint management'''|| || || || - ||F502||Enhanced documentation tables|| || || || + ||'''F502'''||'''Enhanced documentation tables'''|| || || || ||F502-01||SQL_SIZING_PROFILES view|| || || || ||F502-02||SQL_IMPLEMENTATION_INFO view|| || || || ||F502-03||SQL_PACKAGES view|| || || || - ||F521||Assertions|| || || || + ||'''F521'''||'''Assertions'''|| || || || - ||F531||Temporary tables|| || || || + ||'''F531'''||'''Temporary tables'''|| || || || - ||F555||Enhanced seconds precision|| || || || + ||'''F555'''||'''Enhanced seconds precision'''|| || || || - ||F561||Full value expressions|| || || || + ||'''F561'''||'''Full value expressions'''|| || || || - ||F571||Truth value tests|| || || || + ||'''F571'''||'''Truth value tests'''|| || || || - ||F591||Derived tables|| || || || + ||'''F591'''||'''Derived tables'''|| || || || - ||F611||Indicator data types|| || || || + ||'''F611'''||'''Indicator data types'''|| || || || - ||F641||Row and table constructors|| || || || + ||'''F641'''||'''Row and table constructors'''|| || || || - ||F651||Catalog name qualifiers|| || || || + ||'''F651'''||'''Catalog name qualifiers'''|| || || || - ||F661||Simple tables|| || || || + ||'''F661'''||'''Simple tables'''|| || || || - ||F671||Subqueries in CHECK|| || || || + ||'''F671'''||'''Subqueries in CHECK'''|| || || || - ||F672||Retrospective check constraints||N/A|| || || + ||'''F672'''||'''Retrospective check constraints'''||N/A|| || || - ||F691||Collation and translation|| || || || + ||'''F691'''||'''Collation and translation'''|| || || || - ||F692||Enhanced collation support||N/A|| || || + ||'''F692'''||'''Enhanced collation support'''||N/A|| || || - ||F693||SQL-session and client module collations||N/A|| || || + ||'''F693'''||'''SQL-session and client module collations'''||N/A|| || || - ||F695||Translation support||N/A|| || || + ||'''F695'''||'''Translation support'''||N/A|| || || - ||F696||Additional translation documentation||N/A|| || || + ||'''F696'''||'''Additional translation documentation'''||N/A|| || || - ||F701||Referential update actions|| || || || + ||'''F701'''||'''Referential update actions'''|| || || || - ||F711||ALTER domain|| || || || + ||'''F711'''||'''ALTER domain'''|| || || || - ||F721||Deferrable constraints|| || || || + ||'''F721'''||'''Deferrable constraints'''|| || || || - ||F731||INSERT column privileges|| || || || + ||'''F731'''||'''INSERT column privileges'''|| || || || - ||F741||Referential MATCH types|| || || || + ||'''F741'''||'''Referential MATCH types'''|| || || || - ||F751||View CHECK enhancements|| || || || + ||'''F751'''||'''View CHECK enhancements'''|| || || || - ||F761||Session management|| || || || + ||'''F761'''||'''Session management'''|| || || || - ||F771||Connection management|| || || || + ||'''F771'''||'''Connection management'''|| || || || - ||F781||Self-referencing operations|| || || || + ||'''F781'''||'''Self-referencing operations'''|| || || || - ||F791||Insensitive cursors||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC|| + ||'''F791'''||'''Insensitive cursors'''||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC|| - ||F801||Full set function || || || || + ||'''F801'''||'''Full set function '''|| || || || - ||F811||Extended flagging|| ||N/A|| || + ||'''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|| || || || + ||'''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|| || || || + ||'''F821'''||'''Local table references'''|| || || || - ||F831||Full cursor update|| || || || + ||'''F831'''||'''Full cursor update'''|| || || || ||F831-01||Updateable scrollable cursors|| || || || ||F831-02||Updateable ordered cursors|| || || || - ||S023||Basic structured types|| || || || + ||'''S023'''||'''Basic structured types'''|| || || || - ||S024||Enhanced structured types|| || || || + ||'''S024'''||'''Enhanced structured types'''|| || || || - ||S025||Final structured types||N/A|| || || + ||'''S025'''||'''Final structured types'''||N/A|| || || - ||S026||Self-referencing structured types||N/A|| || || + ||'''S026'''||'''Self-referencing structured types'''||N/A|| || || - ||S027||Create method by specific method name||N/A|| || || + ||'''S027'''||'''Create method by specific method name'''||N/A|| || || - ||S028||Permutable UDT options list||N/A|| || || + ||'''S028'''||'''Permutable UDT options list'''||N/A|| || || - ||S041||Basic reference types|| || || || + ||'''S041'''||'''Basic reference types'''|| || || || - ||S043||Enhanced reference types|| || || || + ||'''S043'''||'''Enhanced reference types'''|| || || || - ||S051||Create table of type|| || || || + ||'''S051'''||'''Create table of type'''|| || || || - ||S071||SQL paths in function and type name resolution|| || || || + ||'''S071'''||'''SQL paths in function and type name resolution'''|| || || || - ||S081||Subtables|| || || || + ||'''S081'''||'''Subtables'''|| || || || - ||S091||Basic array support|| || || || + ||'''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|| || || || + ||'''S092'''||'''Arrays of user-defined types'''|| || || || - ||S094||Arrays of reference types|| || || || + ||'''S094'''||'''Arrays of reference types'''|| || || || - ||S095||Array constructors by query||N/A|| || || + ||'''S095'''||'''Array constructors by query'''||N/A|| || || - ||S096||Optional array bounds||N/A|| || || + ||'''S096'''||'''Optional array bounds'''||N/A|| || || - ||S097||Array element assignment||N/A|| || || + ||'''S097'''||'''Array element assignment'''||N/A|| || || - ||S111||ONLY in query expressions|| || || || + ||'''S111'''||'''ONLY in query expressions'''|| || || || - ||S151||Type predicate|| || || || + ||'''S151'''||'''Type predicate'''|| || || || - ||S161||Subtype treatment|| || || || + ||'''S161'''||'''Subtype treatment'''|| || || || - ||S162||Subtype treatment for references||N/A|| || || + ||'''S162'''||'''Subtype treatment for references'''||N/A|| || || - ||S201||SQL-invoked routines on arrays|| || || || + ||'''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|| || || + ||'''S202'''||'''SQL-invoked routines on multisets'''||N/A|| || || - ||S211||User-defined cast functions|| || || || + ||'''S211'''||'''User-defined cast functions'''|| || || || - ||S231||Structured type locators|| || || || + ||'''S231'''||'''Structured type locators'''|| || || || - ||S232||Array locators|| || || || + ||'''S232'''||'''Array locators'''|| || || || - ||S233||Multiset locators||N/A|| || || + ||'''S233'''||'''Multiset locators'''||N/A|| || || - ||S241||Transform functions|| || || || + ||'''S241'''||'''Transform functions'''|| || || || - ||S242||Alter transform statement||N/A|| || || + ||'''S242'''||'''Alter transform statement'''||N/A|| || || - ||S251||User-defined orderings|| || || || + ||'''S251'''||'''User-defined orderings'''|| || || || - ||S261||Specific type method|| || || || + ||'''S261'''||'''Specific type method'''|| || || || - ||S271||Basic multiset support||N/A|| || || + ||'''S271'''||'''Basic multiset support'''||N/A|| || || - ||S272||Multisets of user-defined types||N/A|| || || + ||'''S272'''||'''Multisets of user-defined types'''||N/A|| || || - ||S274||Multisets of reference types||N/A|| || || + ||'''S274'''||'''Multisets of reference types'''||N/A|| || || - ||S275||Advanced multiset support||N/A|| || || + ||'''S275'''||'''Advanced multiset support'''||N/A|| || || - ||S281||Nested collection types||N/A|| || || + ||'''S281'''||'''Nested collection types'''||N/A|| || || - ||S291||Unique constraint on entire row||N/A|| || || + ||'''S291'''||'''Unique constraint on entire row'''||N/A|| || || - ||T011||Timestamp in Information Schema|| || || || + ||'''T011'''||'''Timestamp in Information Schema'''|| || || || - ||T031||BOOLEAN data type|| || || || + ||'''T031'''||'''BOOLEAN data type'''|| || || || - ||T041||Basic LOB data type support|| || || || + ||'''T041'''||'''Basic LOB data type support'''|| || || || ||T041-01|| BLOB data type -- Subclause 5.2, " and ": The s BINARY, BLOB, LARGE, and OBJECT -- Subclause 5.3, "": -- Subclause 6.1, "": The BINARY LARGE OBJECT data type -- Subclause 6.28, "": 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, " and ": The s CHARACTER, CLOB, LARGE, and OBJECT -- Subclause 6.1, "": The CHARACTER LARGE OBJECT data type -- Subclause 6.28, "": 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, "": The for expressions of type BINARY LARGE OBJECT and CHARACTER LARGE OBJECT -- Subclause 6.27, "": The for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.27, "": The for expressions of type BINARY LARGE OBJECT and CHARACTER LARGE OBJECT -- Subclause 6.29, "": The function for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.29, "": The for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.29, "": The -- Subclause 6.29, "": The for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.29, "": The || || || || ||T041-04|| Concatenation of LOB data types -- Subclause 6.28, "": The expression for expressions of type CHARACTER LARGE OBJECT -- Subclause 6.28, "": The expression|| || || || ||T041-05|| LOB locator: non-holdable -- Subclause 13.3, "": -- Subclause 14.14, ""|| || || || - ||T042||Extended LOB data type support|| || || || + ||'''T042'''||'''Extended LOB data type support'''|| || || || - ||T051||Row types|| || || || + ||'''T051'''||'''Row types'''|| || || || - ||T052||MAX and MIN for row types||N/A|| || || + ||'''T052'''||'''MAX and MIN for row types'''||N/A|| || || - ||T053||Explicit aliases for all-fields reference||N/A|| || || + ||'''T053'''||'''Explicit aliases for all-fields reference'''||N/A|| || || - ||T061||UCS support||N/A|| || || + ||'''T061'''||'''UCS support'''||N/A|| || || - ||T071||BIGINT data type||N/A|| || || + ||'''T071'''||'''BIGINT data type'''||N/A|| || || - ||T111||Updatable joins, unions, and columns|| || || || + ||'''T111'''||'''Updatable joins, unions, and columns'''|| || || || - ||T121||WITH (excluding RECURSIVE) in query expression|| || || || + ||'''T121'''||'''WITH (excluding RECURSIVE) in query expression'''|| || || || - ||T122||WITH (excluding RECURSIVE) in subquery||N/A|| || || + ||'''T122'''||'''WITH (excluding RECURSIVE) in subquery'''||N/A|| || || - ||T131||Recursive query|| || || || + ||'''T131'''||'''Recursive query'''|| || || || - ||T132||Recursive query in subquery||N/A|| || || + ||'''T132'''||'''Recursive query in subquery'''||N/A|| || || - ||T141||SIMILAR predicate|| || || || + ||'''T141'''||'''SIMILAR predicate'''|| || || || - ||T151||DISTINCT predicate|| || || || + ||'''T151'''||'''DISTINCT predicate'''|| || || || - ||T152||DISTINCT predicate with negation||N/A|| || || + ||'''T152'''||'''DISTINCT predicate with negation'''||N/A|| || || - ||T171||LIKE clause in table definition|| || || || + ||'''T171'''||'''LIKE clause in table definition'''|| || || || - ||T172||AS subquery clause in table definition||N/A|| || || + ||'''T172'''||'''AS subquery clause in table definition'''||N/A|| || || - ||T173||Extended LIKE clause in table definition||N/A|| || || + ||'''T173'''||'''Extended LIKE clause in table definition'''||N/A|| || || - ||T174||Identity columns||N/A|| || || + ||'''T174'''||'''Identity columns'''||N/A|| || || - ||T175||Generated columns||N/A|| || || + ||'''T175'''||'''Generated columns'''||N/A|| || || - ||T176||Sequence generator support||N/A|| || || + ||'''T176'''||'''Sequence generator support'''||N/A|| || || - ||T191||Referential action RESTRICT|| || || || + ||'''T191'''||'''Referential action RESTRICT'''|| || || || - ||T201||Comparable data types for referential constraints|| || || || + ||'''T201'''||'''Comparable data types for referential constraints'''|| || || || - ||T211||Basic trigger capability|| || || || + ||'''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|| || || || @@ -396, +396 @@ ||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|| || || || + ||'''T212'''||'''Enhanced trigger capability'''|| || || || - ||T231||Sensitive cursors|| || || || + ||'''T231'''||'''Sensitive cursors'''|| || || || - ||T241||START TRANSACTION statement|| || || || + ||'''T241'''||'''START TRANSACTION statement'''|| || || || - ||T251||SET TRANSACTION statement: LOCAL option|| || || || + ||'''T251'''||'''SET TRANSACTION statement: LOCAL option'''|| || || || - ||T261||Chained transactions|| || || || + ||'''T261'''||'''Chained transactions'''|| || || || - ||T271||Savepoints|| || || || + ||'''T271'''||'''Savepoints'''|| || || || - ||T272||Enhanced savepoint management||N/A|| || || + ||'''T272'''||'''Enhanced savepoint management'''||N/A|| || || - ||T281||SELECT privilege with column granularity|| || || || + ||'''T281'''||'''SELECT privilege with column granularity'''|| || || || - ||T301||Functional dependencies|| || || || + ||'''T301'''||'''Functional dependencies'''|| || || || - ||T312||OVERLAY function|| || || || + ||'''T312'''||'''OVERLAY function'''|| || || || - ||T322||Overloading of SQL-invoked functions and procedures|| || || || + ||'''T322'''||'''Overloading of SQL-invoked functions and procedures'''|| || || || - ||T323||Explicit security for external routines|| || || || + ||'''T323'''||'''Explicit security for external routines'''|| || || || - ||T324||Explicit security for SQL routines||N/A|| || || + ||'''T324'''||'''Explicit security for SQL routines'''||N/A|| || || - ||T325||Qualified SQL parameter references||N/A|| || || + ||'''T325'''||'''Qualified SQL parameter references'''||N/A|| || || - ||T326||Table functions||N/A|| || || + ||'''T326'''||'''Table functions'''||N/A|| || || - ||T331||Basic roles|| || || || + ||'''T331'''||'''Basic roles'''|| || || || - ||T332||Extended roles|| || || || + ||'''T332'''||'''Extended roles'''|| || || || - ||T351||Bracketed SQL comments (/*...*/ comments)|| || || || + ||'''T351'''||'''Bracketed SQL comments (/*...*/ comments)'''|| || || || - ||T431||Extended grouping capabilities|| || || || + ||'''T431'''||'''Extended grouping capabilities'''|| || || || - ||T432||Nested and concatenated GROUPING SETS||N/A|| || || + ||'''T432'''||'''Nested and concatenated GROUPING SETS'''||N/A|| || || - ||T433||Multiargument GROUPING function||N/A|| || || + ||'''T433'''||'''Multiargument GROUPING function'''||N/A|| || || - ||T434||GROUP BY DISINCT||N/A|| || || + ||'''T434'''||'''GROUP BY DISINCT'''||N/A|| || || - ||T441||ABS and MOD functions|| || || || + ||'''T441'''||'''ABS and MOD functions'''|| || || || - ||T461||Symmetric BETWEEN predicate|| || || || + ||'''T461'''||'''Symmetric BETWEEN predicate'''|| || || || - ||T471||Result sets return value|| || || || + ||'''T471'''||'''Result sets return value'''|| || || || - ||T491||LATERAL derived table|| || || || + ||'''T491'''||'''LATERAL derived table'''|| || || || - ||T501||Enhanced EXISTS predicate|| || || || + ||'''T501'''||'''Enhanced EXISTS predicate'''|| || || || - ||T511||Transaction counts|| || || || + ||'''T511'''||'''Transaction counts'''|| || || || - ||T541||Updatable table references|| ||N/A|| || + ||'''T541'''||'''Updatable table references'''|| ||N/A|| || - ||T551||Optional key words for default syntax|| || || || + ||'''T551'''||'''Optional key words for default syntax'''|| || || || - ||T561||Holdable locators|| || || || + ||'''T561'''||'''Holdable locators'''|| || || || - ||T571||Array-returning external SQL-invoked functions|| || || || + ||'''T571'''||'''Array-returning external SQL-invoked functions'''|| || || || - ||T572||Multiset-returning external SQL-invoked functions||N/A|| || || + ||'''T572'''||'''Multiset-returning external SQL-invoked functions'''||N/A|| || || - ||T581||Regular expression substring function|| || || || + ||'''T581'''||'''Regular expression substring function'''|| || || || - ||T591||UNIQUE constraints of possibly null columns|| || || || + ||'''T591'''||'''UNIQUE constraints of possibly null columns'''|| || || || - ||T601||Local cursor references|| || || || + ||'''T601'''||'''Local cursor references'''|| || || || - ||T611||Elementary OLAP operations||N/A|| || || + ||'''T611'''||'''Elementary OLAP operations'''||N/A|| || || - ||T612||Advanced OLAP operations||N/A|| || || + ||'''T612'''||'''Advanced OLAP operations'''||N/A|| || || - ||T613||Sampling||N/A|| || || + ||'''T613'''||'''Sampling'''||N/A|| || || - ||T621||Enhanced numeric functions||N/A|| || || + ||'''T621'''||'''Enhanced numeric functions'''||N/A|| || || - ||T641||Multiple column assignment||N/A|| || || + ||'''T641'''||'''Multiple column assignment'''||N/A|| || || - ||T651||SQL-schema statements in SQL routines|| || || || + ||'''T651'''||'''SQL-schema statements in SQL routines'''|| || || || - ||T652||SQL-dynamic statements in SQL routines|| || || || + ||'''T652'''||'''SQL-dynamic statements in SQL routines'''|| || || || - ||T653||SQL-schema statements in external routines|| || || || + ||'''T653'''||'''SQL-schema statements in external routines'''|| || || || - ||T654||SQL-dynamic statements in external routines|| || || || + ||'''T654'''||'''SQL-dynamic statements in external routines'''|| || || || - ||T655||Cyclically dependent routines|| || || || + ||'''T655'''||'''Cyclically dependent routines'''|| || || ||