> Your views had problem that manifests with certain data only.
> If recreating views helped, it means that either
> - the new view definitions are not identical to old ones, or
> - original view was created under different conditions,
> i.e. either different dialect or character set
>
> Can you compare BLR of new and old views ? (if you still have it)

I could perhaps do that - I'll check. But I can assure that if there was any
difference in conditions, it's one that I have no influence about (that is,
as far as I know, the new definitions are identical to the old ones and
dialect and character sets are the same as well).

Pepak