23
Guess the intent (aussie.zone)
submitted 3 months ago* (last edited 3 months ago) by Threen@aussie.zone to c/sql@programming.dev
9 comments fedilink hide all child comments

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

you are viewing a single comment's thread
view the rest of the comments
[-] neidu2@feddit.nl 4 points 3 months ago

I'm not that sturdy with SQL functions, but my understanding is this:

Get the client ID, and use that as input to a sine function to get a new number. Then get the absolute value of this number. Then you cast this as a bit, and you end up selecting all clients who through this lovecraftian horror ends up as 0.

Why?? I have no idea. It looks to me like they want only to select a subset of clientIDs, but with something that is hard to predict but with the same result every time for the same clients.

this post was submitted on 30 Jun 2024
23 points (100.0% liked)

SQL

450 readers
2 users here now

Related Fediverse communities:

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 1 year ago
MODERATORS
Ategon@programming.dev
jnovinger@programming.dev