Reported By: Shawn Van Riper Reported On: 11/30/2003 For: Version 4.00 Build 1
# 1464Executing SQL SELECT with an ORDER BY on Primary Key Causes 8965 Index Page Buffers Corrupt Error Performing a SQL select and ordering by the primary key, after the last record is deleted from a table produces the error:
DBISAM Engine Error # 8965 Index page buffers corrupt in the table 'GROUPS'
DROP TABLE IF EXISTS "GROUPS";
CREATE TABLE IF NOT EXISTS "GROUPS"
(
"GROUPID" AUTOINC,
"GROUPNAME" CHARACTER(50) NOT NULL,
PRIMARY KEY ("GROUPID")
);
INSERT INTO GROUPS(GROUPNAME) VALUES ('TEST');
DELETE FROM GROUPS;
SELECT * FROM GROUPS ORDER BY GROUPID;
ResolutionFixed Problem on 12/3/2003 in version 4.01 build 1