Query having FIRST_ROWS(1) hint is not returning results on 11.2.0.1.0
We have a problem with the following query:
SELECT /*+ INDEX_ASC(T0 USDAT##VDAT) FIRST_ROWS(1) */ PROGRESS_RECIDunique_id_0,ANTEIL,U##ART,ART,BDAT,BETRAG,TGELD,DATUM,HH,HNR,KNR,MNR,STD,TXT##1,TXT##2,TXT##3,TXT##4,UC,UL,UPOS,VDAT,ZEIT,EKG,TYP,PROZ,ABZUG,PID,KOSTNR,UPAR,ID,PROGRESS_RECID,KOSTELLE,EEXP,ANZAHLLE,BEWILL_DAT_VON,BEWILL_DAT_BIS,NACHTRAEGLICH,VERFAHRENID,ANZLE FROM LKOM.USDAT T0 WHERE (KNR = 1402821 AND HNR = 1 AND U##ART = upper('SVB') AND UPOS = 1 AND VDAT <=TO_DATE(' 2016/1/1','YYYY/MM/DD') AND VDAT <= TO_DATE('2015/10/1','YYYY/MM/DD')) ORDER BY U##ART, KNR, HNR, UPOS, VDAT DESC, DATUM DESC, ZEIT DESC, unique_id_0;