Re: [sqlite] FTS3, UPDATE of one column: why are all columns affected?

This turned out to be a bug in my code. I apologize. Yaroslav -- View this message in context: http://www.nabble.com/FTS3%2C-UPDATE-of-one-column%3A-why-are-all-columns-affected--tp20036520p20039068.html Sent from the SQLite mailing list archive at Nabble.com. _

[sqlite] FTS3, UPDATE of one column: why are all columns affected?

Hi All, I am using an FTS3 virtual table with multiple columns. This works very well, until I try to do an UPDATE on _one_ of the columns in the vtable. In that case, the other columns are cleared. After looking into the FTS3 code, I discovered that the columns in the original SQL statement are