Re: [sqlite] Pragma notnull for integer primary keys?

2018-08-15 Thread Richard Hipp
On 8/7/18, Dirkjan Ochtman wrote: > > If INTEGER PRIMARY KEYs are always NOT NULL, I'd reasonably expect that it > will be `notnull` even if NOT NULL is not explicitly specified. Is this a > bug? I don't think so. INTEGER PRIMARY KEYs have another magic property in that if you insert a NULL

Re: [sqlite] Pragma notnull for integer primary keys?

2018-08-15 Thread Dirkjan Ochtman
Ping -- I thought this might be a bug. Can someone confirm or explain why it's not? Regards, Dirkjan On Tue, Aug 7, 2018 at 7:34 AM Dirkjan Ochtman wrote: > Yesterday I started a new project with SQLite. I wanted to create some > simple integer-based primary keys and used an ORM to generate

[sqlite] Pragma notnull for integer primary keys?

2018-08-07 Thread Dirkjan Ochtman
Yesterday I started a new project with SQLite. I wanted to create some simple integer-based primary keys and used an ORM to generate code. I then noticed that the primary keys were generated as Nullable types. I asked on Gitter and someone pointed me to this bit of documentation: "According to