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]
-----------------------------------------------------------------------------
