[sqlite] FTS4 content table

Hi according to the documentation - 6.2.2. External Content FTS4 Tables An "external content" FTS4 table is similar to a contentless table, except that if evaluation of a query requires the value of a column other than docid, FTS4 attempts to retrieve that value from a table (or view, or virtual

Re: [sqlite] BUG: UPDATE with correlated sub-query

Thanks Dan I couldn't find a reference to this behaviour in the documentation. Do you think it would be possible to add a few words? On Mon, Feb 13, 2017 at 7:49 PM Dan Kennedy <danielk1...@gmail.com> wrote: > On 02/13/2017 01:44 PM, Dudu Markovitz wrote: > > Good mornin

[sqlite] BUG: UPDATE with correlated sub-query

mments added are in bug_reports.txt. I'm using SQLite 3.9.2 on windows 64 bit. Thanks Dudu Markovitz .mode column .header on .echo on select sqlite_version() ; create table mytable (id int,group_id int,IsHeader int,active int) ; insert into mytable (id,group_id,IsHeader,active) values (1,1