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
