OK, there's definite meat, here. I have other reports of users seeing this problem. It's specifically related to doing UPDATE against an fts1 or fts2 table. INSERT and DELETE both work fine. As far as I can tell, UPDATE may have never worked, or may have worked only in specific circumstances. More as it's available.
-scott On 1/12/07, ohadp <[EMAIL PROTECTED]> wrote:
looks like the file came in without CRLF, here goes: ------------------------------------------------------------------------------------------ #include "../sqlite-3_3_8/sqlite3.h" #include <tchar.h> static sqlite3* db; void exec_dml(const TCHAR* cmd) { sqlite3_stmt* vm; sqlite3_prepare16(db, cmd, -1, &vm, 0); sqlite3_step(vm); sqlite3_finalize(vm); } void exec_query(const TCHAR* cmd) { sqlite3_stmt* vm; sqlite3_prepare16(db, cmd, -1, &vm, 0); if (sqlite3_step(vm) == SQLITE_ROW) { TCHAR* result = (TCHAR*)sqlite3_column_text16(vm, 0); result=result; } sqlite3_finalize(vm); } int _tmain(int argc, _TCHAR* argv[]) { sqlite3_open16(_T("test.db"), &db); exec_dml(_T("CREATE VIRTUAL TABLE t USING fts1(content);")); exec_dml(_T("INSERT INTO t (rowid, content) VALUES (1, 'this is a test');")); exec_query(_T("SELECT content FROM t WHERE rowid = 1;")); exec_dml(_T("UPDATE t SET content = 'that was a test' WHERE rowid = 1;")); exec_query(_T("SELECT content FROM t WHERE rowid = 1;")); return 0; } ------------------------------------------------------------------------------------------ -- View this message in context: http://www.nabble.com/3.3.10-data-corruption-on-updating-fts1-string-table-tf2960926.html#a8305111 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------