[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Database file with a nonstandard sqlite_seuence schema causes crash.
From:       Richard Hipp <drh () sqlite ! org>
Date:       2018-05-23 17:58:15
Message-ID: CALwJ=MyNw=pHaqZwjwbF+EAxcpKjpYf59=X7jdZUUqrBNbfdLw () mail ! gmail ! com
[Download RAW message or body]

Now fixed on trunk.  The ticket is here:
https://www.sqlite.org/src/info/d8dc2b3a58cd5dc2918a1d4a

On 5/19/18, Abroży Nieprzełoży <abrozynieprzelozy314159@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
drh@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]