I am one of the developers on a very small team and have just found the following query

I would love to hear your ideas for what you think was being attempted here!

SELECT ... FROM client WHERE CAST(ABS(SIN(clientId)) AS BIT) = 0

  • Threen@aussie.zoneOP
    0·
    5 months ago

    The client table has around 100,000 rows each with a unique clientId, none of which are returned from the CAST / ABS / SIN

    I think you are right and this is a ‘fix’ for something lost to time. I am going to talk to the original dev tomorrow to see if they remember what it was for