> 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 the column values of the row being deleted from the content table.". I think that "insert or replace" is broken because we can't update external table in middle of the "insert or replace" command execution (after the old record complete deletion from FTS table and before the new record insertion into FTS table). May be is more reasonable to make the content of FTS table synchronized with the content of external table by FTS extension internally? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users