Frag elimination Bug ? Workaround ?

Has anyone seen this problem and do you know of a workaround? Sun 6000e, Solaris 2.6 Informix 7.24.uc4 Fragmenting a table across 58 dbspaces.(carrying 13 mos of weekly data which will roll-off each weekl). Fragmenting by expression on the first column which is a date. This is what happens: select * from table_areturns correct results, seq scans all frags select * from table_a where inv_dte = '03/31/97'returns no rows found, seq scans frag 58 select * from table_a where inv_dte = '04/07/97'returns no rows found, seq scans frag 58 select * from table_a where inv_dte in ('03/31/97', '04/07/97')returns correct results, seq scans frags 1,2 select * from table_a where inv_dte in ('03/31/97', '03/31/97')returns correct results, seq scans frag 1 select * from table_a where inv_dte in ('03/31/97')returns no rows found, seq scans frag 58 Have tried these queries with and without indexes getting same results. PDQ settings also have no effect. Any suggestions? Barry Leb barryleb@atl.mindspring.com