After updating IDT from 4.1 Support Pack 2 to 4.2 Support Pack 3 Patch 3 we have incorrect inner join between Dim_Bank_View and Dim_Time_View.
Without shortcut join everything is good but we need it in another context. This is small part of big DF.
4.1:
SELECT Dim_Bank_View.Code FROM Dim_ReportLine_View INNER JOIN Dim_Time_View ON (CAST(Dim_Time_View.VersionID as Decimal)+Dim_ReportLine_View.VersionID != 0 AND Dim_Time_View.PeriodType = 5) INNER JOIN Dim_Bank_View ON (Dim_Time_View.BeginDate>= Dim_Bank_View.DateCreate AND Dim_Time_View.BeginDate< Dim_Bank_View.DateClose) WHERE ( Dim_ReportLine_View.ReportLineID=Dim_ReportLine_View.ReportLipicture1.pngneID )
4.2:
SELECT Dim_Bank_View.Code FROM Dim_Bank_View, Dim_Time_View INNER JOIN Dim_ReportLine_View ON (CAST(Dim_Time_View.VersionID as Decimal)+Dim_ReportLine_View.VersionID != 0 AND Dim_Time_View.PeriodType = 5) WHERE ( Dim_ReportLine_View.ReportLineID=Dim_ReportLine_View.ReportLineID )
What should we do to avoid deleting join?