Could not get result if querying on an indexed column

[pengzhang]

Hi there,

I'm currently working on Informix 9.21TC5 on Windows 2000 machine. I have a program (written in E/SQL) to load all text files into a Informix database.

I found several times that after re-loading, I could get the data output from SQLEditor if I do a full table scan like &quot;select * from <TableName>&quot; without any &quot;where&quot; clause or query a table based on a non-indexed column. But I could not get any output data if querying a table based on an indexed column like &quot;Select * from <TableName> where <IndexedColumn> = <KeyValue>&quot;.

The re-loading logic is as following:
1) Drop all constraints (including indexes)
2) Remove all record from all tables;
3) Load data into tables
4) Re-create all constraints (including indexes)

If I dropped the database, and re-create all the tables and do that again, the problem would disappear.

I checked the Informix error log, nothing abnormal there. Seemed to me something wrong with the index pages. I tried to drop index on a particular table and re-create it in SQLEditor, it didn't help.

Does someone here have any idea?

Thanks

pengzhang