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 |