Documentation Source Text

Check-in [aa1202143a]
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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:aa1202143a9549ce2c76768458b6c5a6f7fc000a631a301d80311f0fc3a57b76
User & Date: drh 2018-09-27 12:56:00
Context
2018-09-28
17:08
Add documentation for the geopoly_regular() function. check-in: 7804034c38 user: drh tags: trunk
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
15:19
Merge changes from the 3.25 branch. check-in: 2e3a732177 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs 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>