If a feature in another part of the standard is not listed in , does not support it.

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

This table describes mandatory SQL:2011 features not supported by . 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 and that are not listed in the tables in .

This table describes optional SQL:2011 features not supported by . 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