[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

On 11/06/2015 12:36 PM, chromedout64 at yahoo.com wrote: > I noticed that this update is not included in the official 3.9.2 release. How > is it determined when an update such as this one gets included in a release? > Thanks for any info. Most likely as part of 3.10.0. You can always download t

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

Great, that's exactly what I need, I'll give it a try.

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

I noticed that this update is not included in the official 3.9.2 release. How is it determined when an update such as this one gets included in a release? Thanks for any info.

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

On 10/27/2015 05:06 PM, chromedout64 at yahoo.com wrote: > Using the example from the documentation at https://www.sqlite.org/fts5.html > I thought this worked in a previous version. > > CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c); > CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', >

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

Thanks for fixing it, Dan. Do you know when this will be rolled into an official or preliminary autoconf file? Thanks again.

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

This is on v3.9.1. I'm not sure exactly when it stopped working. I was using the external content functionality with triggers to keep the virtual table updated as part of a larger program, but found that the referenced example from the docs exhibits the same issue. INSERT's work fine, but REPLAC

[sqlite] FTS5 External Content Table - REPLACE - SQL logic error or missing database

Using the example from the documentation at https://www.sqlite.org/fts5.html I thought this worked in a previous version. CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c); CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', content_rowid='a'); CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN