-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 27/01/12 20:45, Antony wrote: > Did I miss any arguments in the ".dump" command to dump the database > successfully?
Putting aside the wisdom of structuring a table this way, you did indeed hit a problem in the SQLite code to dump a table. The .dump command emits the SQL for the table definition and then has this error: /**** ERROR: (1) Expression tree is too large (maximum depth 1000) *****/ Then it emits a ROLLBACK. This is because of the code used to do a dump. The SQLite shell concocts a select statement behind the scenes whose results are the needed insert statement (function dump_callback in the source) and it is the parsing of that that causes the error. If the dump code just iterated over the table directly outputting each value itself then things would work just fine. Added a ticket: http://www.sqlite.org/src/info/232637c465 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8kSdcACgkQmOOfHg372QTH3QCfQUV5Ilz4YNOivf3gLky2FBcs QlwAoJB/roeWs1qHQczxOUt7WKcXSIfd =cQyn -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
