On 12/07/2012 11:17 PM, Alexey Pechnikov wrote:
What does the following:
SELECT * FROM view_address_exists WHERE rowid=64402;
sqlite>SELECT "sys_title:hash" FROM view_address_exists WHERE
rowid=64402;
"sys_title:hash"
e9b4d0bcb5
But what does "SELECT * FROM ..." return? According to
> What does the following:
>
> SELECT * FROM view_address_exists WHERE rowid=64402;
>
sqlite> SELECT "sys_title:hash" FROM view_address_exists WHERE
rowid=64402;
"sys_title:hash"
e9b4d0bcb5
About documented "When a row is deleted from an external content FTS4
table, FTS4 needs
to retrieve
On 12/07/2012 06:17 PM, Alexey Pechnikov wrote:
"insert or replace" doesn't trigger updating of the FTS index but only
'rebuild' do it:
sqlite> .s address_fts0
CREATE VIRTUAL TABLE "address_fts0" USING
fts4(content="view_address_exists", "sys_title:hash");
sqlite> select
"insert or replace" doesn't trigger updating of the FTS index but only
'rebuild' do it:
sqlite> .s address_fts0
CREATE VIRTUAL TABLE "address_fts0" USING
fts4(content="view_address_exists", "sys_title:hash");
sqlite> select rowid,"sys_title:hash" from address_fts0 where
"sys_title:hash" match
4 matches
Mail list logo