We have a report that implements the below sub-query concept:
select...
from Fact A
where
A.Date in (select max(date) from Fact A)
This was implemented in Dev, tested and promoted to QA and all the way to Prod. There were some environment (cognos + ODBC.ini + hot-fixes) changes implemented in Dev that has caused this to fail. The QA and Prod versions are working fine. We are still trying to figure out what change is causing this issue but it is proving to be too difficult and this issue is also holding up promotion of the fixes to other environments. But it is very strange that any environment change can cause this to break.
Has anyone else faced this issue?