Documentation Source Text

Check-in [cf2f8cbd8f]
Login

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: cf2f8cbd8f1953e37c6c62c1f4ea6265948529be640a2f9c48c6cfd0d4a2da1f
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
Unified Diff Ignore Whitespace Patch
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>