Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

2018-05-20 Thread Abroży Nieprzełoży
I'm not working on anything specific, just experimenting, so you don't have to rush :) 2018-05-20 21:53 GMT+02:00, Richard Hipp: > Thank you for the bug report. > > I agree that this is a problem that needs to be fixed, and it will be > fixed before the next release. However, the problem arises

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

2018-05-20 Thread Richard Hipp
Thank you for the bug report. I agree that this is a problem that needs to be fixed, and it will be fixed before the next release. However, the problem arises in a part of the code where we must move cautiously to avoid a performance regression. Further, your specific problem suggests an entire

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

2018-05-20 Thread Graham Holden
> The documentation says: > **"Warning: misuse of this pragma can easily result in a corrupt database > file."** But it would be nice if corrupted database didn't crash the application ;) If the database is (or appears) corrupted, terminating immediately or "crashing" is probably the only

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

2018-05-20 Thread Abroży Nieprzełoży
btw 'PRAGMA integrity_check;' returns 'ok' 2018-05-20 18:27 GMT+02:00, Abroży Nieprzełoży : >> The documentation says: >> **"Warning: misuse of this pragma can easily result in a corrupt database >> file."** > > But it would be nice if corrupted database didn't crash the application ;) > > > >

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

2018-05-20 Thread Abroży Nieprzełoży
> The documentation says: > **"Warning: misuse of this pragma can easily result in a corrupt database > file."** But it would be nice if corrupted database didn't crash the application ;) 2018-05-20 16:05 GMT+02:00, Clemens Ladisch : > Abroży Nieprzełoży wrote: >> sqlite> PRAGMA

Re: [sqlite] Potential issue for date function when given Julian days in the range 999BC to 1BC

2018-05-20 Thread Clemens Ladisch
Inderjit Gill wrote: > When the date function is given a date between 999BC and 1BC ... The documentation says: | These functions only work for dates between -01-01 00:00:00 and | -12-31 23:59:59 (julidan day numbers 1721059.5 through 5373484.5). | For dates outside that range, the

Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.

2018-05-20 Thread Clemens Ladisch
Abroży Nieprzełoży wrote: > sqlite> PRAGMA writable_schema=1; The documentation says: **"Warning: misuse of this pragma can easily result in a corrupt database file."** > sqlite> CREATE TABLE xqlite_sequence(name TEXT PRIMARY KEY, seq INTEGER) > WITHOUT ROWID; SQLite does not use SQL but raw

Re: [sqlite] R*Tree / In Memory Database / GUI Object Hit Testing

2018-05-20 Thread Clemens Ladisch
Robert M. Münch wrote: > I’m wondering if the R*Tree index of Sqlite could be used to implement > GUI object hit testing? Yes, that would be possible. > We could populate a r*tree table with (runtime-object-memory-pointer, > x0, y0, x1, y0) pretty easy. Now the user clicks the mouse somewhere, >