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, 10 Nov 2005 12:25:43 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

------------------------------------------------------------------------------
  |||||||||| ||
  ||||||||||~+'''''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|| <describe input statement>||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, "<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|| || || ||
+ ||'''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'''|| || || ||
  

Mime
View raw message