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 opera

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 by

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 databas

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
rs [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? >> >>

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

2018-06-12 Thread Keith Medcalf
ject: [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 fo

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 repla

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" VALUES(36