On 4 November 2014 04:17, RP McMurphy <rpm0...@yahoo.com> 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 :memory: > > And execute the following query: > > create table v(y); > with recursive cnt(x) as (select 1 union all select x+1 from cnt > limit 100000) > insert into v select * from cnt; > create index w on v(y); > > 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 files. SQLITE_OMIT_* compile-time options only work correctly when SQLite is built from canonical source files. Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users