Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
moagggi8037yYes, that's the way it's working there.. Doesn't the documentation clearly state that? π
-
A classic π§ ππΌππ» that gets you in the morning at 4 o'clock when the deadline is near...
-
@moagggi Yeah it kinda does, but it took me a while to turn to the docs. I figured this made sense and it didn't give an error so I didn't think that would be the problem at first ^^'
-
kinda makes sense if you think about it. null shouldn't be equal to anything, strictly speaking, so the equality comparison operator doesn't exactly make semantic sense.
i was stumped by it and disliked it too, but that was a long time ago, now i'm just thinking about it philosophically... -
java91587yIS NULL is actually the ANSI standard way of doing this, which most databases support. Haven't used a database where you can use = NULL before.
-
You think that's frustrating, try returning a specific number of specific records in Oracle. TOP 250? Nope. LIMIT 250? Nah. Too easy.
Here's your ROWNUM and good fucking luck.
Related Rants
Apparently `= NULL` is not a thing in mysql, instead you have to use `IS NULL`... Took me a while to figure out why the fuck my query wasn't returning any results.
rant
sql
null
mysql