Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Say that the recursive part of a CTE may not use aggregate or window functions. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | branch-3.25 |
Files: | files | file ages | folders |
SHA3-256: |
cf2f8cbd8f1953e37c6c62c1f4ea6265 |
User & Date: | drh 2018-09-27 13:06:38.224 |
Context
2018-10-03
| ||
12:59 | Add documentation for missing result codes. (check-in: 76e1292157 user: drh tags: branch-3.25) | |
2018-09-27
| ||
13:06 | Say that the recursive part of a CTE may not use aggregate or window functions. (check-in: cf2f8cbd8f user: drh tags: branch-3.25) | |
12:56 | Say that the recursive part of a CTE may not use aggregate or window functions. (check-in: aa1202143a user: drh tags: trunk) | |
2018-09-26
| ||
19:52 | Fix a formatting error in the rtree.html document. (check-in: 3b812913fe user: drh tags: branch-3.25) | |
Changes
Changes to pages/lang.in.
︙ | ︙ | |||
3653 3654 3655 3656 3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 | <ol> <li> The "[select-stmt]" must be a [compound select] where the right-most [compound-operator] is either UNION or UNION ALL. <li> The table named on the left-hand side of the AS keyword must appear exactly once in the FROM clause of the right-most SELECT statement of the compound select, and nowhere else. </ol> <p>To put it another way, a recursive common table expression must look like the following: <tcl>RecursiveBubbleDiagram recursive-cte</tcl> | > > | 3653 3654 3655 3656 3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 3667 3668 | <ol> <li> The "[select-stmt]" must be a [compound select] where the right-most [compound-operator] is either UNION or UNION ALL. <li> The table named on the left-hand side of the AS keyword must appear exactly once in the FROM clause of the right-most SELECT statement of the compound select, and nowhere else. <li> The right-most SELECT of the compound select must not make use of [Aggregate Functions|aggregate] or [window functions]. </ol> <p>To put it another way, a recursive common table expression must look like the following: <tcl>RecursiveBubbleDiagram recursive-cte</tcl> |
︙ | ︙ |