Moderation Questions
The last iteration of the moderation discussion thread was a complete disaster. Numerous attempts to keep it on topic fa
It's sometimes my fault, sometimes others and sometimes some of both. Sometimes it's just hard.
This was our last 'exchange'. I'm not taking responsibility for that
People have called me a cult
(for those who need it, reuse of a of an old jasper carrot joke)
Chez I never have a scooby what you're talking about. If multiple people point this out about you...maybe they're not wrong??
Even people on another forum (not UP) who used to post here say they didn't know what the hell chez was talking about a lot of the time.
According to him that's because people aren't genius enough to grasp the full brilliance of his posts. More fool him for casting his pearl before swine I guess.
Chez, remember that time you argued with me for hours about something related to nulls in relational databases? You know, the thing I'm an expert in and have been doing professionally for over 20 years? And then how when I definitively showed you that you were wrong using multiple analogies and examples, you started responding even more obliquely and with even more non sequiturs than usual rather than admitting you were wrong? Fun times! Maybe stick to the rocket science and brain surgery and leave the null handling to me.
Yeah I well remember when you confused the specific way sql handles nulls with the problem of null data.
Also how is your dog?
Even people on another forum (not UP) who used to post here say they didn't know what the hell chez was talking about a lot of the time.
According to him that's because people aren't genius enough to grasp the full brilliance of his posts. More fool him for casting his pearl before swine I guess.
That appears to be according to you
As I said. You're more interested in trolling etc then understanding
I hope that was clear enough for you
As I said. You're more interested in trolling etc then understanding
I hope that was clear enough for you
Que?
What's there to argue about NULLs in SQL? I'm curious as I don't remember that exciting exchange.
I did have a new coworker think that NULL was the same as 0 as an int and an empty string when a char. Good times.
There's nothing much to argue. Nulls in sql are trivial. The problem of null data is what sql introduced NULLs to try to cope with.
It wasn't an exciting exchange. I made an effort initially but D2 resorted to trolling as soon as it got beyond the trivial bit.
What's there to argue about NULLs in SQL? I'm curious as I don't remember that exciting exchange.
I did have a new coworker think that NULL was the same as 0 as an int and an empty string when a char. Good times.
Syntactically NULL is not the same as 0 or an empty string. Semantically NULL and 0 are different but NULL and empty string are the same thing, i.e. you shouldn't imbue them with different meanings. I think that's actually what the debate was about.
If you disagree, think about why you don't have an empty date or an empty int or an empty GUID, for example. Empty strings are an aberration due to the implementation detail of what a string is (an array of characters, and you can have an empty array).
An empty string doesn't mean anything different to NULL, i.e. it is the absence of a value, whereas a zero means something very much different to NULL in the case of a numeric field.
There's nothing much to argue. Nulls in sql are trivial. The problem of null data is what sql introduced NULLs to try to cope with.
It wasn't an exciting exchange. I made an effort initially but D2 resorted to trolling as soon as it got beyond the trivial bit.
I just got bored of your ignorance, arrogance, stubbornness, and non responsive replies. Call that trolling if you like.
So you say but I think you're more about trolling etc than understanding anything.
Is that clear enough?
So you say but I think you're more about trolling etc than understanding anything.
Is that clear enough?
You deliberately conflating these two because you don't like people disagreeing with you and then resorting to petty name calling when they tell you you don’t know what you’re talking about is the problem.
Just gonna leave this here for Mr Moral high ground
The irony of you posting that before 5am is clearly lost on you, but at least this time it wasn't another anti immigrant rant.
Syntactically NULL is not the same as 0 or an empty string. Semantically NULL and 0 are different but NULL and empty string are the same thing, i.e. you shouldn't imbue them with different meanings. I think that's actually what the debate was about.If you disagree, think about why you don't have an empty date or an empty int or an empty GUID, for example. Empty strings are an a
Even some moderately experienced SQL devs make mistakes with NULLs.
eg comparing one NULL value to another and expecting TRUE
Even some moderately experienced SQL devs make mistakes with NULLs.
eg comparing one NULL value to another and expecting TRUE
I wouldn't call any SQL dev who compares nulls for equality moderately experienced, same as I wouldn't call any C-family language dev who compares floats for equality moderately experienced. Although I guess in SQL it can be a bit more insidious, for example when joining on a nullable field.
In Microsoft SQL you can also set the ANSI_ NULLS option to off and nulls will compare equal (and unequal to any non null), although I've neither seen that option used, nor used it myself.
Yes, I know about MS SQL - remember I was a SQL Dev since the late 90s?
I missed the original chezlol debate about NULLs because it was in the Religion thread, but just skimmed it. wtf is he talking about?
Yes, I know about MS SQL - remember I was a SQL Dev since the late 90s?
I missed the original chezlol debate about NULLs because it was in the Religion thread, but just skimmed it. wtf is he talking about?
**** knows and I'll be ****ed if I'm going back to re-read all that. If memory doesn't fail I just gave up trying to explain anything to him after a while.
