Icon View Incident Report

Serious Serious
Reported By: Shawn Van Riper
Reported On: 11/30/2003
For: Version 4.00 Build 1
# 1464 Executing 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;



Resolution Resolution
Fixed Problem on 12/3/2003 in version 4.01 build 1
Image