Oh yeah agree, he has the reverse Midas touch at the mo. Might add it coincided with the media flipping sides when they saw it was a foregone conclusion.

One of the admittedly minor things I dislike about his tetchy interview answers is when he starts going “blah blah blah…that’s why we’ve done things such as…” and then proceeds to list the one and only example of said thing.

Nowadays?!

Completely agree, requirements are key and often badly defined due to the customers’ lack of knowledge of the intricacies of the system. You are correct to ask for clarity or it could come back to bite you later on.

I’ve just had a spec through from a BA which consists entirely of screenshots of an existing system with no technical definitition of any of the requested fields so relate to this right now.

We are just recovering from a similar situation here but the Overton window has shifted so far the supposed left-wing workers’ party now look like centre-right conservatives.

Right on cue, the descent into fascism begins ahead of the impending climate disasters.

It’s so depressing to see France like this, I always held it up as a prominent antifa nation.

Not substantially, it had a different title and was toned down.

I withdraw the word essay and apologise for any rudeness.

Have a good one.

My original message was “Wow ok chill.” then elaborated to clarify.

Where I’m from people are way ruder than anything I said here so perhaps I misjudged the room. However, calling it out seems to have had the desired response as since posting OP went and apologised for his anger.

I in turn apologise for my rudeness to them.

Did you read it before the edits? If it’s written like that I think I’m entitled to exaggerate back slightly to make a point by calling it a rage essay.

Anywho I wouldn’t choose to rant like this to my coworkers or online. A quick 🤦 in chat usually does the trick.

Completely put to task, yep really got me there. I will never see the world in the same way again.

Also, I don’t think you understand what irony means.

You too.

Wow ok chill.

The title of this post was “I hate programming, why did I choose this field”.

I responded suggesting maybe OP isn’t suited to SQL in particular. There are plenty of other languages to learn that they might pick up quicker if they are struggling with SELECTs.

It’s partially right but led OP down the wrong lines of thinking because it interpreted the prompt as a date field being missing rather than the field named date being missing.

Tbh I don’t blame it too much here as there is kind of a base level of understanding requred to use it successfully.

Ah yes here you are successfully ignoring it.

Might not be encouraging it but you seem to be defending it.

It made an incorrect inference, imagine how wrong it is on more complex questions.

There’s a difference between ranting to your coworkers at lunch about a stupid mistake and typing out a full rage essay.

Imagine the state of the sub if we all did that… Wait…

Fair play. SQL is pretty different from traditional programming and errors often aren’t very descriptive.

You’ll need to get very familiar with fields you have included or not in your queries when using more advanced stuff like group functions as including or excluding them can alter the number of rows returned.

Perhaps, but we don’t know and therein lies the problem.

You are correct I don’t know the circumstances so all we can go on is what OP wrote…

Yes of course, but it’s not the sort of thing I’d make a rant post criticising the entirety of programming about.

It’s like going to a mathematics forum and declaring “Guyz I forgot to carry a 1, screw Maths.”

Ah I see ChatGPT is being as accurate as ever making up a created_at field completely unprompted. They’ve already found the correct SQL:

SELECT task, status, id, date FROM mainWorkSpace WHERE user_id = @user_id

Although I would question the sense in calling a date field “date”.