SQLite

View Ticket
Login
Ticket Hash: c276ee2e4eca7dcdbad3b6b2b3e5bd356b1e416e
Title: null should not be allowed in primary key
Status: Closed Type: Feature_Request
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Wont_Fix
Last Modified: 2014-03-11 13:10:44
Version Found In:
Description:
SQLite allows nulls in primary keys but should not.  This bug has been present for a long time and not immediately fixed because it could break existing databases.  The behaviour has been documented as might be fixed at some point.  This ticket is for that fix,

[http://www.sqlite.org/cvstrac/tktview?tn=518]
User Comments:
drh added on 2014-03-11 13:10:44: (text/x-fossil-wiki)
This is documented non-comformance.  Cannot fix without breaking legacy.