Hi list, I observed that the Sqlite shell is not able to read it own dump files, in case a column contains the real value INF (infinity). I would expect that the shell would always be able to read any dump file it produced itself.
Sqlite version is 3.7.15. Below a small sqlite script and its output to show te issue: CREATE TABLE test (r REAL); INSERT INTO test VALUES (1e999); -- stores +infinity INSERT INTO test VALUES (-1e999); -- stores -infinty .dump test -- write to file .output dump.sql .dump .output stdout -- read back from file DROP TABLE test; .read dump.sql Output: PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE test (r REAL); INSERT INTO "test" VALUES(Inf); INSERT INTO "test" VALUES(-Inf); COMMIT; Error: near line 4: no such column: Inf Error: near line 5: no such column: Inf --- Rob Golsteijn _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
