Skip to Content
0

Incorrect join after updating IDT from 4.1 Support Pack 2 to 4.2 Support Pack 3 Patch 3

Jan 27, 2017 at 01:04 PM

128

avatar image
Former Member

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?

picture1.png (42.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers