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. |
|---|---|
| Timelines: | family | ancestors | descendants | both | branch-3.25 |
| Files: | files | file ages | folders |
| SHA3-256: | cf2f8cbd8f1953e37c6c62c1f4ea6265948529be640a2f9c48c6cfd0d4a2da1f |
| User & Date: | drh 2018-09-27 13:06:38 |
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>
|