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 |