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”.

You didn’t add the date field to your query and couldn’t work out why it didn’t return the missing field for over 2 hours?

Perhaps SQL isn’t for you as things get waaaaay more finicky than that.

Hard disagree. Most trailblazing console ever with one of the strongest lineups of first/second party games we’ve ever seen. Yes there were some shoddy third party ports but you didn’t buy it for those.

People moan about the controller but forget it was the first time a joystick was used and the only real issue was the redundant left prong. Loved the feel of the Z button for shooting games coupled with the Rumble Pak.

Mmmmm fresh pasta.

For me it is very weird, no one introduced me formally to Lemmy(no one I knew run or heard of it), it felt like it was a legend. I never really got to know how good it was and always felt Reddit and Twitter were lacking, never really in control of your memes, never happy with my content, always downvoting stuff. The years went by and my curiosity only became larger as Reddit and Twitter experience was getting worse and worse. I already had experience shit posting and trolling on 4chan since my school days, so last year I signed up to Lemmy and posted my first meme. Next thing I know my feed is breathing again, the grass was definitely greener here. So I switched for both reasons.