How can we help you today? How can we help you today?

Both sides of comparison are same

During major rewriting of legacy code we made quite simple mistake:

Rewrite JOIN ON/WHERE condition to state when both sides were same. Usually because left/right sides were swapped in source and code is complex (10+ joins).

Maybe SQL Code Guard can detect basic cases, because code 
FROM
  dbo.Table AS A
  LEFT JOIN Table AS B ON A.Col = A.Col
or 
WHERE
  A.col = A.col
  AND ...
doesn't make sense.
Alza
0

Comments

1 comment

Sort by
  • leonardomachado
    Hi Alza! Thank you for your feedback. We'll feed that to the team as a new check we can implement!

    Cheers,

    Leonardo Machado
    leonardomachado
    0

Add comment

Please sign in to leave a comment.