Please who the fuck wrote sql query with 6 nested select queries as 1 giant view. Literally 6 paranteses. Garbage 30 year old legacy codebase Please fuck off i now understand why nobody wants to work on this bullshit

those are rookie numbers.

how about a recursive stored procedure, working on 5 different views, with each of them working on 2 others on average, with each of those working on 1-2 tables. with a bunch of custom functions sprinkled in.

the procedure then returns a table itself, and if you don't query it with _exactly_ the right filters (even requesting more than one row is wrong), it _never_ finishes. i've run a test once out of curiosity, it was still working after 4 days.

@tosensei i cant stand legacy code projects

Only 6? 😂 that's a wii little baby.

@b2plane you may not be cut out for this industry.

More than half of the jobs are brown field. And there's good money in being able to do it well

@C0D4 6 nested subquery levels? That's quite a lot.

6 flat subqueries - sure. But 6 nested - I'm yet to see that

I had a formatted query once in 1300 lines 😁

Welcome to the real world

@retoor wow

@saucyatom thats so shit i thought devs in the real world actually knew how to do their shit and not write such clusterfuck spaghetti shit even sql queries!

@netikras I've only ever done it once, but when you need to swap ORDER BY and GROUP BY around, you stop asking if your doing the right thing when it works.

@C0D4 And now you wake up every morning with this shame... How do you take it? How do you sleep at night?

@netikras it's not shame, I see it working every morning without fail!

I get a little grin of joy, that it still works.

Please permit me to seize this thread to show gratitude and appreciation to the Hack Recovery support team. This cybersecurity firm helped me recover my stolen Bitcoin and ETH coins worth $402,000. I am totally in awe of how amazing their services are and how quickly they were able to get back my stolen crypto funds after I fell victim to an investment scam. Their professional web developers and cyber experts were very transparent and trustworthy in handling all the information I provided them. They were able to help me track down the con men after the recovery of my crypto. I highly recommend their service to everyone who needs a crypto or funds recovery expert at [hackrecovery AT yandex DOT ru]

@Jacques20 go fuck yourself

I feel your pain. I am glad it's not just me who must deal with such nonsense