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 in a part
> of the code where we must move cautiously to avoid a performance
> regression. Further, your specific problem suggests an entire new
> class of problems that need to be investigated and carefully tested.
> So fixing this will take some time.
>
> The bug has been in the code since version 3.8.7 (2014-10-17). I
> think you can wait a few days for the fix.
>
>
>
> On 5/19/18, Abroży Nieprzełoży <abrozynieprzelozy314...@gmail.com> 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
>> c6071ac99cfa4b6272ac4d739fc61a85acb544f6c1c2ae67b31e92aadcc995bd
>> zlib version 1.2.11
>> msvc-1912
>> sqlite> CREATE TABLE xqlite_sequence(name TEXT PRIMARY KEY, seq
>> INTEGER) WITHOUT ROWID;
>> sqlite> INSERT INTO xqlite_sequence VALUES('ttt', 1);
>> sqlite> PRAGMA writable_schema=1;
>> sqlite> UPDATE sqlite_master SET name='sqlite_sequence',
>> tbl_name='sqlite_sequence', sql='CREATE TABLE sqlite_sequence(name
>> TEXT PRIMARY KEY, seq INTEGER) WITHOUT ROWID' WHERE
>> name='xqlite_sequence';
>> sqlite> .exit
>>
>> C:\test>sqlite3 test.db
>> SQLite version 3.24.0 2018-05-18 17:58:33
>> Enter ".help" for usage hints.
>> sqlite> CREATE TABLE ttt(id INTEGER PRIMARY KEY AUTOINCREMENT, data TEXT);
>> sqlite> .exit
>>
>> C:\test>sqlite3 test.db
>> SQLite version 3.24.0 2018-05-18 17:58:33
>> Enter ".help" for usage hints.
>> sqlite> INSERT INTO ttt(data) VALUES('xx');
>>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
