Documentation Source Text

Check-in [83da33aabc]
Login

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

Overview
Comment:Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:83da33aabcfadc5e94578d53be63ac9e96b4dbb6630800002f8327a258b8a1cc
User & Date: drh 2019-01-09 19:54:23
Context
2019-01-22
20:59
Clean up links in the arch.html and opcode.html documents. check-in: ea5ed63f07 user: drh tags: trunk
2019-01-09
19:56
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. check-in: fd152b335d user: drh tags: branch-3.26
19:54
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. check-in: 83da33aabc user: drh tags: trunk
2018-12-14
19:01
Fix typos in the defense-against-dark-arts document. check-in: 94ad3e51e7 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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

   276    276               }
   277    277        }
   278    278        {line {optx {optx NOT} EXISTS} ( select-stmt )}
   279    279        {line CASE {optx expr} {loop {line WHEN expr THEN expr} {}}
   280    280              {optx ELSE expr} END}
   281    281        {line raise-function}
   282    282        {line /window-func ( {or {line {toploop expr ,}} {} *} ) 
   283         -           {opt filter} OVER {or {line ( window-defn )} /window-name}}
          283  +           {opt filter} OVER {or window-defn /window-name}}
   284    284     }
   285    285     raise-function {
   286    286        line RAISE ( 
   287    287              {or IGNORE
   288    288                  {line {or ROLLBACK ABORT FAIL} , /error-message }
   289    289              } )
   290    290     }
................................................................................
   521    521         {line /* {loop nil /anything-except-*/}
   522    522              {or */ /end-of-input}}
   523    523     }
   524    524     filter {
   525    525       line FILTER ( WHERE expr )
   526    526     }
   527    527     window-defn {
   528         -    line {opt PARTITION BY {loop expr ,}}
   529         -         {opt ORDER BY {loop ordering-term ,}}
   530         -         {opt frame-spec}
          528  +    stack {line ( {opt PARTITION BY {loop expr ,}}}
          529  +          {opt ORDER BY {loop ordering-term ,}}
          530  +          {line {optx frame-spec} )}
   531    531     }
   532    532     frame-spec {
   533    533       line {or RANGE ROWS} {or
   534    534          {line BETWEEN {or {line UNBOUNDED PRECEDING}
   535    535                            {line expr PRECEDING}
   536    536                            {line CURRENT ROW}
   537    537                            {line expr FOLLOWING}
................................................................................
   550    550       }
   551    551     }
   552    552     function-invocation {
   553    553        line /function-name ( {or {line {optx DISTINCT} {toploop expr ,}} {} *} )
   554    554     }
   555    555     window-function-invocation {
   556    556       line /window-func ( {or {line {toploop expr ,}} {} *} ) 
   557         -         {opt filter} OVER {or {line ( window-defn )} /window-name}
          557  +         {opt filter} OVER {or window-defn /window-name}
   558    558     }
   559    559   }

Changes to art/syntax/expr.gif.

cannot compute difference between binary files

Changes to art/syntax/frame-spec.gif.

cannot compute difference between binary files

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

cannot compute difference between binary files

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

cannot compute difference between binary files

Changes to art/syntax/window-defn.gif.

cannot compute difference between binary files

Changes to art/syntax/window-function-invocation.gif.

cannot compute difference between binary files