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|
|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|
|18:57||Caution users to have well-defined column names in VIEWs. check-in: 5a0203cdca user: drh tags: trunk|
Changes to pages/quirks.in.
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>