Re: [sqlite] 3.3.10 data corruption on updating fts1 string table

[ohadp]

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