Thank you, Simon. Meanwhile, I tested if PRAGMA integrity_check checks column constraints. You can bump up 90% of being sure it does not to 100%. It does not. Is there a way to do it, other than export the data out and try to re-insert it?
Roman ________________________________________ From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Thursday, September 10, 2015 7:28 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA integrity_check On 11 Sep 2015, at 12:04am, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote: > I wanted to check the behavior and set up a test database. I use (for now) > SQLite 3.8.8.3 and discovered that setting ignore_check_constraints = 'yes' > did not disable INT PRIMARY KEY NOT NULL constraint on a column. Is that > expected? Yeah. That's expected. The INT PRIMARY KEY is a special case. It makes up its own number. I forget what it does if you explicitly supply NULL as a value but it is a special case. Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users