/sql-2003-core-features.html

https://github.com/ronsavage/SQL · HTML · 260 lines · 236 code · 24 blank · 0 comment · 0 complexity · 566dec0b6693f0eede9f68792413a0c2 MD5 · raw file 

    

  1. <html>
    2. 

  2. <head>
    3. 

  3. <title> SQL 2003 Feature Taxonomy and Definition for Core SQL </title>
    4. 

  4. </head>
    5. 

  5. <body>
    6. 

  6. 

  7. <h1> SQL 2003 (Annex F, Table 34) Feature Taxonomy and Definition for Core SQL </h1>
    8. 

  8. 

  9. Derived from Final Committee Draft (FCD) of ISO/IEC 9075-2:2003.
    10. 

  10. <p>
    11. 

  11. 

  12. <table border=1>
    13. 

  13. <tr><th> Number </th><th> Feature ID </th><th> Feature Name </th><th> Feature Description </th></tr>
    14. 

  14. 

  15. <tr><td> 1 </td><td> B011 </td><td> Embedded Ada<sup>1</sup> </td><td> - Subclause 20.3, "&lt;embedded SQL Ada program&gt;" </td></tr>
    16. 

  16. <tr><td> 2 </td><td> B012 </td><td> Embedded C<sup>1</sup> </td><td> - Subclause 20.4, "&lt;embedded SQL C program&gt;" </td></tr>
    17. 

  17. <tr><td> 3 </td><td> B013 </td><td> Embedded COBOL<sup>1</sup> </td><td> - Subclause 20.5, "&lt;embedded SQL COBOL program&gt;" </td></tr>
    18. 

  18. <tr><td> 4 </td><td> B014 </td><td> Embedded Fortran<sup>1</sup> </td><td> - Subclause 20.6, "&lt;embedded SQL Fortran program&gt;" </td></tr>
    19. 

  19. <tr><td> 5 </td><td> B015 </td><td> Embedded MUMPS<sup>1</sup> </td><td> - Subclause 20.7, "&lt;embedded SQL MUMPS program&gt;" </td></tr>
    20. 

  20. <tr><td> 6 </td><td> B016 </td><td> Embedded Pascal<sup>1</sup> </td><td> - Subclause 20.8, "&lt;embedded SQL Pascal program&gt;" </td></tr>
    21. 

  21. <tr><td> 7 </td><td> B017 </td><td> Embedded PL/I<sup>1</sup> </td><td> - Subclause 20.9, "&lt;embedded SQL PL/I program&gt;" </td></tr>
    22. 

  22. 

  23. <tr><td colspan=4> <sup>1</sup> A conforming SQL-implementation is required (by Clause 8, "Conformance", in ISO/IEC 9075-1) to support at least one embedded language or to support the SQL-client module binding for at least one host language. </td></tr>
    24. 

  24. 

  25. <tr><td> 8 </td><td> E011 </td><td> Numeric data types </td><td> - Subclause 6.1, "&lt;data type&gt;", &lt;numeric type&gt;, including numeric expressions, numeric literals, numeric comparisons, and numeric assignments </td></tr>
    26. 

  26. <tr><td> 9 </td><td> E011-01 </td><td> INTEGER and SMALLINT data types (including all spellings) </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": The &lt;reserved word&gt;s INT, INTEGER, and SMALLINT </td></tr>
    27. 

  27. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 5.3, "&lt;literal&gt;": [&lt;sign&gt;] &lt;unsigned integer&gt; </td></tr>
    28. 

  28. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The INTEGER and SMALLINT &lt;exact numeric type&gt;s </td></tr>
    29. 

  29. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 13.6, "Data type correspondences": Type correspondences for INTEGER and SMALLINT for all supported languages </td></tr>
    30. 

  30. <tr><td> 10 </td><td> E011-02 </td><td> REAL, DOUBLE PRECISON, and FLOAT data types </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": The &lt;reserved word&gt;s REAL, DOUBLE, FLOAT, and PRECISION </td></tr>
    31. 

  31. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 5.3, "&lt;literal&gt;": [&lt;sign&gt;] &lt;approximate numeric literal&gt; </td></tr>
    32. 

  32. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": &lt;approximate numeric type&gt; </td></tr>
    33. 

  33. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 13.6, "Data type correspondences": Type correspondences for REAL, DOUBLE PRECISION, and FLOAT for all supported languages </td></tr>
    34. 

  34. 

  35. <tr><td> 11 </td><td> E011-03 </td><td> DECIMAL and NUMERIC data types </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": The &lt;reserved word&gt;s DEC, DECIMAL, and NUMERIC </td></tr>
    36. 

  36. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 5.3, "&lt;literal&gt;": [&lt;sign&gt;] &lt;exact numeric literal&gt; </td></tr>
    37. 

  37. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The DECIMAL and NUMERIC &lt;exact numeric type&gt;s </td></tr>
    38. 

  38. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 13.6, "Data type correspondences": Type correspondences for DECIMAL and NUMERIC for all supported languages </td></tr>
    39. 

  39. <tr><td> 12 </td><td> E011-04 </td><td> Arithmetic operators </td><td> - Subclause 6.26, "&lt;numeric value expression&gt;": When the &lt;numeric primary&gt; is a &lt;value expression primary&gt; </td></tr>
    40. 

  40. <tr><td> 13 </td><td> E011-05 </td><td> Numeric comparison </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": For the numeric data types, without support for &lt;table subquery&gt; and without support for Feature F131, "Grouped operations" </td></tr>
    41. 

  41. <tr><td> 14 </td><td> E011-06 </td><td> Implicit casting among the numeric data types </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": Values of any of the numeric data types can be compared to each other; such values are compared with respect to their algebraic values </td></tr>
    42. 

  42. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 9.1, "Retrieval assignment", and Subclause 9.2, "Store assignment": Values of one numeric type can be assigned to another numeric type, subject to rounding, truncation, and out of range conditions </td></tr>
    43. 

  43. <tr><td> 15 </td><td> E021 </td><td> Character data types </td><td> - Subclause 6.1, "&lt;data type&gt;": &lt;character string type&gt;, including character expressions, character literals, character comparisons, character assignments, and other operations on character data </td></tr>
    44. 

  44. <tr><td> 16 </td><td> E021-01 </td><td> CHARACTER data type (including all its spellings) </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": The &lt;reserved word&gt;s CHAR and CHARACTER </td></tr>
    45. 

  45. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The CHARACTER &lt;character string type&gt; </td></tr>
    46. 

  46. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.28, "&lt;string value expression&gt;": For values of type CHARACTER </td></tr>
    47. 

  47. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 13.6, "Data type correspondences": Type correspondences for CHARACTER for all supported languages </td></tr>
    48. 

  48. 

  49. <tr><td> 17 </td><td> E021-02 </td><td> CHARACTER VARYING data type (including all its spellings) </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": The &lt;reserved word&gt;s VARCHAR and VARYING </td></tr>
    50. 

  50. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The CHARACTER VARYING &lt;character string type&gt; </td></tr>
    51. 

  51. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.28, "&lt;string value expression&gt;": For values of type CHARACTER VARYING </td></tr>
    52. 

  52. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 13.6, "Data type correspondences": Type correspondences for CHARACTER VARYING for all supported languages </td></tr>
    53. 

  53. <tr><td> 18 </td><td> E021-03 </td><td> Character literals </td><td> - Subclause 5.3, "&lt;literal&gt;": &lt;quote&gt; [ &lt;character representation&gt;... ] &lt;quote&gt; </td></tr>
    54. 

  54. <tr><td> 19 </td><td> E021-04 </td><td> CHARACTER_LENGTH function </td><td> - Subclause 6.27, "&lt;numeric value function&gt;": The &lt;char length expression&gt; </td></tr>
    55. 

  55. <tr><td> 20 </td><td> E021-05 </td><td> OCTET_LENGTH function </td><td> - Subclause 6.27, "&lt;numeric value function&gt;": The &lt;octet length expression&gt; </td></tr>
    56. 

  56. <tr><td> 21 </td><td> E021-06 </td><td> SUBSTRING function </td><td> - Subclause 6.29, "&lt;string value function&gt;": The &lt;character substring function&gt; </td></tr>
    57. 

  57. <tr><td> 22 </td><td> E021-07 </td><td> Character concatenation </td><td> - Subclause 6.28, "&lt;string value expression&gt;": The &lt;concatenation&gt; expression </td></tr>
    58. 

  58. <tr><td> 23 </td><td> E021-08 </td><td> UPPER and LOWER functions </td><td> - Subclause 6.29, "&lt;string value function&gt;": The &lt;fold&gt; function </td></tr>
    59. 

  59. <tr><td> 24 </td><td> E021-09 </td><td> TRIM function </td><td> - Subclause 6.29, "&lt;string value function&gt;": The &lt;trim function&gt; </td></tr>
    60. 

  60. <tr><td> 25 </td><td> E021-10 </td><td> Implicit casting among the character data types </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": Values of either the CHARACTER or CHARACTER VARYING data types can be compared to each other </td></tr>
    61. 

  61. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 9.1, "Retrieval assignment", and Subclause 9.2, "Store assignment": Values of either the CHARACTER or CHARACTER VARYING data type can be assigned to the other type, subject to truncation conditions </td></tr>
    62. 

  62. <tr><td> 26 </td><td> E021-11 </td><td> POSITION function </td><td> - Subclause 6.27, "&lt;numeric value function&gt;": The &lt;position expression&gt; </td></tr>
    63. 

  63. <tr><td> 27 </td><td> E021-12 </td><td> Character comparison </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": For the CHARACTER and CHARACTER VARYING data types, without support for &lt;table subquery&gt; and without support for Feature F131, "Grouped operations" </td></tr>
    64. 

  64. <tr><td> 28 </td><td> E031 </td><td> Identifiers </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": &lt;regular identifier&gt; and &lt;delimited identifier&gt; </td></tr>
    65. 

  65. 

  66. <tr><td> 29 </td><td> E031-01 </td><td> Delimited identifiers </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": &lt;delimited identifier&gt; </td></tr>
    67. 

  67. <tr><td> 30 </td><td> E031-02 </td><td> Lower case identifiers </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": An alphabetic character in a &lt;regular identifier&gt; can be either lower case or upper case (meaning that non-delimited identifiers need not comprise only upper case letters) </td></tr>
    68. 

  68. <tr><td> 31 </td><td> E031-03 </td><td> Trailing underscore </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": The list &lt;identifier part&gt; in a &lt;regular identifier&gt; can be an &lt;underscore&gt; </td></tr>
    69. 

  69. <tr><td> 32 </td><td> E051 </td><td> Basic query specification </td><td> - Subclause 7.12, "&lt;query specification&gt;": When &lt;table reference&gt; is a &lt;table or query name&gt; that is a &lt;table name&gt;, without the support of Feature F131, "Grouped operations" </td></tr>
    70. 

  70. <tr><td> 33 </td><td> E051-01 </td><td> SELECT DISTINCT </td><td> - Subclause 7.12, "&lt;query specification&gt;": With a &lt;set quantifier&gt; of DISTINCT, but without subfeatures E051-02 through E051-09 </td></tr>
    71. 

  71. <tr><td> 34 </td><td> E051-02 </td><td> GROUP BY clause </td><td> - Subclause 7.4, "&lt;table expression&gt;": &lt;group by clause&gt;, but without subfeatures E051-03 through E051-09 </td></tr>
    72. 

  72. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 7.9, "&lt;group by clause&gt;": With the restrictions that the &lt;group by clause&gt; must contain all non-aggregated columns in the &lt;select list&gt; and that any column in the &lt;group by clause&gt; must also appear in the &lt;select list&gt; </td></tr>
    73. 

  73. <tr><td> 35 </td><td> E051-04 </td><td> GROUP BY can contain columns not in &lt;select list&gt; </td><td> - Subclause 7.9, "&lt;group by clause&gt;": Without the restriction that any column in the &lt;group by clause&gt; must also appear in the &lt;select list&gt; </td></tr>
    74. 

  74. <tr><td> 36 </td><td> E051-05 </td><td> Select list items can be renamed </td><td> - Subclause 7.12, "&lt;query specification&gt;": &lt;as clause&gt; </td></tr>
    75. 

  75. <tr><td> 37 </td><td> E051-06 </td><td> HAVING clause </td><td> - Subclause 7.4, "&lt;table expression&gt;": &lt;having clause&gt; </td></tr>
    76. 

  76. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 7.10, "&lt;having clause&gt;" </td></tr>
    77. 

  77. <tr><td> 38 </td><td> E051-07 </td><td> Qualified * in select list </td><td> - Subclause 7.12, "&lt;query specification&gt;": &lt;qualified asterisk&gt; </td></tr>
    78. 

  78. <tr><td> 39 </td><td> E051-08 </td><td> Correlation names in the FROM clause </td><td> - Subclause 7.6, "&lt;table reference&gt;": [ AS ] &lt;correlation name&gt; </td></tr>
    79. 

  79. <tr><td> 40 </td><td> E051-09 </td><td> Rename columns in the FROM clause </td><td> - Subclause 7.6, "&lt;table reference&gt;": [ AS ] &lt;correlation name&gt; [ &lt;left paren&gt; &lt;derived column list&gt; &lt;right paren&gt; ] </td></tr>
    80. 

  80. <tr><td> 41 </td><td> E061 </td><td> Basic predicates and search conditions </td><td> - Subclause 8.19, "&lt;search condition&gt;", and Subclause 8.1, "&lt;predicate&gt;" </td></tr>
    81. 

  81. 

  82. <tr><td> 42 </td><td> E061-01 </td><td> Comparison predicate </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": For supported data types, without support for &lt;table subquery&gt; </td></tr>
    83. 

  83. <tr><td> 43 </td><td> E061-02 </td><td> BETWEEN predicate </td><td> - Subclause 8.3, "&lt;between predicate&gt;" </td></tr>
    84. 

  84. <tr><td> 44 </td><td> E061-03 </td><td> IN predicate with list of values </td><td> - Subclause 8.4, "&lt;in predicate&gt;": Without support for &lt;table subquery&gt; </td></tr>
    85. 

  85. <tr><td> 45 </td><td> E061-04 </td><td> LIKE predicate </td><td> - Subclause 8.5, "&lt;like predicate&gt;": Without [ ESCAPE &lt;escape character&gt; ] </td></tr>
    86. 

  86. <tr><td> 46 </td><td> E061-05 </td><td> LIKE predicate: ESCAPE clause </td><td> - Subclause 8.5, "&lt;like predicate&gt;": With [ ESCAPE &lt;escape character&gt; ] </td></tr>
    87. 

  87. <tr><td> 47 </td><td> E061-06 </td><td> NULL predicate </td><td> - Subclause 8.7, "&lt;null predicate&gt;": Without Feature F481, "Expanded NULL predicate" </td></tr>
    88. 

  88. <tr><td> 48 </td><td> E061-07 </td><td> Quantified comparison predicate </td><td> - Subclause 8.8, "&lt;quantified comparison predicate&gt;": Without support for &lt;table subquery&gt; </td></tr>
    89. 

  89. <tr><td> 49 </td><td> E061-08 </td><td> EXISTS predicate </td><td> - Subclause 8.9, "&lt;exists predicate&gt;" </td></tr>
    90. 

  90. <tr><td> 50 </td><td> E061-09 </td><td> Subqueries in comparison predicate </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": For supported data types, with support for &lt;table subquery&gt; </td></tr>
    91. 

  91. <tr><td> 51 </td><td> E061-11 </td><td> Subqueries in IN predicate </td><td> - Subclause 8.4, "&lt;in predicate&gt;": With support for &lt;table subquery&gt; </td></tr>
    92. 

  92. <tr><td> 52 </td><td> E061-12 </td><td> Subqueries in quantified comparison predicate </td><td> - Subclause 8.8, "&lt;quantified comparison predicate&gt;": With support for &lt;table subquery&gt; </td></tr>
    93. 

  93. <tr><td> 53 </td><td> E061-13 </td><td> Correlated subqueries </td><td> - Subclause 8.1, "&lt;predicate&gt;": When a &lt;correlation name&gt; can be used in a &lt;table subquery&gt; as a correlated reference to a column in the outer query </td></tr>
    94. 

  94. <tr><td> 54 </td><td> E061-14 </td><td> Search condition </td><td> - Subclause 8.19, "&lt;search condition&gt;" </td></tr>
    95. 

  95. <tr><td> 55 </td><td> E071 </td><td> Basic query expressions </td><td> - Subclause 7.13, "&lt;query expression&gt;" </td></tr>
    96. 

  96. <tr><td> 56 </td><td> E071-01 </td><td> UNION DISTINCT table operator </td><td> - Subclause 7.13, "&lt;query expression&gt;": With support for UNION [ DISTINCT ] </td></tr>
    97. 

  97. <tr><td> 57 </td><td> E071-02 </td><td> UNION ALL table operator </td><td> - Subclause 7.13, "&lt;query expression&gt;": With support for UNION ALL </td></tr>
    98. 

  98. <tr><td> 58 </td><td> E071-03 </td><td> EXCEPT DISTINCT table operator </td><td> - Subclause 7.13, "&lt;query expression&gt;": With support for EXCEPT [ DISTINCT ] </td></tr>
    99. 

  99. <tr><td> 59 </td><td> E071-05 </td><td> Columns combined via table operators need not have exactly the same data type.  </td><td> - Subclause 7.13, "&lt;query expression&gt;": Columns combined via UNION and EXCEPT need not have exactly the same data type </td></tr>
    100. 

  100. <tr><td> 60 </td><td> E071-06 </td><td> Table operators in subqueries </td><td> - Subclause 7.13, "&lt;query expression&gt;": &lt;table subquery&gt;s can specify UNION and EXCEPT </td></tr>
    101. 

  101. <tr><td> 61 </td><td> E081 </td><td> Basic Privileges </td><td> - Subclause 12.3, "&lt;privileges&gt;" </td></tr>
    102. 

  102. 

  103. <tr><td> 62 </td><td> E081-01 </td><td> SELECT privilege </td><td> - Subclause 12.3, "&lt;privileges&gt;": With &lt;action&gt; of SELECT </td></tr>
    104. 

  104. <tr><td> 63 </td><td> E081-02 </td><td> DELETE privilege </td><td> - Subclause 12.3, "&lt;privileges&gt;": With &lt;action&gt; of DELETE </td></tr>
    105. 

  105. <tr><td> 64 </td><td> E081-03 </td><td> INSERT privilege at the table level </td><td> - Subclause 12.3, "&lt;privileges&gt;": With &lt;action&gt; of INSERT without &lt;privilege column list&gt; </td></tr>
    106. 

  106. <tr><td> 65 </td><td> E081-04 </td><td> UPDATE privilege at the table level </td><td> - Subclause 12.3, "&lt;privileges&gt;": With &lt;action&gt; of UPDATE without &lt;privilege column list&gt; </td></tr>
    107. 

  107. <tr><td> 66 </td><td> E081-05 </td><td> UPDATE privilege at the column level </td><td> - Subclause 12.3, "&lt;privileges&gt;": With &lt;action&gt; of UPDATE &lt;left paren&gt; &lt;privilege column list&gt; &lt;right paren&gt; </td></tr>
    108. 

  108. <tr><td> 67 </td><td> E081-06 </td><td> REFERENCES privilege at the table level </td><td> - Subclause 12.3, "&lt;privileges&gt;": with &lt;action&gt; of REFERENCES without &lt;privilege column list&gt; </td></tr>
    109. 

  109. <tr><td> 68 </td><td> E081-07 </td><td> REFERENCES privilege at the column level </td><td> - Subclause 12.3, "&lt;privileges&gt;": With &lt;action&gt; of REFERENCES &lt;left paren&gt; &lt;privilege column list&gt; &lt;right paren&gt; </td></tr>
    110. 

  110. <tr><td> 69 </td><td> E081-08 </td><td> WITH GRANT OPTION </td><td> - Subclause 12.2, "&lt;grant privilege statement&gt;": WITH GRANT OPTION </td></tr>
    111. 

  111. <tr><td> 70 </td><td> E091 </td><td> Set functions </td><td> - Subclause 6.9, "&lt;set function specification&gt;" </td></tr>
    112. 

  112. <tr><td> 71 </td><td> E091-01 </td><td> AVG </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;computational operation&gt; of AVG </td></tr>
    113. 

  113. <tr><td> 72 </td><td> E091-02 </td><td> COUNT </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;computational operation&gt; of COUNT </td></tr>
    114. 

  114. <tr><td> 73 </td><td> E091-03 </td><td> MAX </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;computational operation&gt; of MAX </td></tr>
    115. 

  115. <tr><td> 74 </td><td> E091-04 </td><td> MIN </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;computational operation&gt; of MIN </td></tr>
    116. 

  116. <tr><td> 75 </td><td> E091-05 </td><td> SUM </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;computational operation&gt; of SUM </td></tr>
    117. 

  117. <tr><td> 76 </td><td> E091-06 </td><td> ALL quantifier </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;set quantifier&gt; of ALL </td></tr>
    118. 

  118. <tr><td> 77 </td><td> E091-07 </td><td> DISTINCT quantifier </td><td> - Subclause 6.9, "&lt;set function specification&gt;": With &lt;set quantifier&gt; of DISTINCT </td></tr>
    119. 

  119. <tr><td> 78 </td><td> E101 </td><td> Basic data manipulation </td><td> - Clause 14, "Data manipulation": &lt;insert statement&gt;, &lt;delete statement: searched&gt;, and &lt;update statement: searched&gt; </td></tr>
    120. 

  120. 

  121. <tr><td> 79 </td><td> E101-01 </td><td> INSERT statement </td><td> - Subclause 14.8, "&lt;insert statement&gt;": When a &lt;contextually typed table value constructor&gt; can consist of no more than a single &lt;contextually typed row value expression&gt; </td></tr>
    122. 

  122. <tr><td> 80 </td><td> E101-03 </td><td> Searched UPDATE statement </td><td> - Subclause 14.11, "&lt;update statement: searched&gt;": But without support either of Feature E153, "Updatable tables with subqueries", or Feature F221, "Explicit defaults" </td></tr>
    123. 

  123. <tr><td> 81 </td><td> E101-04 </td><td> Searched DELETE statement </td><td> - Subclause 14.7, "&lt;delete statement: searched&gt;" </td></tr>
    124. 

  124. <tr><td> 82 </td><td> E111 </td><td> Single row SELECT statement </td><td> - Subclause 14.5, "&lt;select statement: single row&gt;": Without support of Feature F131, "Grouped operations" </td></tr>
    125. 

  125. <tr><td> 83 </td><td> E121 </td><td> Basic cursor support </td><td> - Clause 14, "Data manipulation": &lt;declare cursor&gt;, &lt;open statement&gt;, &lt;fetch statement&gt;, &lt;close statement&gt;, &lt;delete statement: positioned&gt;, and &lt;update statement: positioned&gt; </td></tr>
    126. 

  126. <tr><td> 84 </td><td> E121-01 </td><td> DECLARE CURSOR </td><td> - Subclause 14.1, "&lt;declare cursor&gt;": When each &lt;value expression&gt; in the &lt;sort key&gt; must be a &lt;column reference&gt; and that &lt;column reference&gt; must also be in the &lt;select list&gt;, and &lt;cursor holdability&gt; is not specified </td></tr>
    127. 

  127. <tr><td> 85 </td><td> E121-02 </td><td> ORDER BY columns need not be in select list </td><td> - Subclause 14.1, "&lt;declare cursor&gt;": Extend subfeature E121-01 so that &lt;column reference&gt; need not also be in the &lt;select list&gt; </td></tr>
    128. 

  128. <tr><td> 86 </td><td> E121-03 </td><td> Value expressions in ORDER BY clause </td><td> - Subclause 14.1, "&lt;declare cursor&gt;": Extend subfeature E121-01 so that the &lt;value expression&gt; in the &lt;sort key&gt; need not be a &lt;column reference&gt; </td></tr>
    129. 

  129. <tr><td> 87 </td><td> E121-04 </td><td> OPEN statement </td><td> - Subclause 14.2, "&lt;open statement&gt;" </td></tr>
    130. 

  130. <tr><td> 88 </td><td> E121-06 </td><td> Positioned UPDATE statement </td><td> - Subclause 14.10, "&lt;update statement: positioned&gt;": Without support of either Feature E153, "Updateable tables with subqueries" or Feature F221, "Explicit defaults" </td></tr>
    131. 

  131. <tr><td> 89 </td><td> E121-07 </td><td> Positioned DELETE statement </td><td> - Subclause 14.6, "&lt;delete statement: positioned&gt;" </td></tr>
    132. 

  132. <tr><td> 90 </td><td> E121-08 </td><td> CLOSE statement </td><td> - Subclause 14.4, "&lt;close statement&gt;" </td></tr>
    133. 

  133. <tr><td> 91 </td><td> E121-10 </td><td> FETCH statement: implicit NEXT </td><td> - Subclause 14.3, "&lt;fetch statement&gt;" </td></tr>
    134. 

  134. <tr><td> 92 </td><td> E121-17 </td><td> WITH HOLD cursors </td><td> - Subclause 14.1, "&lt;declare cursor&gt;": Where the &lt;value expression&gt; in the &lt;sort key&gt; need not be a &lt;column reference&gt; and need not be in the &lt;select list&gt;, and &lt;cursor holdability&gt; may be specified </td></tr>
    135. 

  135. 

  136. <tr><td> 93 </td><td> E131 </td><td> Null value support (nulls in lieu of values) </td><td> - Subclause 4.14, "Columns, fields, and attributes": Nullability characteristic </td></tr>
    137. 

  137. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.5, "&lt;contextually typed value specification&gt;": &lt;null specification&gt; </td></tr>
    138. 

  138. <tr><td> 94 </td><td> E141 </td><td> Basic integrity constraints </td><td> - Subclause 11.6, "&lt;table constraint definition&gt;": As specified by the subfeatures of this feature in this table </td></tr>
    139. 

  139. <tr><td> 95 </td><td> E141-01 </td><td> NOT NULL constraints </td><td> - Subclause 11.4, "&lt;column definition&gt;": With &lt;column constraint&gt; of NOT NULL </td></tr>
    140. 

  140. <tr><td> 96 </td><td> E141-02 </td><td> UNIQUE constraints of NOT NULL columns </td><td> - Subclause 11.4, "&lt;column definition&gt;": With &lt;unique specification&gt; of UNIQUE for columns specified as NOT NULL </td></tr>
    141. 

  141. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.7, "&lt;unique constraint definition&gt;": With &lt;unique specification&gt; of UNIQUE </td></tr>
    142. 

  142. <tr><td> 97 </td><td> E141-03 </td><td> PRIMARY KEY constraints </td><td> - Subclause 11.4, "&lt;column definition&gt;": With &lt;unique specification&gt; of PRIMARY KEY for columns specified as NOT NULL </td></tr>
    143. 

  143. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.7, "&lt;unique constraint definition&gt;": With &lt;unique specification&gt; of PRIMARY KEY </td></tr>
    144. 

  144. <tr><td> 98 </td><td> E141-04 </td><td> Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action.  </td><td> - Subclause 11.4, "&lt;column definition&gt;": With &lt;column constraint&gt; of &lt;references specification&gt; </td></tr>
    145. 

  145. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.8, "&lt;referential constraint definition&gt;": Where the columns in the &lt;column name list&gt;, if specified, must be in the same order as the names in the &lt;unique column list&gt; of the applicable &lt;unique constraint definition&gt; and the &lt;data type&gt;s of the matching columns must be the same </td></tr>
    146. 

  146. <tr><td> 99 </td><td> E141-06 </td><td> CHECK constraints </td><td> - Subclause 11.4, "&lt;column definition&gt;": With &lt;column constraint&gt; of &lt;check constraint definition&gt; </td></tr>
    147. 

  147. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.9, "&lt;check constraint definition&gt;" </td></tr>
    148. 

  148. <tr><td> 100 </td><td> E141-07 </td><td> Column defaults </td><td> - Subclause 11.4, "&lt;column definition&gt;": With &lt;default clause&gt; </td></tr>
    149. 

  149. <tr><td> 101 </td><td> E141-08 </td><td> NOT NULL inferred on PRIMARY KEY </td><td> - Subclause 11.4, "&lt;column definition&gt;", and Subclause 11.7, "&lt;unique constraint definition&gt;": Remove the restriction in subfeatures E141-02 and E141-03 that NOT NULL be specified along with every PRIMARY KEY and UNIQUE constraint </td></tr>
    150. 

  150. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.4, "&lt;column definition&gt;": NOT NULL is implicit on PRIMARY KEY constraints </td></tr>
    151. 

  151. 

  152. <tr><td> 102 </td><td> E141-10 </td><td> Names in a foreign key can be specified in any order </td><td> - Subclause 11.4, "&lt;column definition&gt;", and Subclause 11.8, "&lt;referential constraint definition&gt;": Extend subfeature E141-04 so that the columns in the &lt;column name list&gt;, if specified, need not be in the same order as the names in the &lt;unique column list&gt; of the applicable &lt;unique constraint definition&gt; </td></tr>
    153. 

  153. <tr><td> 103 </td><td> E141-11 </td><td> Foreign key"s data types need not be the same as the primary key"s </td><td> - Subclause 11.4, "&lt;column definition&gt;", and Subclause 11.8, "&lt;referential constraint definition&gt;": Extend subfeature E141-04 so that the data types of matching columns need not be the same. </td></tr>
    154. 

  154. <tr><td> 104 </td><td> E151 </td><td> Transaction support </td><td> - Clause 16, "Transaction management": &lt;commit statement&gt; and &lt;rollback statement&gt; </td></tr>
    155. 

  155. <tr><td> 105 </td><td> E151-01 </td><td> COMMIT statement </td><td> - Subclause 16.6, "&lt;commit statement&gt;" </td></tr>
    156. 

  156. <tr><td> 106 </td><td> E151-02 </td><td> ROLLBACK statement </td><td> - Subclause 16.7, "&lt;rollback statement&gt;" </td></tr>
    157. 

  157. <tr><td> 107 </td><td> E152 </td><td> Basic SET TRANSACTION statement </td><td> - Subclause 16.2, "&lt;set transaction statement&gt;" </td></tr>
    158. 

  158. <tr><td> 108 </td><td> E152-01 </td><td> SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause </td><td> - Subclause 16.2, "&lt;set transaction statement&gt;": With &lt;transaction mode&gt; of ISOLATION LEVEL SERIALIZABLE clause </td></tr>
    159. 

  159. <tr><td> 109 </td><td> E152-02 </td><td> SET TRANSACTION statement: READ ONLY and READ WRITE clauses </td><td> - Subclause 16.2, "&lt;set transaction statement&gt;": with &lt;transaction access mode&gt; of READ ONLY or READ WRITE </td></tr>
    160. 

  160. <tr><td> 110 </td><td> E153 </td><td> Updatable queries with subqueries </td><td> - Subclause 7.13, "&lt;query expression&gt;": A &lt;query expression&gt; is updatable even though its &lt;where clause&gt; contains a &lt;subquery&gt; </td></tr>
    161. 

  161. <tr><td> 111 </td><td> E161 </td><td> SQL comments using leading double minus </td><td> - Subclause 5.2, "&lt;token&gt; and &lt;separator&gt;": &lt;simple comment&gt; </td></tr>
    162. 

  162. <tr><td> 112 </td><td> E171 </td><td> SQLSTATE support </td><td> - Subclause 23.1, "SQLSTATE" </td></tr>
    163. 

  163. <tr><td> 113 </td><td> E182 </td><td> Module language </td><td> - Clause 13, "SQL-client modules" <br>(NOTE 450 - An SQL-implementation is required to supply at least one binding to a standard host language using either module language, embedded SQL, or both.) </td></tr>
    164. 

  164. <tr><td> 114 </td><td> F031 </td><td> Basic schema manipulation </td><td> - Clause 11, "Schema definition and manipulation": Selected facilities as indicated by the subfeatures of this Feature </td></tr>
    165. 

  165. <tr><td> 115 </td><td> F031-01 </td><td> CREATE TABLE statement to create persistent base tables </td><td> - Subclause 11.3, "&lt;table definition&gt;": Not in the context of a &lt;schema definition&gt; </td></tr>
    166. 

  166. 

  167. <tr><td> 116 </td><td> F031-02 </td><td> CREATE VIEW statement </td><td> - Subclause 11.22, "&lt;view definition&gt;": Not in the context of a &lt;schema definition&gt;, and without support of Feature F081, "UNION and EXCEPT in views" </td></tr>
    168. 

  168. <tr><td> 117 </td><td> F031-03 </td><td> GRANT statement </td><td> - Subclause 12.1, "&lt;grant statement&gt;": Not in the context of a &lt;schema definition&gt; </td></tr>
    169. 

  169. <tr><td> 118 </td><td> F031-04 </td><td> ALTER TABLE statement: ADD COLUMN clause </td><td> - Subclause 11.10, "&lt;alter table statement&gt;": The &lt;add column definition&gt; clause </td></tr>
    170. 

  170. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.11, "&lt;add column definition&gt;" </td></tr>
    171. 

  171. <tr><td> 119 </td><td> F031-13 </td><td> DROP TABLE statement: RESTRICT clause </td><td> - Subclause 11.21, "&lt;drop table statement&gt;": With a &lt;drop behavior&gt; of RESTRICT </td></tr>
    172. 

  172. <tr><td> 120 </td><td> F031-16 </td><td> DROP VIEW statement: RESTRICT clause </td><td> - Subclause 11.23, "&lt;drop view statement&gt;": With a &lt;drop behavior&gt; of RESTRICT </td></tr>
    173. 

  173. <tr><td> 121 </td><td> F031-19 </td><td> REVOKE statement: RESTRICT clause </td><td> - Subclause 12.7, "&lt;revoke statement&gt;": With a &lt;drop behavior&gt; of RESTRICT, only where the use of this statement can be restricted to the owner of the table being dropped </td></tr>
    174. 

  174. <tr><td> 122 </td><td> F041 </td><td> Basic joined table </td><td> - Subclause 7.7, "&lt;joined table&gt;" </td></tr>
    175. 

  175. <tr><td> 123 </td><td> F041-01 </td><td> Inner join (but not necessarily the INNER keyword) </td><td> - Subclause 7.6, "&lt;table reference&gt;": The &lt;joined table&gt; clause, but without support for subfeatures F041-02 through F041-08 </td></tr>
    176. 

  176. <tr><td> 124 </td><td> F041-02 </td><td> INNER keyword </td><td> - Subclause 7.7, "&lt;joined table&gt;": &lt;join type&gt; of INNER </td></tr>
    177. 

  177. <tr><td> 125 </td><td> F041-03 </td><td> LEFT OUTER JOIN </td><td> - Subclause 7.7, "&lt;joined table&gt;": &lt;outer join type&gt; of LEFT </td></tr>
    178. 

  178. <tr><td> 126 </td><td> F041-04 </td><td> RIGHT OUTER JOIN </td><td> - Subclause 7.7, "&lt;joined table&gt;": &lt;outer join type&gt; of RIGHT </td></tr>
    179. 

  179. <tr><td> 127 </td><td> F041-05 </td><td> Outer joins can be nested </td><td> - Subclause 7.7, "&lt;joined table&gt;": Subfeature F041-1 extended so that a &lt;table reference&gt; within the &lt;joined table&gt; can itself be a &lt;joined table&gt; </td></tr>
    180. 

  180. <tr><td> 128 </td><td> F041-07 </td><td> The inner table in a left or right outer join can also be used in an inner join </td><td> - Subclause 7.7, "&lt;joined table&gt;": Subfeature F041-1 extended so that a &lt;table name&gt; within a nested &lt;joined table&gt; can be the same as a &lt;table name&gt; in an outer &lt;joined table&gt; </td></tr>
    181. 

  181. <tr><td> 129 </td><td> F041-08 </td><td> All comparison operators are supported (rather than just =) </td><td> - Subclause 7.7, "&lt;joined table&gt;": Subfeature F041-1 extended so that the &lt;join condition&gt; is not limited to a &lt;comparison predicate&gt; with a &lt;comp op&gt; of &lt;equals operator&gt; </td></tr>
    182. 

  182. <tr><td> 130 </td><td> F051 </td><td> Basic date and time </td><td> - Subclause 6.1, "&lt;data type&gt;": &lt;datetime type&gt; including datetime literals, datetime comparisons, and datetime conversions </td></tr>
    183. 

  183. 

  184. <tr><td> 131 </td><td> F051-01 </td><td> DATE data type (including support of DATE literal) </td><td> - Subclause 5.3, "&lt;literal&gt;": The &lt;date literal&gt; form of &lt;datetime literal&gt; </td></tr>
    185. 

  185. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The DATE &lt;datetime type&gt; </td></tr>
    186. 

  186. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.30, "&lt;datetime value expression&gt;": For values of type DATE 132 F051-02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0. </td></tr>
    187. 

  187. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 5.3, "&lt;literal&gt;": The &lt;time literal&gt; form of &lt;datetime literal&gt;, where the value of &lt;unquoted time string&gt; is simply &lt;time value&gt; that does not include the optional &lt;time zone interval&gt; </td></tr>
    188. 

  188. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The TIME &lt;datetime type&gt; without the &lt;with or without timezone&gt; clause </td></tr>
    189. 

  189. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.30, "&lt;datetime value expression&gt;": For values of type TIME 133 F051-03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6. </td></tr>
    190. 

  190. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 5.3, "&lt;literal&gt;": The &lt;timestamp literal&gt; form of &lt;datetime literal&gt;, where the value of &lt;unquoted timestamp string&gt; is simply &lt;time value&gt; that does not include the optional &lt;time zone interval&gt; </td></tr>
    191. 

  191. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.1, "&lt;data type&gt;": The TIMESTAMP &lt;datetime type&gt; without the &lt;with or without timezone&gt; clause </td></tr>
    192. 

  192. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.30, "&lt;datetime value expression&gt;": For values of type TIMESTAMP </td></tr>
    193. 

  193. <tr><td> 134 </td><td> F051-04 </td><td> Comparison predicate on DATE, TIME, and TIMESTAMP data types </td><td> - Subclause 8.2, "&lt;comparison predicate&gt;": For comparison between values of the following types: DATE and DATE, TIME and TIME, TIMESTAMP and TIMESTAMP, DATE and TIMESTAMP, and TIME and TIMESTAMP </td></tr>
    194. 

  194. <tr><td> 135 </td><td> F051-05 </td><td> Explicit CAST between datetime types and character types </td><td> - Subclause 6.12, "&lt;cast specification&gt;": If support for Feature F201, "CAST function" is available, then CASTing between the following types: from character string to DATE, TIME, and TIMESTAMP; from DATE to DATE, TIMESTAMP, and character string; from TIME to TIME, TIMESTAMP, and character string; from TIMESTAMP to DATE, TIME, TIMESTAMP, and character string </td></tr>
    195. 

  195. <tr><td> 136 </td><td> F051-06 </td><td> CURRENT_DATE </td><td> - Subclause 6.31, "&lt;datetime value function&gt;": The &lt;current date value function&gt; </td></tr>
    196. 

  196. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.30, "&lt;datetime value expression&gt;": When the value is a &lt;current date value function&gt; </td></tr>
    197. 

  197. 

  198. <tr><td> 137 </td><td> F051-07 </td><td> LOCALTIME </td><td> - Subclause 6.31, "&lt;datetime value function&gt;": The &lt;current local time value function&gt; </td></tr>
    199. 

  199. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.30, "&lt;datetime value expression&gt;": When the value is a &lt;current local time value function&gt; </td></tr>
    200. 

  200. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.5, "&lt;default clause&gt;": LOCALTIME option of &lt;datetime value function&gt; </td></tr>
    201. 

  201. <tr><td> 138 </td><td> F051-08 </td><td> LOCALTIMESTAMP </td><td> - Subclause 6.31, "&lt;datetime value function&gt;": The &lt;current local timestamp value function&gt; </td></tr>
    202. 

  202. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.30, "&lt;datetime value expression&gt;": When the value is a &lt;current local timestamp value function&gt; </td></tr>
    203. 

  203. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.5, "&lt;default clause&gt;": LOCALTIMESTAMP option of &lt;datetime value function&gt; </td></tr>
    204. 

  204. <tr><td> 139 </td><td> F081 </td><td> UNION and EXCEPT in views </td><td> - Subclause 11.22, "&lt;view definition&gt;": A &lt;query expression&gt; in a &lt;view definition&gt; may specify UNION DISTINCT, UNION ALL, EXCEPT, and/or EXCEPT ALL </td></tr>
    205. 

  205. <tr><td> 140 </td><td> F131 </td><td> Grouped operations </td><td> - A grouped view is a view whose &lt;query expression&gt; contains a &lt;group by clause&gt; </td></tr>
    206. 

  206. <tr><td> 141 </td><td> F131-01 </td><td> WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views </td><td> - Subclause 7.4, "&lt;table expression&gt;": Even though a table in the &lt;from clause&gt; is a grouped view, the &lt;where clause&gt;, &lt;group by clause&gt;, and &lt;having clause&gt; may be specified </td></tr>
    207. 

  207. <tr><td> 142 </td><td> F131-02 </td><td> Multiple tables supported in queries with grouped views </td><td> - Subclause 7.5, "&lt;from clause&gt;": Even though a table in the &lt;from clause&gt; is a grouped view, the &lt;from clause&gt; may specify more than one &lt;table reference&gt; </td></tr>
    208. 

  208. <tr><td> 143 </td><td> F131-03 </td><td> Set functions supported in queries with grouped views </td><td> - Subclause 7.12, "&lt;query specification&gt;": Even though a table in the &lt;from clause&gt; is a grouped view, the &lt;select list&gt; may specify a &lt;set function specification&gt; </td></tr>
    209. 

  209. <tr><td> 144 </td><td> F131-04 </td><td> Subqueries with GROUP BY and HAVING clauses and grouped views </td><td> - Subclause 7.15, "&lt;subquery&gt;": A &lt;subquery&gt; in a &lt;comparison predicate&gt; is allowed to contain a &lt;group by clause&gt; and/or a &lt;having clause and/or it may identify a grouped view </td></tr>
    210. 

  210. <tr><td> 145 </td><td> F131-05 </td><td> Single row SELECT with GROUP BY and HAVING clauses and grouped views </td><td> - Subclause 14.5, "&lt;select statement: single row&gt;": The table in a &lt;from clause&gt; can be a grouped view </td></tr>
    211. 

  211. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 14.5, "&lt;select statement: single row&gt;": The &lt;table expression&gt; may specify a &lt;group by clause and/or a &lt;having clause </td></tr>
    212. 

  212. 

  213. <tr><td> 146 </td><td> F181 </td><td> Multiple module support <br>(NOTE 451 - The ability to associate multiple host compilation units with a single SQL-session at one time.) </td><td> - Subclause 13.1, "&lt;SQL-client module definition&gt;": An SQL-agent can be associated with more than one &lt;SQL-client module definition&gt; <br>(NOTE 452 - With this feature, it is possible to compile &lt;SQL-client module definition&gt;s or &lt;embedded SQL host program&gt;s separately and rely on the SQL-implementation to "link" the together properly at execution time. To ensure portability, applications should adhere to the following limitations: <br><bl><li> Avoid linking modules having cursors with the same &lt;cursor name&gt;. </li> <li> Avoid linking modules that prepare statements using the same &lt;SQL statement name&gt;. </li> <li> Avoid linking modules that allocate descriptors with the same &lt;descriptor name&gt;. </li> <li> Assume that the scope of an &lt;embedded exception declaration&gt; is a single compilation unit. </li> <li> Assume that an &lt;embedded variable name&gt; can be referenced only in the same compilation unit in which it is declared.) </li></bl> </td></tr>
    214. 

  214. <tr><td> 147 </td><td> F201 </td><td> CAST function <br>(NOTE 453 - This means the support of CAST, where relevant, among all supported data types.) </td><td> - Subclause 6.12, "&lt;cast specification&gt;": For all supported data types </td></tr>
    215. 

  215. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 6.25, "&lt;value expression&gt;": &lt;cast specification&gt; </td></tr>
    216. 

  216. <tr><td> 148 </td><td> F221 </td><td> Explicit defaults </td><td> - Subclause 6.5, "&lt;contextually typed value specification&gt;": &lt;default specification&gt; <br>(NOTE 454 - Including its use in UPDATE and INSERT statements.) </td></tr>
    217. 

  217. <tr><td> 149 </td><td> F261 </td><td> CASE expression </td><td> - Subclause 6.25, "&lt;value expression&gt;": &lt;case expression&gt; </td></tr>
    218. 

  218. <tr><td> 150 </td><td> F261-01 </td><td> Simple CASE </td><td> - Subclause 6.11, "&lt;case expression&gt;": The &lt;simple case&gt; variation </td></tr>
    219. 

  219. <tr><td> 151 </td><td> F261-02 </td><td> Searched CASE </td><td> - Subclause 6.11, "&lt;case expression&gt;": The &lt;searched case variation&gt; </td></tr>
    220. 

  220. <tr><td> 152 </td><td> F261-03 </td><td> NULLIF </td><td> - Subclause 6.11, "&lt;case expression&gt;": The NULLIF &lt;case abbreviation </td></tr>
    221. 

  221. <tr><td> 153 </td><td> F261-04 </td><td> COALESCE </td><td> - Subclause 6.11, "&lt;case expression&gt;": The COALESCE &lt;case abbreviation </td></tr>
    222. 

  222. <tr><td> 154 </td><td> F311 </td><td> Schema definition statement </td><td> - Subclause 11.1, "&lt;schema definition&gt;" </td></tr>
    223. 

  223. 

  224. <tr><td> 155 </td><td> F311-01 </td><td> CREATE SCHEMA </td><td> - Subclause 11.1, "&lt;schema definition&gt;": Support for circular references in that &lt;referential constraint definition&gt;s in two different &lt;table definition&gt;s may reference columns in the other table </td></tr>
    225. 

  225. <tr><td> 156 </td><td> F311-02 </td><td> CREATE TABLE for persistent base tables </td><td> - Subclause 11.1, "&lt;schema definition&gt;": A &lt;schema element&gt; that is a &lt;table definition&gt; </td></tr>
    226. 

  226. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.3, "&lt;table definition&gt;": In the context of a &lt;schema definition&gt; </td></tr>
    227. 

  227. <tr><td> 157 </td><td> F311-03 </td><td> CREATE VIEW </td><td> - Subclause 11.1, "&lt;schema definition&gt;": A &lt;schema element&gt; that is a &lt;view definition&gt; </td></tr>
    228. 

  228. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 11.22, "&lt;view definition&gt;": In the context of a &lt;schema definition&gt; without the WITH CHECK OPTION clause and without support of Feature F081, "UNION and EXCEPT in views" </td></tr>
    229. 

  229. <tr><td> 158 </td><td> F311-04 </td><td> CREATE VIEW: WITH CHECK OPTION </td><td> - Subclause 11.22, "&lt;view definition&gt;": The WITH CHECK OPTION clause, in the context of a &lt;schema definition&gt;, but without support of Feature F081, "UNION and EXCEPT in views" </td></tr>
    230. 

  230. <tr><td> 159 </td><td> F311-05 </td><td> GRANT statement </td><td> - Subclause 11.1, "&lt;schema definition&gt;": A &lt;schema element&gt; that is a &lt;grant statement&gt; </td></tr>
    231. 

  231. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 12.1, "&lt;grant statement&gt;": In the context of a &lt;schema definition&gt; </td></tr>
    232. 

  232. <tr><td> 160 </td><td> F471 </td><td> Scalar subquery values </td><td> - Subclause 6.25, "&lt;value expression&gt;": A &lt;value expression primary&gt; can be a &lt;scalar subquery&gt; </td></tr>
    233. 

  233. <tr><td> 161 </td><td> F481 </td><td> Expanded NULL predicate </td><td> - Subclause 8.7, "&lt;null predicate&gt;": The &lt;row value expression&gt; can be something other than a &lt;column reference&gt; </td></tr>
    234. 

  234. <tr><td> 162 </td><td> F812 </td><td> Basic flagging </td><td> - Part 1, Subclause 8.1.4, "SQL flagger": With "level of flagging" specified to be Core SQL Flagging and "extent of checking" specified to be Syntax Only <br>(NOTE 455 - This form of flagging identifies vendor extensions and other non-standard SQL by checking syntax only without requiring access to the catalog information.) </td></tr>
    235. 

  235. <tr><td> 163 </td><td> S011 </td><td> Distinct data types </td><td> - Subclause 11.41, "&lt;user-defined type definition&gt;": When &lt;representation&gt; is &lt;predefined type&gt; </td></tr>
    236. 

  236. 

  237. <tr><td> 164 </td><td> T321 </td><td> Basic SQL-invoked routines </td><td> - Subclause 11.50, "&lt;SQL-invoked routine&gt;" </td></tr>
    238. 

  238. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - If Feature T041, "Basic LOB data type support", is supported, then the &lt;locator indication&gt; clause must also be supported <br>(NOTE 456 - "Routine" is the collective term for functions, methods, and procedures.  This feature requires a conforming SQLimplementation to support both user-defined functions and user-defined procedures.  An SQL-implementation that conforms to Core SQL must support at least one language for writing routines; that language may be SQL. If the language is SQL, then the basic specification capability in Core SQL is the ability to specify a one-statement routine.  Support for overloaded functions and procedures is not part of Core SQL.) </td></tr>
    239. 

  239. <tr><td> 165 </td><td> T321-01 </td><td> User-defined functions with no overloading </td><td> - Subclause 11.50, "&lt;SQL-invoked routine&gt;": With &lt;function specification&gt; </td></tr>
    240. 

  240. <tr><td> 166 </td><td> T321-02 </td><td> User-defined stored procedures with no overloading </td><td> - Subclause 11.50, "&lt;SQL-invoked routine&gt;": With &lt;SQL-invoked procedure&gt; </td></tr>
    241. 

  241. <tr><td> 167 </td><td> T321-03 </td><td> Function invocation </td><td> - Subclause 6.4, "&lt;value specification&gt; and &lt;target specification&gt;": With a &lt;value expression primary&gt; that is a &lt;routine invocation&gt; </td></tr>
    242. 

  242. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 10.4, "&lt;routine invocation&gt;": For user-defined functions </td></tr>
    243. 

  243. <tr><td> 168 </td><td> T321-04 </td><td> CALL statement </td><td> - Subclause 10.4, "&lt;routine invocation&gt;": Used by &lt;call statement&gt;s </td></tr>
    244. 

  244. <tr><td> &nbsp; </td><td> &nbsp; </td><td> &nbsp; </td><td> - Subclause 15.1, "&lt;call statement&gt;" </td></tr>
    245. 

  245. <tr><td> 169 </td><td> T321-05 </td><td> RETURN statement </td><td> - Subclause 15.2, "&lt;return statement&gt;", if the SQL-implementation supports SQL routines </td></tr>
    246. 

  246. 

  247. </table>
    248. 

  248. 

  249. <hr>
    250. 

  250. <p>
    251. 

  251. Please send feedback to Jonathan Leffler:
    252. 

  252. <a href="mailto:jonathan.leffler@gmail.com"> jonathan.leffler@gmail.com </a>.
    253. 

  253. </p>
    254. 

  254. 

  255. <p><font color=green><i><small>
    256. 

  256. @(#)$Id: sql-2003-core-features.html,v 1.3 2017/11/13 20:45:42 jleffler Exp $
    257. 

  257. </small></i></font></p>
    258. 

  258. 

  259. </body>
    260. 

  260. </html>
    261.