Re: 'Clever' behaviour

In article <4qolps$87g@epimetheus.algonet.se>, Mike Johnson <mikehunt@so phocles.algonet.se> writes >If you query against a char index field with an integer, Informix >(5.03) tries to be 'clever' and convert your char index to an integer >index in a desparate attempt to satisfy the query. > >The biggest problem with this is the amount of time that it takes >to do this. (Longer than a sequential scan would take!) > >My question is: Does anyone know how to turn off this feature? I would >rather the server says 'not found' if an application accidently >were to perform such a query. > >Mike. > Not possible - it is fundamental to the way Informix worked - always try to convert types if possible. -- David Williams