Documentation Source Text

Check-in [77ea14504b]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Change the syntax diagrams to require a GROUP BY prior to a HAVING clause. CVSTrac ticket #3516.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 77ea14504b2516ce8889c9a19e5e2486c0873ab9
User & Date: drh 2008-12-03 14:52:10
Context
2008-12-09
22:49
Break out the requirements text into separate ASCII text files in the req/ folder. Requirements are now in a format suitable for use with qabot. Requirements information is no longer automatically extracted from sqlite3.h or fileformat.in. Changes to requirements must be manually entered. (check-in: e76f948793 user: drh tags: trunk)
2008-12-03
14:52
Change the syntax diagrams to require a GROUP BY prior to a HAVING clause. CVSTrac ticket #3516. (check-in: 77ea14504b user: drh tags: trunk)
2008-11-26
17:51
Update the documentation for a 3.6.6.2 branch release. (check-in: fa3ffc5811 user: drh tags: trunk)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to art/syntax/bubble-generator.tcl.

315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
  select-stmt {
     stack
       {loop
          {indentstack
             {line SELECT {or nil DISTINCT ALL} {loop result-column ,}}
             {optx FROM join-source}
             {optx WHERE expr}
             {optx GROUP BY {loop ordering-term ,}}
             {optx HAVING expr}
          } compound-operator
       }
       {optx ORDER BY {loop ordering-term ,}}
       {optx LIMIT /integer {optx {or OFFSET ,} /integer}}
        
  }
  result-column {







|
<







315
316
317
318
319
320
321
322

323
324
325
326
327
328
329
  select-stmt {
     stack
       {loop
          {indentstack
             {line SELECT {or nil DISTINCT ALL} {loop result-column ,}}
             {optx FROM join-source}
             {optx WHERE expr}
             {optx GROUP BY {loop ordering-term ,} {optx HAVING expr}}

          } compound-operator
       }
       {optx ORDER BY {loop ordering-term ,}}
       {optx LIMIT /integer {optx {or OFFSET ,} /integer}}
        
  }
  result-column {

Changes to art/syntax/select-stmt.gif.

cannot compute difference between binary files