Documentation Source Text

Check-in [8a0206bb29]
Login

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

Overview
Comment:Further enhancements to the Quirks document.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:8a0206bb291e011d2b76245f7f7329eb8c0db2568e73d0bef477abdb64ceea6f
User & Date: drh 2018-11-28 10:21:37
Context
2018-11-28
14:59
Update the speed-and-size spreadsheet with the latest performance numbers. check-in: 71c9a6d2b0 user: drh tags: trunk
10:21
Further enhancements to the Quirks document. check-in: 8a0206bb29 user: drh tags: trunk
10:08
Fix a typo on the quirks.html page. check-in: dd1def55d8 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/omitted.in.

     4      4   
     5      5   <p>
     6      6   SQLite implements most of the common features of SQL.
     7      7   Rather than try to list all the features of SQL that SQLite does
     8      8   support, it is much easier to list those that it does not.
     9      9   Unsupported features of SQL are shown below.</p>
    10     10   
           11  +<p>
           12  +See also the
           13  +[Quirks|Quirks, Caveats, and Gotchas] of SQLite.
           14  +
    11     15   <table cellpadding="10">
    12     16   
    13     17   <tcl>
    14     18   proc feature {name desc} {
    15     19     hd_puts "<tr><td valign=\"top\"><b><nobr>$name</nobr></b></td>"
    16     20     hd_puts "<td width=\"10\">&nbsp;</th>"
    17     21     hd_puts "<td valign=\"top\">$desc</td></tr>"

Changes to pages/quirks.in.

     1      1   <title>Quirks, Caveats, and Gotchas In SQLite</title>
     2      2   <tcl>hd_keywords {Quirks}</tcl>
     3      3   
     4      4   <table_of_contents>
     5      5   
     6      6   <h1>Overview</h1>
     7      7   
     8         -<center><font color="red" size=6><b>
     9         -This document is a work in progress.
    10         -</b></font>
    11         -</center>
    12         -
    13      8   <p>
    14      9   The SQL language is a "standard".
    15     10   Even so, no two SQL database engines work exactly alike.
    16     11   Every SQL implementation has it own peculiarities and oddities,
    17     12   and SQLite is no exception to this rule.
    18     13   
    19     14   <p>
................................................................................
   292    287   This used to be considered good design - that a system would accept
   293    288   dodgy inputs and try to do the best it could without complaining too much.
   294    289   But lately, people have come to realize that it is sometimes better to
   295    290   be strict in what you accept, so as to more easily find errors in the
   296    291   input.
   297    292   <p>
   298    293   
   299         -
   300    294   <h1>AUTOINCREMENT Does Not Work The Same As MySQL</h1>
          295  +
          296  +<p>The [AUTOINCREMENT] feature in SQLite works differently than
          297  +it does in MySQL.  This often causes confusion for people who
          298  +initially learned SQL on MySQL and then start using SQLite, and
          299  +expect the two systems to work identically.
          300  +
          301  +<p>See the [AUTOINCREMENT|SQLite AUTOINCREMENT documentation] for
          302  +detailed instructions on what AUTOINCREMENT does and does not do
          303  +in SQLite.