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.
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.
| 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 | 
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.
| 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 |