Thanks for your answer, Nuno. However, the system I am using is already 64-bit (I should have mentioned that) , and the same binary can do the job on another Ubuntu 64-bit system. I'll try your suggestion nevertheless, but can there be other causes? Rense
> It's what the thread says. The SQLite shell on Ubuntu (on 11.04) isn't > compiled with large file support on 32-bit systems, so while the > SQLite library does work with 64-bit database, the shell doesn't. > The easy solution is to either use a 64-bit Ubuntu system or compile > the shell yourself with large file support. > > To compile it, download the sqlite amalgamation files and run: > > gcc -o sqli -O3 -DNDEBUG=1 -D_FILE_OFFSET_BITS=64 sqlite3.c shell.c > -ldl -pthread > > The resulting binary (sqli) will be compiled with large file support > (I verified it was using strace). > > > Regards, > ~Nuno Lucas > > P.S.- While this could be considered an Ubuntu bug, the truth is that > the linux shell binary on the sqlite site also isn't compiled with > large file support, so I would consider this an SQLite bug. > > > ------------------------------ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users