[firebird-support] corrupted table or record?

[Bart Smissaert]

Firebird 1.5 on Windows, accessed via ODBC.
Have a large table (some 50 million records) with the following structure:

CREATE TABLE AUDIT_TRAIL
(
  AUDIT_ID                 INTEGER         NOT NULL,
  AUDIT_TIME                  DATE,
  USER_ID                  VARCHAR(    12)  COLLATE NONE,
  TABLE_ID                SMALLINT,
  ACTION                  SMALLINT,
  PRIMARY_KEY              VARCHAR(   128)  COLLATE NONE,
  DATA                     VARCHAR(  5000)  COLLATE NONE,
  PATIENT_ID               INTEGER
);

When I run this query via ODBC:

select
*
from
audit_trail
where
audit_id >= 46262765

The query will hang and I need to kill the app.

I have figured out that the problem is with one record with AUDIT_ID 46270901.

This suspicion is based on the following:

select
*
from
audit_trail
where
(audit_id >= 46262765 and
audit_id <= 46270900) or
audit_id >= 46270902

This will run fine.

select
*
from
audit_trail
where
(audit_id >= 46262765 and
audit_id < 46270901) or
audit_id > 46270901

This will hang/crash.

If I run these queries in Workbench it will run fine, but the record
with AUDIT_ID 46270901 will not show.
In this table all AUDIT_ID's are consecutive, except for this 46270901
that is either missing or I think corrupt.

Is this normal behaviour?
Could this record be fixed?
Thanks for any insight.


RBS