Re: [sqlite] sqlite3 .dump file does not recreate database

2012-04-21 Thread Jay A. Kreibich
On Sat, Apr 21, 2012 at 02:07:17PM -0700, Kyle McKay scratched on the wall: > Is there some way to modify only the SQLite3 shell's .dump utility > to use 17g when dumping IEEE754 values (leaving all the other > behavior unchanged)? Not easily. Last time I checked, the shell uses

Re: [sqlite] sqlite3 .dump file does not recreate database

2012-04-21 Thread Simon Slavin
On 21 Apr 2012, at 10:07pm, Kyle McKay wrote: > Is there some way to modify only the SQLite3 shell's .dump utility to use 17g > when dumping IEEE754 values (leaving all the other behavior unchanged)? The source to the shell tool is included in the full (not amalgamated)

[sqlite] sqlite3 .dump file does not recreate database

2012-04-21 Thread Kyle McKay
The "Error: near line 10: column val is not unique" output is unexpected when loading the created .dump file. This session demonstrates the issue: $ /tmp/sqlite3 SQLite version 3.7.11 2012-03-20 11:35:50 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> SELECT