-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Walter Dnes wrote: > Am I making some glaring noob error here?
The most likely cause is that the SQLite shell was compiled without support for large files. (The SQLite library itself has large files on by default but the shell is separately compiled code.) The shell uses the fopen standard library function to open the CSV file. You can find out what the error is by looking for a "cannot open file" error print in shell.c and adding 'perror(NULL);' as the previous line. You can recompile the shell setting the flags (-D or #define): _LARGE_FILE, _FILE_OFFSET_BITS=64 and _LARGEFILE_SOURCE Alternatively use split to make the input a series of files each less than 4GB in size. Or use a 64 bit host. I've added a ticket to the tracker about the error reporting: http://www.sqlite.org/src/info/3671265894 If using a file smaller than 4GB fixes the issue for you then please let me know and I'll add a ticket about large file support too. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAksQi2IACgkQmOOfHg372QTlvQCgvpLhykiAcbZFWxnY5+TSYG4A FuQAoImQ2UPQhoCz5yrn6BLxOPeHkuKc =8JXy -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
