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