Re: [sqlite] sqlite3.8.7 crashes when creating an index with WAL mode disabled

>Perhaps this could be caught at compile time. The process that creates >the amalgamation could add a preprocessor macro defining e.g. >_SQLITE_AMALGAMATION_. The SQLITE_OMIT_* macros could test for that >definition and #pragma error if found. I think there is a much easier solution. Since

Re: [sqlite] sqlite3.8.7 crashes when creating an index with WAL mode disabled

On Tue, 4 Nov 2014 12:06:35 + Simon Davies wrote: > > And watch as it crashes when creating the index. > > From https://www.sqlite.org/compile.html: > > Important Note: The SQLITE_OMIT_* options do not work with the > amalgamation or with pre-packaged C code

Re: [sqlite] sqlite3.8.7 crashes when creating an index with WAL mode disabled

On 4 November 2014 04:17, RP McMurphy wrote: > Consider the following build cmd line: > > gcc -o sqlite3.exe -DSQLITE_OMIT_WAL sqlite3.c shell.c > > The build succeeds when using MinGW on Windows. > > Now start the built exe with a memory database: > > sqlite3

[sqlite] sqlite3.8.7 crashes when creating an index with WAL mode disabled

Consider the following build cmd line: gcc -o sqlite3.exe -DSQLITE_OMIT_WAL sqlite3.c shell.c The build succeeds when using MinGW on Windows. Now start the built exe with a memory database: sqlite3 :memory: And execute the following query: create table v(y);