Hi,
Using PySQLite 2.0.4 I get a crash with the following sequence, starting
from no database. If the page_size pragma is removed it works OK.
Reproducible under Windows 2K and XP. Running Python 2.4.1.
pragma short_column_names=0
pragma full_column_names=0
PRAGMA page_size = 8192
CREATE TABLE Versions (sVersions Primary Key)
INSERT INTO Versions (sVersions) VALUES ('NMUkO6Wev0IOhWL/WLPPiGRl
')
SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'Versions'
SELECT * FROM Versions
CREATE TABLE General (sValue Text DEFAULT '',sType Text DEFAULT '',
PRIMARY KEY
(sType))
SELECT * FROM Versions
DELETE FROM Versions
INSERT INTO Versions (sVersions) VALUES
('7WPylc1+LISbvuZMsrmvnWQ3OkdlbmVyYWxkMT
oxaTRlZWU=
')
DELETE FROM Versions
INSERT INTO Versions (sVersions) VALUES
('7WPylc1+LISbvuZMsrmvnWQ3OkdlbmVyYWxkMT
oxaTRlZWU=
')
SELECT sType, sValue FROM General WHERE sType = '_LastLogin'
Assertion failed: &pPage->aData[pPage->pBt->pageSize]==(unsigned
char*)pPage, file btree.c, line 1166
This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.
Other failure reports include:
Assertion failed: n==4-4*pPage->leaf, file btree.c, line 601
Assertion failed: pPage->leaf==0 || pPage->leaf==1, file btree.c, line 599
Hugh Gibson
