Compile time options used: sqlite3 application (shell):
gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -Isqlite3/src -Isqlite3/ext/rtree -Isqlite3/ext/icu -Isqlite3/ext/fts3 -Isqlite3/ext/async -Isqlite3/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DSQLITE_HAS_CODEC=1 -DSQLITE_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_DEFAULT_FOREIGN_KEYS=1 -DSQLITE_USE_URI=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_USE_DECIMAL2=1 -DSQLITE_ENABLE_STAT4=1 -DCODEC_TYPE=CODEC_TYPE_AES2562 -DSQLITE_SOUNDEX=1 -DSQLITE_ENABLE_EXTENSION_FUNCTIONS=1 -DSQLITE_OMIT_PREPARED=1 -DSQLITE_ENABLE_SESSION=1 -DNDEBUG -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_OMIT_PREPARED=1 -DSQLITE_ENABLE_SESSION -DSQLITE_ENABLE_PREUPDATE_HOOK -DSQLITE_SMALL_STACK=1 -DHAVE_READLINE=0 -DHAVE_EDITLINE=1 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_EXPLAIN_COMMENTS -o sqlite3 sqlite3/src/shell.c sqlite3.c -ledit -ldl -lpthread -lm -Wl,-rpath -Wl,/usr/local/lib ? My application: gcc -Wall -fno-strict-aliasing -DSQ_ENABLE_INCLUDES=1 -DSQ_USE_MKSTEMP=1 -DSQ_USE_LOCALTIME_R=1 -DONLY_ASCII=1 -DPROFILE_SQVM0=1 -DSQ_JIT_LLVM44=1 -D_DEBUG_DUMP33=1 -DWITH_DAD_EXTRAS=1 -DSQ_SUBLATIN=1 -DNEED_SUBLATIN_C2=1 -DSQUSEDOUBLE=1 -DSQUSEDECIMAL64x=1 -DNO_EXCEPTION_KEY_NOT_FOUND0=1 -DNO_GARBAGE_COLLECTOR00=1 -DTHREADSAFE=1 -DSQLITE_DEFAULT_FILE_FORMAT=4 -DSQLITE_DEFAULT_AUTOVACUUM=1 -DSQLITE_DEFAULT_FOREIGN_KEYS=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_EXTENSION_FUNCTIONS=1 -DSQLITE_ENABLE_FTS4=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_STAT4=1 -DSQLITE_HAS_CODEC=1 -DSQLITE_OMIT_TCL_VARIABLE=1 -DSQLITE_USE_URI=1 -DSQLITE_SOUNDEX=1 -DSQLITE_OMIT_PREPARED=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE_ENABLE_SESSION=1 -DSQLITE_ENABLE_EXPLAIN_COMMENTS=1 -DNO_POPEN=1 -DNO_SSL_DL=1 -DHAVE_STDINT=1 -DUSE_AXTLS=1 -DUSE_OPENSSL2=1 -DUSE_AXTLS_ON_MEMORY=1 -D_FILE_OFFSET_BITS=64 -DSSL_STATIC_LIBRARY=1 -DPDF_USING_ZLIB=1 -DRS232_STATIC=1 -DWITH_UUID=1 -DWITH_FFI=1 -DWITH_POSTGRESQL=1 -DWITH_LIBCLANG=1 -DWITH_MPDECIMAL=1 -DSQ_USE_EASYCURL=1 -fomit-frame-pointer -fexpensive-optimizations -O3 -Wall -DWITH_FLTK=1 -DNDEBUG=1 -DWITH_FULL_DAD_EXTRAS=1 -DPROFILE_SQVM22=1 -D_SQ64=1 -DCONFIG_64=1 -DHAS_UNIX_DOMAIN_SOCKETS=1 -DUSE_SIGNAL_HANDLER=1 -DWITH_MYSQL=1 -DWITH_POSTGRESQL=1 -DWITH_DNS_SD2=1 -Iinclude -Isqstdlib -I../myaxtls -I../discount -I../../../local/postgresql/include -I/usr/lib/jvm/default-java/include -I/usr/lib/llvm-3.1/include -I../SquiLu-ext/threadObject -I.. -I../SquiLu-ext -I/usr/include/mysql -I../gumbo -I../minizip -I../unql/src -I../../../local/clang-3.6/include -I../../../local/include -I../../zeromq-3.2.2/include -I../fltk -I../libharu/include -I../flu -c SquiLu/SquiLu-ext/sqlite3.c -o obj/Release/SquiLu-ext/sqlite3.o ? ? > Mon Apr 04 2016 10:59:17 AM CEST from "Simon Slavin" ><slavins at bigfraud.org> Subject: Re: [sqlite] Difference between sqlite3 >executable and application > > On 4 Apr 2016, at 9:53am, Domingo Alvarez Duarte ><sqlite-mail at dev.dadbiz.es> wrote: > > >>What compile time options if any can cause this ? >> > I recommend you compare the results of > > PRAGMA compile_options; > > on the two platforms. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?