# 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

Parent topic: Derby support for SQL:2011 features