Now fixed on trunk. The ticket is here:
https://www.sqlite.org/src/info/d8dc2b3a58cd5dc2918a1d4a
On 5/19/18, Abroży Nieprzełoży wrote:
> C:\test>sqlite3 test.db
> SQLite version 3.24.0 2018-05-18 17:58:33
> Enter ".help" for usage hints.
> sqlite> .version
> SQLite 3.24.0 2018-05-18 17:58:33
> c
This crash (bus error) also occurs when the experiment is done the
other way around. A standard sqlite3_sequence table is then renamed
and no longer exists as such. And it will not reappear..
It is generous that a pragma writable_schema lets us do these
experiments.
$ rm test.db; sqlite3 t
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
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 n
> 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 safe
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 ;)
>
>
>
> 20
> 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 writable_schema
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 V
C:\test>sqlite3 test.db
SQLite version 3.24.0 2018-05-18 17:58:33
Enter ".help" for usage hints.
sqlite> .version
SQLite 3.24.0 2018-05-18 17:58:33
c6071ac99cfa4b6272ac4d739fc61a85acb544f6c1c2ae67b31e92aadcc995bd
zlib version 1.2.11
msvc-1912
sqlite> CREATE TABLE xqlite_sequence(name TEXT PRIMARY K
9 matches
Mail list logo