[sqlite] System.Data.SQLite version 1.0.97.0 released

2015-05-26 Thread Joe Mistachkin
System.Data.SQLite version 1.0.97.0 (with SQLite 3.8.10.2) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

[sqlite] [BUG?] BEFORE INSERT trigger has NEW.pk = -1 when NULL is passed for PK

2015-05-26 Thread Tomash Brechko
2015-05-25 15:27 GMT+03:00 Richard Hipp : > > https://www.sqlite.org/mark/lang_createtrigger.html?Cautions+val*ger.#mark > Missed that. Thanks! -- Tomash Brechko

[sqlite] NOT EXISTS and LEFT JOIN Performance problem

2015-05-26 Thread shadowma...@yahoo.de
>>SELECT * FROM ART WHERE ID IN (SELECT docid FROM OCR WHERE FullText MATCH >>'mailing') Thnak You Clemens that's excellent. KR, Marta -Original Message- From: Clemens Ladisch Sent: Monday, May 25, 2015 9:59 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] NOT