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

Reply via email to