> 1a.- Delete the previous table.
> DROP TABLE IF EXIST ftsm
> This scheme work ok with the FST3/4 modules, but compiling with FTS5 gives an
> erroro in 1a: "database disk image is malformed".
> Note that in previous attemps I believed that the problem was into try to
> delete a ftsm table
On 12/10/2015 05:15 AM, ajm at zator.com wrote:
> Hi list:
> In a C++ Windows app that uses SQLite v. 3.9.1 and behaves well, I try change
> the search engine from FTS3/4 modules to FTS5, by means off:
> 1. Define the directive
> #define SQLITE_ENABLE_FTS5 1
> 2.- Create the table:
> Mensaje original
> De: Dan Kennedy
> Para: sqlite-users at mailinglists.sqlite.org
> Fecha: Fri, 11 Dec 2015 02:41:43 +0700
> Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to FTS5
>> 1a.- Delete the pr
In a C++ Windows app that uses SQLite v. 3.9.1 and behaves well, I try change
the search engine from FTS3/4 modules to FTS5, by means off:
1. Define the directive
#define SQLITE_ENABLE_FTS5 1
2.- Create the table:
CREATE VIRTUAL TABLE ftsm USING fts5(nm,tokenize='porter unicode61
> Mensaje original
> De: Richard Hipp
>Fecha: 4/11/2015 23:23 (GMT+01:00)
>Para: SQLite mailing list
>Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to FTS5 modules
>Here is a hack.
>Let the name of your FTS3 table be "xyzzy"
Using SQLite 3.9.1, suppose a C++ application using FTS3/4 modules with this
1a In config.h
#define SQLITE_ENABLE_FTS3 1
#define SQLITE_ENABLE_FTS3_PARENTHESIS 1
2a.- Delete the previous table if exist
DROP TABLE IF EXISTS ftsm
3a.- Then create the table
On 11/4/15, ajm at zator.com wrote:
> The question: do is there any method to delete the old table without
> including the FTS3/4 modules to those users "in the field"?
Here is a hack.
Let the name of your FTS3 table be "xyzzy"
(1) Invoke "PRAGMA writable_schema=ON". (Read the documentation
Mail list logo