Hi Keith, thanks for the suggestion.
Regards, Hartwig > Am 2018-06-13 um 00:26 schrieb Keith Medcalf <kmedc...@dessus.com>: > > > You can replace the "Inf" with 1e400 and -Inf with -1e400. These values will > be parsed and stored as the appropriate plus/minus Infinity since they are > larger than the maximum representable IEEE-754 Double Precision Binary Float. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > > >> -----Original Message----- >> From: sqlite-users [mailto:sqlite-users- >> boun...@mailinglists.sqlite.org] On Behalf Of skywind mailing lists >> Sent: Tuesday, 12 June, 2018 16:06 >> To: SQLite mailing list >> Subject: [sqlite] How to convert SQL file into database when a column >> value is Inf? >> >> Hi, >> >> I issued the following commands: >> >> echo .dump | sqlite3 Database.sldb > D.sldb >> sqlite3 -init D.sldb NewDatabase.sldb >> >> Unfortunately, reading the SQL file produced the following error: >> Error: near line 56721: no such column: Inf >> >> The corresponding SQL command is: >> INSERT INTO "Flights" >> VALUES(36,80,1470395806,'','','',NULL,0.0,0,0,0,0,0.0,-Inf,0.0,- >> Inf,0.0,- >> Inf,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL >> ,NULL,4,0,''); >> >> OK, it seems to be that the column values are not really correct (- >> Inf) but I would still like to do the conversion. Is there a >> command/trick in sqlite3 that makes it work? >> >> A workaround is of course to use a text editor and try to find and >> replace all occurrences of Inf or -Info. >> >> Regards, >> Hartwig >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
