OK, Thank you. Meanwhile (again) I check that PRAGMA integrity_check='yes' did not disable TEXT NOT NULL. Is that a bug in 3.8.8.3?
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:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA integrity_check On 11 Sep 2015, at 12:32am, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote: > 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? I can't think of one. I would argue that in SQLite4 (or some future version of SQLite3) "PRAGMA integrity_check" should check constraints as well as consistency. Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users