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.
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

  3653   3653   <ol>
  3654   3654   <li> The "[select-stmt]"
  3655   3655        must be a [compound select] where the right-most [compound-operator] is
  3656   3656        either UNION or UNION ALL.
  3657   3657   <li> The table named on the left-hand side of the AS keyword must appear
  3658   3658        exactly once in the FROM clause of the right-most SELECT statement
  3659   3659        of the compound select, and nowhere else.
         3660  +<li> The right-most SELECT of the compound select must not make use of
         3661  +     [Aggregate Functions|aggregate] or [window functions].
  3660   3662   </ol>
  3661   3663   
  3662   3664   <p>To put it another way, a recursive common table expression must
  3663   3665   look like the following:
  3664   3666   
  3665   3667   <tcl>RecursiveBubbleDiagram recursive-cte</tcl>
  3666   3668