PageRenderTime 59ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/manual/conformance.md

https://bitbucket.org/chancey/eagle
Markdown | 783 lines | 717 code | 66 blank | 0 comment | 0 complexity | cca2722166515f9027fcee9b8d45c459 MD5 | raw file
    

  1. SQL Standard Conformance {#conformance}
    2. 

  2. ========================
    3. 

  3. 

  4. [TOC]
    5. 

  5. 

  6. Key {#conformance-key}
    7. 

  7. ===
    8. 

  8. 

  9. | Key        | Description                                                                    |
    10. 

  10. |:-----------|:-------------------------------------------------------------------------------|
    11. 

  11. | \d{Strike} | These items are not supported and are not planned to be supported.             |
    12. 

  12. | Normal     | These items are not supported but plan to be supported in the future.          |
    13. 

  13. | _Italics_  | These items are partly supported and are available since the version provided. |
    14. 

  14. | **Bold**   | These items are fully supported and are available since the version provided.  |
    15. 

  15. 

  16. B {#conformance-b}
    17. 

  17. ===
    18. 

  18. 

  19. B0 {#conformance-b0}
    20. 

  20. ---
    21. 

  21. 

  22. | Identifier  | Description                                       | Comments |
    23. 

  23. |:------------|:--------------------------------------------------|:---------|
    24. 

  24. | \d{B011}    | Embedded Ada                                      | |
    25. 

  25. | \d{B012}    | Embedded C                                        | |
    26. 

  26. | \d{B013}    | Embedded COBOL                                    | |
    27. 

  27. | \d{B014}    | Embedded Fortran                                  | |
    28. 

  28. | \d{B015}    | Embedded MUMPS                                    | |
    29. 

  29. | \d{B016}    | Embedded Pascal                                   | |
    30. 

  30. | \d{B017}    | Embedded PL/I                                     | |
    31. 

  31. | \d{B021}    | Direct SQL                                        | |
    32. 

  32. | \d{B031}    | Basic dynamic SQL                                 | |
    33. 

  33. | \d{B032}    | Extended dynamic SQL                              | |
    34. 

  34. | \d{B032-01} | describe input statement                          | |
    35. 

  35. | \d{B033}    | Untyped SQL-invoked function arguments            | |
    36. 

  36. | \d{B034}    | Dynamic specification of cursor attributes        | |
    37. 

  37. | \d{B035}    | Non-extended descriptor names                     | |
    38. 

  38. | \d{B041}    | Extensions to embedded SQL exception declarations | |
    39. 

  39. | \d{B051}    | Enhanced execution rights                         | |
    40. 

  40. 

  41. B1 {#conformance-b1}
    42. 

  42. ---
    43. 

  43. 

  44. | Identifier | Description              | Comments |
    45. 

  45. |:-----------|:-------------------------|:---------|
    46. 

  46. | \d{B111}   | Module language Ada      | |
    47. 

  47. | \d{B112}   | Module language C        | |
    48. 

  48. | \d{B113}   | Module language COBOL    | |
    49. 

  49. | \d{B114}   | Module language Fortran  | |
    50. 

  50. | \d{B115}   | Module language MUMPS    | |
    51. 

  51. | \d{B116}   | Module language Pascal   | |
    52. 

  52. | \d{B117}   | Module language PL/I     | |
    53. 

  53. | \d{B121}   | Routine language Ada     | |
    54. 

  54. | \d{B122}   | Routine language C       | |
    55. 

  55. | \d{B123}   | Routine language COBOL   | |
    56. 

  56. | \d{B124}   | Routine language Fortran | |
    57. 

  57. | \d{B125}   | Routine language MUMPS   | |
    58. 

  58. | \d{B126}   | Routine language Pascal  | |
    59. 

  59. | \d{B127}   | Routine language PL/I    | |
    60. 

  60. | \d{B128}   | Routine language SQL     | |
    61. 

  61. 

  62. B2 {#conformance-b2}
    63. 

  63. ---
    64. 

  64. 

  65. | Identifier | Description                                       | Comments |
    66. 

  66. |:-----------|:--------------------------------------------------|:---------|
    67. 

  67. | \d{B211}   | Module language Ada: VARCHAR and NUMERIC support  | |
    68. 

  68. | \d{B221}   | Routine language Ada: VARCHAR and NUMERIC support | |
    69. 

  69. 

  70. E {#conformance-e}
    71. 

  71. ===
    72. 

  72. 

  73. E0 {#conformance-e0}
    74. 

  74. ---
    75. 

  75. 

  76. | Identifier | Description                                                            | Comments |
    77. 

  77. |:-----------|:-----------------------------------------------------------------------|:---------|
    78. 

  78. | E011       | Numeric data types                                                     | |
    79. 

  79. | E011-01    | INTEGER and SMALLINT data types                                        | |
    80. 

  80. | E011-02    | REAL, DOUBLE PRECISION, and FLOAT data types                           | |
    81. 

  81. | E011-03    | DECIMAL and NUMERIC data types                                         | |
    82. 

  82. | E011-04    | Arithmetic operators                                                   | |
    83. 

  83. | E011-05    | Numeric comparison                                                     | |
    84. 

  84. | E011-06    | Implicit casting among the numeric data types                          | |
    85. 

  85. | E021       | Character data types                                                   | |
    86. 

  86. | E021-01    | CHARACTER data type                                                    | |
    87. 

  87. | E021-02    | CHARACTER VARYING data type                                            | |
    88. 

  88. | E021-03    | Character literals                                                     | |
    89. 

  89. | E021-04    | CHARACTER_LENGTH function                                              | |
    90. 

  90. | E021-05    | OCTET_LENGTH function                                                  | |
    91. 

  91. | E021-06    | SUBSTRING function                                                     | |
    92. 

  92. | E021-07    | Character concatenation                                                | |
    93. 

  93. | E021-08    | UPPER and LOWER functions                                              | |
    94. 

  94. | E021-09    | TRIM function                                                          | |
    95. 

  95. | E021-10    | Implicit casting among the character string types                      | |
    96. 

  96. | E021-11    | POSITION function                                                      | |
    97. 

  97. | E021-12    | Character comparison                                                   | |
    98. 

  98. | E031       | Identifiers                                                            | |
    99. 

  99. | E031-01    | Delimited identifiers                                                  | |
    100. 

  100. | E031-02    | Lower case identifiers                                                 | |
    101. 

  101. | E031-03    | Trailing underscore                                                    | |
    102. 

  102. | E051       | Basic query specification                                              | |
    103. 

  103. | E051-01    | SELECT DISTINCT                                                        | |
    104. 

  104. | E051-02    | GROUP BY clause                                                        | |
    105. 

  105. | E051-04    | GROUP BY can contain columns not in select list                        | |
    106. 

  106. | E051-05    | Select list items can be renamed                                       | |
    107. 

  107. | E051-06    | HAVING clause                                                          | |
    108. 

  108. | E051-07    | Qualified * in select list                                             | |
    109. 

  109. | E051-08    | Correlation names in the FROM clause                                   | |
    110. 

  110. | E051-09    | Rename columns in the FROM clause                                      | |
    111. 

  111. | E061       | Basic predicates and search conditions                                 | |
    112. 

  112. | E061-01    | Comparison predicate                                                   | |
    113. 

  113. | E061-02    | BETWEEN predicate                                                      | |
    114. 

  114. | E061-03    | IN predicate with list of values                                       | |
    115. 

  115. | E061-04    | LIKE predicate                                                         | |
    116. 

  116. | E061-05    | LIKE predicate ESCAPE clause                                           | |
    117. 

  117. | E061-06    | NULL predicate                                                         | |
    118. 

  118. | E061-07    | Quantified comparison predicate                                        | |
    119. 

  119. | E061-08    | EXISTS predicate                                                       | |
    120. 

  120. | E061-09    | Subqueries in comparison predicate                                     | |
    121. 

  121. | E061-11    | Subqueries in IN predicate                                             | |
    122. 

  122. | E061-12    | Subqueries in quantified comparison predicate                          | |
    123. 

  123. | E061-13    | Correlated subqueries                                                  | |
    124. 

  124. | E061-14    | Search condition                                                       | |
    125. 

  125. | E071       | Basic query expressions                                                | |
    126. 

  126. | E071-01    | UNION DISTINCT table operator                                          | |
    127. 

  127. | E071-02    | UNION ALL table operator                                               | |
    128. 

  128. | E071-03    | EXCEPT DISTINCT table operator                                         | |
    129. 

  129. | E071-05    | Columns combined via table operators need not have exactly the same data type | |
    130. 

  130. | E071-06    | Table operators in subqueries                                          | |
    131. 

  131. | E081       | Basic Privileges                                                       | |
    132. 

  132. | E081-01    | SELECT privilege                                                       | |
    133. 

  133. | E081-02    | DELETE privilege                                                       | |
    134. 

  134. | E081-03    | INSERT privilege at the table level                                    | |
    135. 

  135. | E081-04    | UPDATE privilege at the table level                                    | |
    136. 

  136. | E081-05    | UPDATE privilege at the column level                                   | |
    137. 

  137. | E081-06    | REFERENCES privilege at the table level                                | |
    138. 

  138. | E081-07    | REFERENCES privilege at the column level                               | |
    139. 

  139. | E081-08    | WITH GRANT OPTION                                                      | |
    140. 

  140. | E081-09    | USAGE privilege                                                        | |
    141. 

  141. | E081-10    | EXECUTE privilege                                                      | |
    142. 

  142. | E091       | Set functions                                                          | |
    143. 

  143. | E091-01    | AVG                                                                    | |
    144. 

  144. | E091-02    | COUNT                                                                  | |
    145. 

  145. | E091-03    | MAX                                                                    | |
    146. 

  146. | E091-04    | MIN                                                                    | |
    147. 

  147. | E091-05    | SUM                                                                    | |
    148. 

  148. | E091-06    | ALL quantifier                                                         | |
    149. 

  149. | E091-07    | DISTINCT quantifier                                                    | |
    150. 

  150. 

  151. E1 {#conformance-e1}
    152. 

  152. ---
    153. 

  153. 

  154. | Identifier | Description                                                            | Comments |
    155. 

  155. |:-----------|:-----------------------------------------------------------------------|:---------|
    156. 

  156. | E101       | Basic data manipulation                                                | |
    157. 

  157. | E101-01    | INSERT statement                                                       | |
    158. 

  158. | E101-03    | Searched UPDATE statement                                              | |
    159. 

  159. | E101-04    | Searched DELETE statement                                              | |
    160. 

  160. | E111       | Single row SELECT statement                                            | |
    161. 

  161. | E121       | Basic cursor support                                                   | |
    162. 

  162. | E121-01    | DECLARE CURSOR                                                         | |
    163. 

  163. | E121-02    | ORDER BY columns need not be in select list                            | |
    164. 

  164. | E121-03    | Value expressions in ORDER BY clause                                   | |
    165. 

  165. | E121-04    | OPEN statement                                                         | |
    166. 

  166. | E121-06    | Positioned UPDATE statement                                            | |
    167. 

  167. | E121-07    | Positioned DELETE statement                                            | |
    168. 

  168. | E121-08    | CLOSE statement                                                        | |
    169. 

  169. | E121-10    | FETCH statement implicit NEXT                                          | |
    170. 

  170. | E121-17    | WITH HOLD cursors                                                      | |
    171. 

  171. | E131       | Null value support (nulls in lieu of values)                           | |
    172. 

  172. | E141       | Basic integrity constraints                                            | |
    173. 

  173. | E141-01    | NOT NULL constraints                                                   | |
    174. 

  174. | E141-02    | UNIQUE constraints of NOT NULL columns                                 | |
    175. 

  175. | E141-03    | PRIMARY KEY constraints                                                | |
    176. 

  176. | E141-04    | Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action | |
    177. 

  177. | E141-06    | CHECK constraints                                                      | |
    178. 

  178. | E141-07    | Column defaults                                                        | |
    179. 

  179. | E141-08    | NOT NULL inferred on PRIMARY KEY                                       | |
    180. 

  180. | E141-10    | Names in a foreign key can be specified in any order                   | |
    181. 

  181. | E151       | Transaction support                                                    | |
    182. 

  182. | E151-01    | COMMIT statement                                                       | |
    183. 

  183. | E151-02    | ROLLBACK statement                                                     | |
    184. 

  184. | E152       | Basic SET TRANSACTION statement                                        | |
    185. 

  185. | E152-01    | SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause         | |
    186. 

  186. | E152-02    | SET TRANSACTION statement: READ ONLY and READ WRITE clauses            | |
    187. 

  187. | E153       | Updatable queries with subqueries                                      | |
    188. 

  188. | E161       | SQL comments using leading double minus                                | |
    189. 

  189. | E171       | SQLSTATE support                                                       | |
    190. 

  190. | E182       | Module language                                                        | |
    191. 

  191. 

  192. F {#conformance-f}
    193. 

  193. ===
    194. 

  194. 

  195. F0 {#conformance-f0}
    196. 

  196. ---
    197. 

  197. 

  198. | Identifier | Description                                                            | Comments |
    199. 

  199. |:-----------|:-----------------------------------------------------------------------|:---------|
    200. 

  200. | F021       | Basic information schema                                               | |
    201. 

  201. | F021-01    | COLUMNS view                                                           | |
    202. 

  202. | F021-02    | TABLES view                                                            | |
    203. 

  203. | F021-03    | VIEWS view                                                             | |
    204. 

  204. | F021-04    | TABLE_CONSTRAINTS view                                                 | |
    205. 

  205. | F021-05    | REFERENTIAL_CONSTRAINTS view                                           | |
    206. 

  206. | F021-06    | CHECK_CONSTRAINTS view                                                 | |
    207. 

  207. | F031       | Basic schema manipulation                                              | |
    208. 

  208. | F031-01    | CREATE TABLE statement to create persistent base tables                | |
    209. 

  209. | F031-02    | CREATE VIEW statement                                                  | |
    210. 

  210. | F031-03    | GRANT statement                                                        | |
    211. 

  211. | F031-04    | ALTER TABLE statement: ADD COLUMN clause                               | |
    212. 

  212. | F031-13    | DROP TABLE statement: RESTRICT clause                                  | |
    213. 

  213. | F031-16    | DROP VIEW statement: RESTRICT clause                                   | |
    214. 

  214. | F031-19    | REVOKE statement: RESTRICT clause                                      | |
    215. 

  215. | F032       | CASCADE drop behavior                                                  | |
    216. 

  216. | F033       | ALTER TABLE statement: DROP COLUMN clause                              | |
    217. 

  217. | F034       | Extended REVOKE statement                                              | |
    218. 

  218. | F034-01    | REVOKE statement performed by other than the owner of a schema object  | |
    219. 

  219. | F034-02    | REVOKE statement: GRANT OPTION FOR clause                              | |
    220. 

  220. | F034-03    | REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION | |
    221. 

  221. | F041       | Basic joined table                                                     | |
    222. 

  222. | F041-01    | Inner join (but not necessarily the INNER keyword)                     | |
    223. 

  223. | F041-02    | INNER keyword                                                          | |
    224. 

  224. | F041-03    | LEFT OUTER JOIN                                                        | |
    225. 

  225. | F041-04    | RIGHT OUTER JOIN                                                       | |
    226. 

  226. | F041-05    | Outer joins can be nested                                              | |
    227. 

  227. | F041-07    | The inner table in a left or right outer join can also be used in an inner join | |
    228. 

  228. | F041-08    | All comparison operators are supported (rather than just =)            | |
    229. 

  229. | F051       | Basic date and time                                                    | |
    230. 

  230. | F051-01    | DATE data type (including support of DATE literal)                     | |
    231. 

  231. | F051-02    | TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 | |
    232. 

  232. | F051-03    | TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 | |
    233. 

  233. | F051-04    | Comparison predicate on DATE, TIME, and TIMESTAMP data types           | |
    234. 

  234. | F051-05    | Explicit CAST between datetime types and character string types        | |
    235. 

  235. | F051-06    | CURRENT_DATE                                                           | |
    236. 

  236. | F051-07    | LOCALTIME                                                              | |
    237. 

  237. | F051-08    | LOCALTIMESTAMP                                                         | |
    238. 

  238. | F052       | Intervals and datetime arithmetic                                      | |
    239. 

  239. | F053       | OVERLAPS predicate                                                     | |
    240. 

  240. | F054       | TIMESTAMP in DATE type precedence list                                 | |
    241. 

  241. | F081       | UNION and EXCEPT in views                                              | |
    242. 

  242. 

  243. F1 {#conformance-f1}
    244. 

  244. ---
    245. 

  245. 

  246. | Identifier  | Description                                                            | Comments |
    247. 

  247. |:------------|:-----------------------------------------------------------------------|:---------|
    248. 

  248. | \d{F111}    | Isolation levels other than SERIALIZABLE                               | |
    249. 

  249. | \d{F111-01} | READ UNCOMMITTED isolation level                                       | |
    250. 

  250. | \d{F111-02} | READ COMMITTED isolation level                                         | |
    251. 

  251. | \d{F111-03} | REPEATABLE READ isolation level                                        | |
    252. 

  252. | \d{F121}    | Basic diagnostics management                                           | |
    253. 

  253. | \d{F121-01} | GET DIAGNOSTICS statement                                              | |
    254. 

  254. | \d{F121-02} | SET TRANSACTION statement: DIAGNOSTICS SIZE clause                     | |
    255. 

  255. | \d{F122}    | Enhanced diagnostics management                                        | |
    256. 

  256. | \d{F123}    | All diagnostics                                                        | |
    257. 

  257. | \d{F131}    | Grouped operations                                                     | |
    258. 

  258. | \d{F131-01} | WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views | |
    259. 

  259. | \d{F131-02} | Multiple tables supported in queries with grouped views                | |
    260. 

  260. | \d{F131-03} | Set functions supported in queries with grouped views                  | |
    261. 

  261. | \d{F131-04} | Subqueries with GROUP BY and HAVING clauses and grouped views          | |
    262. 

  262. | \d{F131-05} | Single row SELECT with GROUP BY and HAVING clauses and grouped views   | |
    263. 

  263. | \d{F171}    | Multiple schemas per user                                              | |
    264. 

  264. | \d{F181}    | Multiple module support                                                | |
    265. 

  265. | \d{F191}    | Referential delete actions                                             | |
    266. 

  266. 

  267. F2 {#conformance-f2}
    268. 

  268. ---
    269. 

  269. 

  270. | Identifier | Description                                          | Comments |
    271. 

  271. |:-----------|:-----------------------------------------------------|:---------|
    272. 

  272. | F200       | TRUNCATE TABLE statement                             | |
    273. 

  273. | _F201_     | _CAST function_                                      | |
    274. 

  274. | F202       | TRUNCATE TABLE: identity column restart option       | |
    275. 

  275. | F221       | Explicit defaults                                    | |
    276. 

  276. | F222       | INSERT statement: DEFAULT VALUES clause              | |
    277. 

  277. | F231       | Privilege tables                                     | |
    278. 

  278. | F231-01    | TABLE_PRIVILEGES view                                | |
    279. 

  279. | F231-02    | COLUMN_PRIVILEGES view                               | |
    280. 

  280. | F231-03    | USAGE_PRIVILEGES view                                | |
    281. 

  281. | F251       | Domain support                                       | |
    282. 

  282. | F261       | CASE expression                                      | |
    283. 

  283. | F261-01    | Simple CASE                                          | |
    284. 

  284. | F261-02    | Searched CASE                                        | |
    285. 

  285. | F261-03    | NULLIF                                               | |
    286. 

  286. | F261-04    | COALESCE                                             | |
    287. 

  287. | F262       | Extended CASE expression                             | |
    288. 

  288. | F263       | Comma-separated predicates in simple CASE expression | |
    289. 

  289. | F271       | Compound character literals                          | |
    290. 

  290. | F281       | LIKE enhancements                                    | |
    291. 

  291. | F291       | UNIQUE predicate                                     | |
    292. 

  292. 

  293. F3 {#conformance-f3}
    294. 

  294. ---
    295. 

  295. 

  296. | Identifier | Description                                   | Comments |
    297. 

  297. |:-----------|:----------------------------------------------|:---------|
    298. 

  298. | F301       | CORRESPONDING in query expressions            | |
    299. 

  299. | F302       | INTERSECT table operator                      | |
    300. 

  300. | F302-01    | INTERSECT DISTINCT table operator             | |
    301. 

  301. | F302-02    | INTERSECT ALL table operator                  | |
    302. 

  302. | F304       | EXCEPT ALL table operator                     | |
    303. 

  303. | F311       | Schema definition statement                   | |
    304. 

  304. | F311-01    | CREATE SCHEMA                                 | [EDB-3](https://elliot.atlassian.net/browse/EDB-3) |
    305. 

  305. | _F311-02_  | _CREATE TABLE for persistent base tables_     | |
    306. 

  306. | F311-03    | CREATE VIEW                                   | |
    307. 

  307. | F311-04    | CREATE VIEW: WITH CHECK OPTION                | |
    308. 

  308. | F311-05    | GRANT statement                               | |
    309. 

  309. | F312       | MERGE statement                               | |
    310. 

  310. | F313       | Enhanced MERGE statement                      | |
    311. 

  311. | F314       | MERGE statement with DELETE branch            | |
    312. 

  312. | F321       | User authorization                            | |
    313. 

  313. | F341       | Usage tables                                  | |
    314. 

  314. | F361       | Subprogram support                            | |
    315. 

  315. | F381       | Extended schema manipulation                  | |
    316. 

  316. | F381-01    | ALTER TABLE statement: ALTER COLUMN clause    | |
    317. 

  317. | F381-02    | ALTER TABLE statement: ADD CONSTRAINT clause  | |
    318. 

  318. | F381-03    | ALTER TABLE statement: DROP CONSTRAINT clause | |
    319. 

  319. | F382       | Alter column data type                        | |
    320. 

  320. | F383       | Set column not null clause                    | |
    321. 

  321. | F384       | Drop identity property clause                 | |
    322. 

  322. | F385       | Drop column generation expression clause      | |
    323. 

  323. | F386       | Set identity column generation clause         | |
    324. 

  324. | F391       | Long identifiers                              | |
    325. 

  325. | F392       | Unicode escapes in identifiers                | |
    326. 

  326. | F393       | Unicode escapes in literals                   | |
    327. 

  327. | F394       | Optional normal form specification            | |
    328. 

  328. 

  329. F4 {#conformance-f4}
    330. 

  330. ---
    331. 

  331. 

  332. | Identifier | Description                                        | Comments |
    333. 

  333. |:-----------|:---------------------------------------------------|:---------|
    334. 

  334. | F401       | Extended joined table                              | |
    335. 

  335. | F401-01    | NATURAL JOIN                                       | |
    336. 

  336. | F401-02    | FULL OUTER JOIN                                    | |
    337. 

  337. | F401-04    | CROSS JOIN                                         | |
    338. 

  338. | F402       | Named column joins for LOBs, arrays, and multisets | |
    339. 

  339. | F403       | Partitioned joined tables                          | |
    340. 

  340. | F411       | Time zone specification                            | |
    341. 

  341. | F421       | National character                                 | |
    342. 

  342. | F431       | Read-only scrollable cursors                       | |
    343. 

  343. | F431-01    | FETCH with explicit NEXT                           | |
    344. 

  344. | F431-02    | FETCH FIRST                                        | |
    345. 

  345. | F431-03    | FETCH LAST                                         | |
    346. 

  346. | F431-04    | FETCH PRIOR                                        | |
    347. 

  347. | F431-05    | FETCH ABSOLUTE                                     | |
    348. 

  348. | F431-06    | FETCH RELATIVE                                     | |
    349. 

  349. | F441       | Extended set function support                      | |
    350. 

  350. | F442       | Mixed column references in set functions           | |
    351. 

  351. | F451       | Character set definition                           | |
    352. 

  352. | F461       | Named character sets                               | |
    353. 

  353. | F471       | Scalar subquery values                             | |
    354. 

  354. | F481       | Expanded NULL predicate                            | |
    355. 

  355. | F491       | Constraint management                              | |
    356. 

  356. | F492       | Optional table constraint enforcement              | |
    357. 

  357. 

  358. F5 {#conformance-f5}
    359. 

  359. ---
    360. 

  360. 

  361. | Identifier | Description                    | Comments |
    362. 

  362. |:-----------|:-------------------------------|:---------|
    363. 

  363. | F501       | Features and conformance views | |
    364. 

  364. | F501-01    | SQL_FEATURES view              | |
    365. 

  365. | F501-02    | SQL_SIZING view                | |
    366. 

  366. | F501-03    | SQL_LANGUAGES view             | |
    367. 

  367. | F502       | Enhanced documentation tables  | |
    368. 

  368. | F502-01    | SQL_SIZING_PROFILES view       | |
    369. 

  369. | F502-02    | SQL_IMPLEMENTATION_INFO view   | |
    370. 

  370. | F502-03    | SQL_PACKAGES view              | |
    371. 

  371. | F521       | Assertions                     | |
    372. 

  372. | F531       | Temporary tables               | |
    373. 

  373. | F555       | Enhanced seconds precision     | |
    374. 

  374. | F561       | Full value expressions         | |
    375. 

  375. | F571       | Truth value tests              | |
    376. 

  376. | F591       | Derived tables                 | |
    377. 

  377. 

  378. F6 {#conformance-f6}
    379. 

  379. ---
    380. 

  380. 

  381. | Identifier | Description                              | Comments |
    382. 

  382. |:-----------|:-----------------------------------------|:---------|
    383. 

  383. | F611       | Indicator data types                     | |
    384. 

  384. | F641       | Row and table constructors               | |
    385. 

  385. | F651       | Catalog name qualifiers                  | |
    386. 

  386. | F661       | Simple tables                            | |
    387. 

  387. | F671       | Subqueries in CHECK                      | |
    388. 

  388. | F672       | Retrospective check constraints          | |
    389. 

  389. | F690       | Collation support                        | |
    390. 

  390. | F692       | Extended collation support               | |
    391. 

  391. | F693       | SQL-session and client module collations | |
    392. 

  392. | F695       | Translation support                      | |
    393. 

  393. | F696       | Additional translation documentation     | |
    394. 

  394. 

  395. F7 {#conformance-f7}
    396. 

  396. ---
    397. 

  397. 

  398. | Identifier | Description                 | Comments |
    399. 

  399. |:-----------|:----------------------------|:---------|
    400. 

  400. | \d{F701}   | Referential update actions  | |
    401. 

  401. | \d{F711}   | ALTER domain                | |
    402. 

  402. | \d{F721}   | Deferrable constraints      | |
    403. 

  403. | \d{F731}   | INSERT column privileges    | |
    404. 

  404. | \d{F741}   | Referential MATCH types     | |
    405. 

  405. | \d{F751}   | View CHECK enhancements     | |
    406. 

  406. | \d{F761}   | Session management          | |
    407. 

  407. | \d{F762}   | CURRENT_CATALOG             | |
    408. 

  408. | \d{F763}   | CURRENT_SCHEMA              | |
    409. 

  409. | \d{F771}   | Connection management       | |
    410. 

  410. | \d{F781}   | Self-referencing operations | |
    411. 

  411. | \d{F791}   | Insensitive cursors         | |
    412. 

  412. 

  413. F8 {#conformance-f8}
    414. 

  414. ---
    415. 

  415. 

  416. | Identifier | Description                                        | Comments |
    417. 

  417. |:-----------|:---------------------------------------------------|:---------|
    418. 

  418. | F801       | Full set function                                  | |
    419. 

  419. | F812       | Basic flagging                                     | |
    420. 

  420. | F813       | Extended flagging                                  | |
    421. 

  421. | F821       | Local table references                             | |
    422. 

  422. | F831       | Full cursor update                                 | |
    423. 

  423. | F831-01    | Updatable scrollable cursors                       | |
    424. 

  424. | F831-02    | Updatable ordered cursors                          | |
    425. 

  425. | F841       | LIKE_REGEX predicate                               | |
    426. 

  426. | F842       | OCCURENCES_REGEX function                          | |
    427. 

  427. | F843       | POSITION_REGEX function                            | |
    428. 

  428. | F844       | SUBSTRING_REGEX function                           | |
    429. 

  429. | F845       | TRANSLATE_REGEX function                           | |
    430. 

  430. | F846       | Octet support in regular expression operators      | |
    431. 

  431. | F847       | Nonconstant regular expressions                    | |
    432. 

  432. | F850       | Top-level order by clause in query expression      | |
    433. 

  433. | F851       | order by clause in subqueries                      | |
    434. 

  434. | F852       | Top-level order by clause in views                 | |
    435. 

  435. | F855       | Nested order by clause in query expression         | |
    436. 

  436. | F856       | Nested fetch first clause in query expression      | |
    437. 

  437. | F857       | Top-level fetch first clause in query expression   | |
    438. 

  438. | F858       | fetch first clause in subqueries                   | |
    439. 

  439. | F859       | Top-level fetch first clause in views              | |
    440. 

  440. | F860       | fetch first row count in fetch first clause        | |
    441. 

  441. | F861       | Top-level result offset clause in query expression | |
    442. 

  442. | F862       | result offset clause in subqueries                 | |
    443. 

  443. | F863       | Nested result offset clause in query expression    | |
    444. 

  444. | F864       | Top-level result offset clause in views            | |
    445. 

  445. | F865       | offset row count in result offset clause           | |
    446. 

  446. | F866       | FETCH FIRST clause: PERCENT option                 | |
    447. 

  447. | F867       | FETCH FIRST clause: WITH TIES option               | |
    448. 

  448. 

  449. M {#conformance-m}
    450. 

  450. ===
    451. 

  451. 

  452. M0 {#conformance-m0}
    453. 

  453. ---
    454. 

  454. 

  455. | Identifier | Description                                        | Comments |
    456. 

  456. |:-----------|:---------------------------------------------------|:---------|
    457. 

  457. | \d{M001}   | Datalinks                                          | |
    458. 

  458. | \d{M002}   | Datalinks via SQL/CLI                              | |
    459. 

  459. | \d{M003}   | Datalinks via Embedded SQL                         | |
    460. 

  460. | \d{M004}   | Foreign data support                               | |
    461. 

  461. | \d{M005}   | Foreign schema support                             | |
    462. 

  462. | \d{M006}   | GetSQLString routine                               | |
    463. 

  463. | \d{M007}   | TransmitRequest                                    | |
    464. 

  464. | \d{M009}   | GetOpts and GetStatistics routines                 | |
    465. 

  465. | \d{M010}   | Foreign data wrapper support                       | |
    466. 

  466. | \d{M011}   | Datalinks via Ada                                  | |
    467. 

  467. | \d{M012}   | Datalinks via C                                    | |
    468. 

  468. | \d{M013}   | Datalinks via COBOL                                | |
    469. 

  469. | \d{M014}   | Datalinks via Fortran                              | |
    470. 

  470. | \d{M015}   | Datalinks via M                                    | |
    471. 

  471. | \d{M016}   | Datalinks via Pascal                               | |
    472. 

  472. | \d{M017}   | Datalinks via PL/I                                 | |
    473. 

  473. | \d{M018}   | Foreign data wrapper interface routines in Ada     | |
    474. 

  474. | \d{M019}   | Foreign data wrapper interface routines in C       | |
    475. 

  475. | \d{M020}   | Foreign data wrapper interface routines in COBOL   | |
    476. 

  476. | \d{M021}   | Foreign data wrapper interface routines in Fortran | |
    477. 

  477. | \d{M022}   | Foreign data wrapper interface routines in MUMPS   | |
    478. 

  478. | \d{M023}   | Foreign data wrapper interface routines in Pascal  | |
    479. 

  479. | \d{M024}   | Foreign data wrapper interface routines in PL/I    | |
    480. 

  480. | \d{M030}   | SQL-server foreign data support                    | |
    481. 

  481. | \d{M031}   | Foreign data wrapper general routines              | |
    482. 

  482. 

  483. S {#conformance-s}
    484. 

  484. ===
    485. 

  485. 

  486. S0 {#conformance-s0}
    487. 

  487. ---
    488. 

  488. 

  489. | Identifier  | Description                                    | Comments |
    490. 

  490. |:------------|:-----------------------------------------------|:---------|
    491. 

  491. | \d{S011}    | Distinct data types                            | |
    492. 

  492. | \d{S011-01} | USER_DEFINED_TYPES view                        | |
    493. 

  493. | \d{S023}    | Basic structured types                         | |
    494. 

  494. | \d{S024}    | Enhanced structured types                      | |
    495. 

  495. | \d{S025}    | Final structured types                         | |
    496. 

  496. | \d{S026}    | Self-referencing structured types              | |
    497. 

  497. | \d{S027}    | Create method by specific method name          | |
    498. 

  498. | \d{S028}    | Permutable UDT options list                    | |
    499. 

  499. | \d{S041}    | Basic reference types                          | |
    500. 

  500. | \d{S043}    | Enhanced reference types                       | |
    501. 

  501. | \d{S051}    | Create table of type                           | |
    502. 

  502. | \d{S071}    | SQL paths in function and type name resolution | |
    503. 

  503. | \d{S081}    | Subtables                                      | |
    504. 

  504. | \d{S091}    | Basic array support                            | |
    505. 

  505. | \d{S091-01} | Arrays of built-in data types                  | |
    506. 

  506. | \d{S091-02} | Arrays of distinct types                       | |
    507. 

  507. | \d{S091-03} | Array expressions                              | |
    508. 

  508. | \d{S092}    | Arrays of user-defined types                   | |
    509. 

  509. | \d{S094}    | Arrays of reference types                      | |
    510. 

  510. | \d{S095}    | Array constructors by query                    | |
    511. 

  511. | \d{S096}    | Optional array bounds                          | |
    512. 

  512. | \d{S097}    | Array element assignment                       | |
    513. 

  513. | \d{S098}    | ARRAY_AGG                                      | |
    514. 

  514. 

  515. S1 {#conformance-s1}
    516. 

  516. ---
    517. 

  517. 

  518. | Identifier | Description                      | Comments |
    519. 

  519. |:-----------|:---------------------------------|:---------|
    520. 

  520. | S111       | ONLY in query expressions        | |
    521. 

  521. | S151       | Type predicate                   | |
    522. 

  522. | S161       | Subtype treatment                | |
    523. 

  523. | S162       | Subtype treatment for references | |
    524. 

  524. 

  525. S2 {#conformance-s2}
    526. 

  526. ---
    527. 

  527. 

  528. | Identifier  | Description                       | Comments |
    529. 

  529. |:------------|:----------------------------------|:---------|
    530. 

  530. | \d{S201}    | SQL-invoked routines on arrays    | |
    531. 

  531. | \d{S201-01} | Array parameters                  | |
    532. 

  532. | \d{S201-02} | Array as result type of functions | |
    533. 

  533. | \d{S202}    | SQL-invoked routines on multisets | |
    534. 

  534. | \d{S211}    | User-defined cast functions       | |
    535. 

  535. | \d{S231}    | Structured type locators          | |
    536. 

  536. | \d{S232}    | Array locators                    | |
    537. 

  537. | \d{S233}    | Multiset locators                 | |
    538. 

  538. | \d{S241}    | Transform functions               | |
    539. 

  539. | \d{S242}    | Alter transform statement         | |
    540. 

  540. | \d{S251}    | User-defined orderings            | |
    541. 

  541. | \d{S261}    | Specific type method              | |
    542. 

  542. | \d{S271}    | Basic multiset support            | |
    543. 

  543. | \d{S272}    | Multisets of user-defined types   | |
    544. 

  544. | \d{S274}    | Multisets of reference types      | |
    545. 

  545. | \d{S275}    | Advanced multiset support         | |
    546. 

  546. | \d{S281}    | Nested collection types           | |
    547. 

  547. | \d{S291}    | Unique constraint on entire row   | |
    548. 

  548. 

  549. S3 {#conformance-s3}
    550. 

  550. ---
    551. 

  551. 

  552. | Identifier | Description     | Comments |
    553. 

  553. |:-----------|:----------------|:---------|
    554. 

  554. | \d{S301}   | Enhanced UNNEST | |
    555. 

  555. 

  556. S4 {#conformance-s4}
    557. 

  557. ---
    558. 

  558. 

  559. | Identifier | Description                            | Comments |
    560. 

  560. |:-----------|:---------------------------------------|:---------|
    561. 

  561. | S401       | Distinct types based on array types    | |
    562. 

  562. | S402       | Distinct types based on distinct types | |
    563. 

  563. | S403       | ARRAY_MAX_CARDINALITY                  | |
    564. 

  564. | S404       | TRIM_ARRAY                             | |
    565. 

  565. 

  566. T {#conformance-t}
    567. 

  567. ===
    568. 

  568. 

  569. T0 {#conformance-t0}
    570. 

  570. ---
    571. 

  571. 

  572. | Identifier | Description                                                                      | Comments |
    573. 

  573. |:-----------|:---------------------------------------------------------------------------------|:---------|
    574. 

  574. | T011       | Timestamp in Information Schema                                                  | |
    575. 

  575. | T021       | BINARY and VARBINARY data types                                                  | |
    576. 

  576. | T022       | Advanced support for BINARY and VARBINARY data types                             | |
    577. 

  577. | T023       | Compound binary literal                                                          | |
    578. 

  578. | T024       | Spaces in binary literals                                                        | |
    579. 

  579. | T031       | BOOLEAN data type                                                                | |
    580. 

  580. | T041       | Basic LOB data type support                                                      | |
    581. 

  581. | T041-01    | BLOB data type                                                                   | |
    582. 

  582. | T041-02    | CLOB data type                                                                   | |
    583. 

  583. | T041-03    | POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types | |
    584. 

  584. | T041-04    | Concatenation of LOB data types                                                  | |
    585. 

  585. | T041-05    | LOB locator: non-holdable                                                        | |
    586. 

  586. | T042       | Extended LOB data type support                                                   | |
    587. 

  587. | T043       | Multiplier T                                                                     | |
    588. 

  588. | T044       | Multiplier P                                                                     | |
    589. 

  589. | T051       | Row types                                                                        | |
    590. 

  590. | T052       | MAX and MIN for row types                                                        | |
    591. 

  591. | T053       | Explicit aliases for all-fields reference                                        | |
    592. 

  592. | T061       | UCS support                                                                      | |
    593. 

  593. | T071       | BIGINT data type                                                                 | |
    594. 

  594. 

  595. T1 {#conformance-t1}
    596. 

  596. ---
    597. 

  597. 

  598. | Identifier | Description                                       | Comments |
    599. 

  599. |:-----------|:--------------------------------------------------|:---------|
    600. 

  600. | T101       | Enhanced nullability determination                | |
    601. 

  601. | T111       | Updatable joins, unions, and columns              | |
    602. 

  602. | T121       | WITH (excluding RECURSIVE) in query expression    | |
    603. 

  603. | T122       | WITH (excluding RECURSIVE) in subquery            | |
    604. 

  604. | T131       | Recursive query                                   | |
    605. 

  605. | T132       | Recursive query in subquery                       | |
    606. 

  606. | T141       | SIMILAR predicate                                 | |
    607. 

  607. | T151       | DISTINCT predicate                                | |
    608. 

  608. | T152       | DISTINCT predicate with negation                  | |
    609. 

  609. | T171       | LIKE clause in table definition                   | |
    610. 

  610. | T172       | AS subquery clause in table definition            | |
    611. 

  611. | T173       | Extended LIKE clause in table definition          | |
    612. 

  612. | T174       | Identity columns                                  | |
    613. 

  613. | T175       | Generated columns                                 | |
    614. 

  614. | T176       | Sequence generator support                        | |
    615. 

  615. | T177       | Sequence generator support: simple restart option | |
    616. 

  616. | T178       | Identity columns: simple restart option           | |
    617. 

  617. | T180       | System-versioned tables                           | |
    618. 

  618. | T181       | Application-time period tables                    | |
    619. 

  619. | T191       | Referential action RESTRICT                       | |
    620. 

  620. 

  621. T2 {#conformance-t2}
    622. 

  622. ---
    623. 

  623. 

  624. | Identifier  | Description                                                            | Comments |
    625. 

  625. |:------------|:-----------------------------------------------------------------------|:---------|
    626. 

  626. | \d{T201}    | Comparable data types for referential constraints                      | |
    627. 

  627. | \d{T211}    | Basic trigger capability                                               | |
    628. 

  628. | \d{T211-01} | Triggers activated on UPDATE, INSERT, or DELETE of one base table      | |
    629. 

  629. | \d{T211-02} | BEFORE triggers                                                        | |
    630. 

  630. | \d{T211-03} | AFTER triggers                                                         | |
    631. 

  631. | \d{T211-04} | FOR EACH ROW triggers                                                  | |
    632. 

  632. | \d{T211-05} | Ability to specify a search condition that must be true before the trigger is invoked | |
    633. 

  633. | \d{T211-06} | Support for run-time rules for the interaction of triggers and constraints | |
    634. 

  634. | \d{T211-07} | TRIGGER privilege                                                      | |
    635. 

  635. | \d{T211-08} | Multiple triggers for the same event are executed in the order in which they were created in the catalog | |
    636. 

  636. | \d{T212}    | Enhanced trigger capability                                            | |
    637. 

  637. | \d{T213}    | INSTEAD OF triggers                                                    | |
    638. 

  638. | \d{T231}    | Sensitive cursors                                                      | |
    639. 

  639. | \d{T241}    | START TRANSACTION statement                                            | |
    640. 

  640. | \d{T251}    | SET TRANSACTION statement: LOCAL option                                | |
    641. 

  641. | \d{T261}    | Chained transactions                                                   | |
    642. 

  642. | \d{T271}    | Savepoints                                                             | |
    643. 

  643. | \d{T272}    | Enhanced savepoint management                                          | |
    644. 

  644. | \d{T281}    | SELECT privilege with column granularity                               | |
    645. 

  645. | \d{T285}    | Enhanced derived column names                                          | |
    646. 

  646. 

  647. T3 {#conformance-t3}
    648. 

  648. ---
    649. 

  649. 

  650. | Identifier | Description                                         | Comments |
    651. 

  651. |:-----------|:----------------------------------------------------|:---------|
    652. 

  652. | T301       | Functional dependencies                             | |
    653. 

  653. | T312       | OVERLAY function                                    | |
    654. 

  654. | T321       | Basic SQL-invoked routines                          | |
    655. 

  655. | T321-01    | User-defined functions with no overloading          | |
    656. 

  656. | T321-02    | User-defined stored procedures with no overloading  | |
    657. 

  657. | T321-03    | Function invocation                                 | |
    658. 

  658. | T321-04    | CALL statement                                      | |
    659. 

  659. | T321-05    | RETURN statement                                    | |
    660. 

  660. | T321-06    | ROUTINES view                                       | |
    661. 

  661. | T321-07    | PARAMETERS view                                     | |
    662. 

  662. | T322       | Declared data type attributes                       | |
    663. 

  663. | T323       | Explicit security for external routines             | |
    664. 

  664. | T324       | Explicit security for SQL routines                  | |
    665. 

  665. | T325       | Qualified SQL parameter references                  | |
    666. 

  666. | T326       | Table functions                                     | |
    667. 

  667. | T331       | Basic roles                                         | |
    668. 

  668. | T332       | Extended roles                                      | |
    669. 

  669. | T341       | Overloading of SQL-invoked functions and procedures | |
    670. 

  670. | T351       | Bracketed SQL comments                              | |
    671. 

  671. 

  672. T4 {#conformance-t4}
    673. 

  673. ---
    674. 

  674. 

  675. | Identifier | Description                           | Comments |
    676. 

  676. |:-----------|:--------------------------------------|:---------|
    677. 

  677. | T431       | Extended grouping capabilities        | |
    678. 

  678. | T432       | Nested and concatenated GROUPING SETS | |
    679. 

  679. | T433       | Multiargument GROUPING function       | |
    680. 

  680. | T434       | GROUP BY DISTINCT                     | |
    681. 

  681. | T441       | ABS and MOD functions                 | |
    682. 

  682. | T461       | Symmetric BETWEEN predicate           | |
    683. 

  683. | T471       | Result sets return value              | |
    684. 

  684. | T472       | DESCRIBE CURSOR                       | |
    685. 

  685. | T491       | LATERAL derived table                 | |
    686. 

  686. | T495       | Combined data change and retrieval    | |
    687. 

  687. 

  688. T5 {#conformance-t5}
    689. 

  689. ---
    690. 

  690. 

  691. | Identifier | Description                                                | Comments |
    692. 

  692. |:-----------|:-----------------------------------------------------------|:---------|
    693. 

  693. | T501       | Enhanced EXISTS predicate                                  | |
    694. 

  694. | T502       | Period predicates                                          | |
    695. 

  695. | T511       | Transaction counts                                         | |
    696. 

  696. | T521       | Named arguments in CALL statement                          | |
    697. 

  697. | T522       | Default values for IN parameters of SQL-invoked procedures | |
    698. 

  698. | T541       | Updatable table references                                 | |
    699. 

  699. | T551       | Optional key words for default syntax                      | |
    700. 

  700. | T561       | Holdable locators                                          | |
    701. 

  701. | T571       | Array-returning external SQL-invoked functions             | |
    702. 

  702. | T572       | Multiset-returning external SQL-invoked functions          | |
    703. 

  703. | T581       | Regular expression substring function                      | |
    704. 

  704. | T591       | UNIQUE constraints of possibly null columns                | |
    705. 

  705. 

  706. T6 {#conformance-t6}
    707. 

  707. ---
    708. 

  708. 

  709. | Identifier | Description                                      | Comments |
    710. 

  710. |:-----------|:-------------------------------------------------|:---------|
    711. 

  711. | \d{T601}   | Local cursor references                          | |
    712. 

  712. | \d{T611}   | Elementary OLAP operations                       | |
    713. 

  713. | \d{T612}   | Advanced OLAP operations                         | |
    714. 

  714. | \d{T613}   | Sampling                                         | |
    715. 

  715. | \d{T614}   | NTILE function                                   | |
    716. 

  716. | \d{T615}   | LEAD and LAG functions                           | |
    717. 

  717. | \d{T616}   | Null treatment option for LEAD and LAG functions | |
    718. 

  718. | \d{T617}   | FIRST_VALUE and LAST_VALUE function              | |
    719. 

  719. | \d{T618}   | NTH_VALUE function                               | |
    720. 

  720. | \d{T619}   | Nested window functions                          | |
    721. 

  721. | \d{T620}   | WINDOW clause: GROUPS option                     | |
    722. 

  722. | \d{T621}   | Enhanced numeric functions                       | |
    723. 

  723. | \d{T631}   | IN predicate with one list element               | |
    724. 

  724. | \d{T641}   | Multiple column assignment                       | |
    725. 

  725. | \d{T651}   | SQL-schema statements in SQL routines            | |
    726. 

  726. | \d{T652}   | SQL-dynamic statements in SQL routines           | |
    727. 

  727. | \d{T653}   | SQL-schema statements in external routines       | |
    728. 

  728. | \d{T654}   | SQL-dynamic statements in external routines      | |
    729. 

  729. | \d{T655}   | Cyclically dependent routines                    | |
    730. 

  730. 

  731. X {#conformance-x}
    732. 

  732. ===
    733. 

  733. 

  734. X0 {#conformance-x0}
    735. 

  735. ---
    736. 

  736. 

  737. | Identifier | Description                                                      | Comments |
    738. 

  738. |:-----------|:-----------------------------------------------------------------|:---------|
    739. 

  739. | \d{X010}   | XML type                                                         | |
    740. 

  740. | \d{X011}   | Arrays of XML type                                               | |
    741. 

  741. | \d{X012}   | Multisets of XML type                                            | |
    742. 

  742. | \d{X013}   | Distinct types of XML type                                       | |
    743. 

  743. | \d{X014}   | Attributes of XML type                                           | |
    744. 

  744. | \d{X015}   | Fields of XML type                                               | |
    745. 

  745. | \d{X016}   | Persistent XML values                                            | |
    746. 

  746. | \d{X020}   | XMLConcat                                                        | |
    747. 

  747. | \d{X025}   | XMLCast                                                          | |
    748. 

  748. | \d{X030}   | XMLDocument                                                      | |
    749. 

  749. | \d{X031}   | XMLElement                                                       | |
    750. 

  750. | \d{X032}   | XMLForest                                                        | |
    751. 

  751. | \d{X034}   | XMLAgg                                                           | |
    752. 

  752. | \d{X035}   | XMLAgg: ORDER BY option                                          | |
    753. 

  753. | \d{X036}   | XMLComment                                                       | |
    754. 

  754. | \d{X037}   | XMLPI                                                            | |
    755. 

  755. | \d{X038}   | XMLText                                                          | |
    756. 

  756. | \d{X040}   | Basic table mapping                                              | |
    757. 

  757. | \d{X041}   | Basic table mapping: nulls absent                                | |
    758. 

  758. | \d{X042}   | Basic table mapping: null as nil                                 | |
    759. 

  759. | \d{X043}   | Basic table mapping: table as forest                             | |
    760. 

  760. | \d{X044}   | Basic table mapping: table as element                            | |
    761. 

  761. | \d{X045}   | Basic table mapping: with target namespace                       | |
    762. 

  762. | \d{X046}   | Basic table mapping: data mapping                                | |
    763. 

  763. | \d{X047}   | Basic table mapping: metadata mapping                            | |
    764. 

  764. | \d{X048}   | Basic table mapping: base64 encoding of binary strings           | |
    765. 

  765. | \d{X049}   | Basic table mapping: hex encoding of binary strings              | |
    766. 

  766. | \d{X050}   | Advanced table mapping                                           | |
    767. 

  767. | \d{X051}   | Advanced table mapping: nulls absent                             | |
    768. 

  768. | \d{X052}   | Advanced table mapping: null as nil                              | |
    769. 

  769. | \d{X053}   | Advanced table mapping: table as forest                          | |
    770. 

  770. | \d{X054}   | Advanced table mapping: table as element                         | |
    771. 

  771. | \d{X055}   | Advanced table mapping: target namespace                         | |
    772. 

  772. | \d{X056}   | Advanced table mapping: data mapping                             | |
    773. 

  773. | \d{X057}   | Advanced table mapping: metadata mapping                         | |
    774. 

  774. | \d{X058}   | Advanced table mapping: base64 encoding of binary strings        | |
    775. 

  775. | \d{X059}   | Advanced table mapping: hex encoding of binary strings           | |
    776. 

  776. | \d{X060}   | XMLParse: Character string input and CONTENT option              | |
    777. 

  777. | \d{X061}   | XMLParse: Character string input and DOCUMENT option             | |
    778. 

  778. | \d{X065}   | XMLParse: BLOB input and CONTENT option                          | |
    779. 

  779. | \d{X066}   | XMLParse: BLOB input and DOCUMENT option                         | |
    780. 

  780. | \d{X068}   | XMLSerialize: BOM                                                | |
    781. 

  781. | \d{X069}   | XMLSerialize: INDENT                                             | |
    782. 

  782. | \d{X070}   | XMLSerialize: Character string serialization and CONTENT option  | |
    783. 

  783. | \d{X
    784.