Documentation Source Text

Check-in [dd1def55d8]

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

Comment:Fix a typo on the quirks.html page.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
User & Date: drh 2018-11-28 10:08:08
Further enhancements to the Quirks document. check-in: 8a0206bb29 user: drh tags: trunk
Fix a typo on the quirks.html page. check-in: dd1def55d8 user: drh tags: trunk
Caution users to have well-defined column names in VIEWs. check-in: 5a0203cdca user: drh tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/

   158    158   the [PRAGMA foreign_keys] statement.  Or, foreign key enforcement can
   159    159   be activated at compile-time using the
   160    160   [-DSQLITE_DEFAULT_FOREIGN_KEYS=1] compile-time option.
   161    161   
   162    162   <h1>PRIMARY KEYs Can Sometimes Contain NULLs</h1>
   163    163   
   164    164   <p>
   165         -Usually (the exceptions are [INTEGER PRIMARY KEY] tables 
          165  +Usually (the exceptions are [INTEGER PRIMARY KEY] tables and
   166    166   [WITHOUT ROWID] tables) a PRIMARY KEY in an SQLite table is really
   167    167   the same as a UNIQUE constraint.  Due to an historical oversight,
   168    168   the column values of such a PRIMARY KEY are allowed to be NULL.
   169    169   This is a bug, but by the time the problem was discovered there
   170    170   where so many databases in circulation that depended on the bug that
   171    171   the decision was made to support the bugging behavior moving forward.
   172    172   <p>