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.
>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?
>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"
>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.
>sqlite-users mailing list
sqlite-users mailing list