/ Check-in [e05f52d9]
Login

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

Overview
Comment:Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e05f52d907e267b4f9ea204427229e7d7ef58641
User & Date: drh 2004-11-16 23:21:57
Context
2004-11-17
10:22
Extra tests and resulting bugfixes for btree cursors. (CVS 2106) check-in: e1530854 user: danielk1977 tags: trunk
2004-11-16
23:21
Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) check-in: e05f52d9 user: drh tags: trunk
15:50
Perform deletes in a single pass. (CVS 2104) check-in: a2e1c35b user: danielk1977 tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/lang.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the sqlite.html file.
     3      3   #
     4         -set rcsid {$Id: lang.tcl,v 1.76 2004/11/11 01:50:30 danielk1977 Exp $}
            4  +set rcsid {$Id: lang.tcl,v 1.77 2004/11/16 23:21:57 drh Exp $}
     5      5   source common.tcl
     6      6   header {Query Language Understood by SQLite}
     7      7   puts {
     8      8   <h2>SQL As Understood By SQLite</h2>
     9      9   
    10     10   <p>The SQLite library understands most of the standard SQL
    11     11   language.  But it does <a href="omitted.html">omit some features</a>
................................................................................
  1233   1233   If a NOT NULL constraint violation occurs, the NULL value is replaced
  1234   1234   by the default value for that column.  If the column has no default
  1235   1235   value, then the ABORT algorithm is used.</p>
  1236   1236   
  1237   1237   <p>When this conflict resolution strategy deletes rows in order to
  1238   1238   satisfy a constraint, it does not invoke delete triggers on those
  1239   1239   rows.  But that may change in a future release.</p>
         1240  +</dl>
  1240   1241   
  1241   1242   <p>The algorithm specified in the OR clause of a COPY, INSERT, or UPDATE
  1242   1243   overrides any algorithm specified in a CREATE TABLE or CREATE INDEX.
  1243   1244   If no algorithm is specified anywhere, the ABORT algorithm is used.</p>
  1244         -
  1245   1245   }
  1246   1246   # <p>For additional information, see 
  1247   1247   # <a href="conflict.html">conflict.html</a>.</p>
  1248   1248   
  1249   1249   Section REPLACE replace
  1250   1250   
  1251   1251   Syntax {sql-statement} {
................................................................................
  1344   1344   returned in the result.  A negative LIMIT indicates no upper bound.
  1345   1345   The optional OFFSET following LIMIT specifies how many
  1346   1346   rows to skip at the beginning of the result set.
  1347   1347   In a compound query, the LIMIT clause may only appear on the
  1348   1348   final SELECT statement.
  1349   1349   The limit is applied to the entire query not
  1350   1350   to the individual SELECT statement to which it is attached.
         1351  +Note that if the OFFSET keyword is used in the LIMIT clause, then the
         1352  +limit is the first number and the offset is the second number.  If a
         1353  +comma is used instead of the OFFSET keyword, then the offset is the
         1354  +first number and the limit is the second number.  This seeming
         1355  +contradition is intentional - it maximizes compatibility with legacy
         1356  +SQL database systems.
  1351   1357   </p>
  1352   1358   
  1353   1359   <p>A compound SELECT is formed from two or more simple SELECTs connected
  1354   1360   by one of the operators UNION, UNION ALL, INTERSECT, or EXCEPT.  In
  1355   1361   a compound SELECT, all the constituent SELECTs must specify the
  1356   1362   same number of result columns.  There may be only a single ORDER BY
  1357   1363   clause at the end of the compound SELECT.  The UNION and UNION ALL