Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-13 Thread Simon Slavin
On 13 Jun 2018, at 9:44pm, skywind mailing lists wrote: > The operation system is iOS (therefore, it is difficult to remove the battery > and do several tests after each other) (First paragraph is background for others reading this message.) An iOS application which is running is supposed to

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-13 Thread skywind mailing lists
Hi Ryan, I just became aware that I might give synchronisation level 3 a chance (currently the level is 1, default setting). I was not aware of this setting since a couple of minutes ago. Otherwise, the database is in serialised threading mode, though only one thread is accessing it. The

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-13 Thread R Smith
On 2018/06/13 6:35 PM, skywind mailing lists wrote: Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. Alright, but this implies a very serious flaw in SQLite, so mind if we double-check some things?

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-13 Thread Dennis Clarke
On 06/13/2018 12:35 PM, skywind mailing lists wrote: Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. I have been watching this from a distance and all I can think is : 1) what do you mean

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-13 Thread skywind mailing lists
Hi Ryan, my problem is that I use the "most safest" mode that exists for SQLite and it still fails… Therefore, I need to know why it fails. Regards, Hartwig > Am 2018-06-13 um 01:23 schrieb R Smith : > > > On 2018/06/13 12:21 AM, skywind mailing lists wrote: >> Hi, >> >> the original

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread R Smith
On 2018/06/13 12:21 AM, skywind mailing lists wrote: Hi, the original database is malformed. So, I cannot access it anymore besides doing a dump. There is currently no known way to read this since Inf and -Inf are not recognized as floats but in stead look like identifiers. Perhaps this is

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread skywind mailing lists
Hi Keith, thanks for the suggestion. Regards, Hartwig > Am 2018-06-13 um 00:26 schrieb Keith Medcalf : > > > 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

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread Keith Medcalf
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

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread skywind mailing lists
Hi, the original database is malformed. So, I cannot access it anymore besides doing a dump. Regards, Hartwig > Am 2018-06-13 um 00:17 schrieb Bob Friesenhahn : > > On Wed, 13 Jun 2018, skywind mailing lists wrote: >> >> A workaround is of course to use a text editor and try to find and

Re: [sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread Bob Friesenhahn
On Wed, 13 Jun 2018, skywind mailing lists wrote: A workaround is of course to use a text editor and try to find and replace all occurrences of Inf or -Info. Can you use update queries on the original database to change the Inf and -Inf values to huge positive or negative values that sqlite

[sqlite] How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread skywind mailing lists
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"