Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers