SQL:2011 features not supported by Derby

Some mandatory and optional features in Part 2 of the SQL:2011 standard are not supported by Derby.

If a feature in another part of the standard is not listed in Derby support for SQL:2011 features, Derby does not support it.

Mandatory features

The following table lists the mandatory features in Part 2 of the SQL:2011 standard that are not supported by Derby and that are not listed in the tables in Derby support for SQL:2011 features.

Table 1. Mandatory SQL:2011 features not supported by Derby
Feature ID Feature Name
E153 Updatable queries with subqueries
E182 Module language
F081 UNION and EXCEPT in views
F181 Multiple module support
F812 Basic flagging
S011 Distinct data types

Optional features

The following table lists the optional features in Part 2 of the SQL:2011 standard that are not supported by Derby and that are not listed in the tables in Derby support for SQL:2011 features.

Table 2. Optional SQL:2011 features not supported by Derby
Feature ID Feature Name
F032 CASCADE drop behavior
F034 Extended REVOKE statement (F034-01 through F034-03)
F052 Intervals and datetime arithmetic
F053 OVERLAPS predicate
F121 Basic diagnostics management (F121-01, F121-02)
F171 Multiple schemas per user
F191 Referential delete actions
F222 INSERT statement: DEFAULT VALUES clause
F251 Domain support
F271 Compound character literals
F291 UNIQUE predicate
F301 CORRESPONDING in query expressions
F321 User authorization
F361 Subprogram support
F392 Unicode escapes in identifiers
F393 Unicode escapes in literals
F411 Time zone specification
F421 National character
F431 Read-only scrollable cursors (available through JDBC, but F431-01 through F431-06 are unsupported)
F441 Extended set function support
F442 Mixed column references in set functions
F451 Character set definition
F461 Named character sets
F521 Assertions
F555 Enhanced seconds precision
F561 Full value expressions
F571 Truth value tests
F611 Indicator data types
F651 Catalog name qualifiers
F661 Simple tables
F671 Subqueries in CHECK
F672 Retrospective check constraints
F692 Enhanced collation support
F693 SQL-session and client module collations
F695 Translation support
F711 ALTER domain
F731 INSERT column privileges
F741 Referential MATCH types
F751 View CHECK enhancements
F761 Session management
F771 Connection management
F813 Extended flagging
F821 Local table references
T051 Row types
T053 Explicit aliases for all-fields reference
T061 UCS support
T111 Updatable joins, unions, and columns
T121 WITH (excluding RECURSIVE) in query expression
T122 WITH (excluding RECURSIVE) in subquery
T131 Recursive query
T132 Recursive query in subquery
T141 SIMILAR predicate
T151 DISTINCT predicate
T152 DISTINCT predicate with negation
T171 LIKE clause in table definition
T172 AS subquery clause in table definition
T173 Extended LIKE clause in table definition
T201 Comparable data types for referential constraints
T231 Sensitive cursors
T241 START TRANSACTION statement
T251 SET TRANSACTION statement: LOCAL option
T261 Chained transactions
T272 Enhanced savepoint management
T301 Functional dependencies
T312 OVERLAY function
T324 Explicit security for SQL routines
T325 Qualified SQL parameter references
T432 Nested and concatenated GROUPING SETS
T433 Multiargument GROUPING function
T434 GROUP BY DISTINCT
T461 Symmetric BETWEEN predicate
T471 Result sets return value
T491 LATERAL derived table
T511 Transaction counts
T551 Optional key words for default syntax
T561 Holdable locators
T571 Array-returning external SQL-invoked functions
T572 Multiset-returning external SQL-invoked functions
T581 Regular expression substring function
T601 Local cursor references
T612 Advanced OLAP operations
T613 Sampling
T621 Enhanced numeric functions
T641 Multiple column assignment
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