News for hackers. Stuff that matters.

A comment on Null Values in SQL Queries. Parent comment

Re:Null Values in SQL Queries by johannes1234321 on Monday February 03, 2020 @09:54AM (#22224601)
Right, I am a fan of SQL NULl as well. It is nicely consistent - anything NULL in - you get NULL out. Clearly telling that you get undefined data. Silently converting to empty string, zero, or therelike would eventually return garbage for harder to debug reasons.

That Oracle behavior annoys me each time, though.

[ Parent | on HN ]
Re:Null Values in SQL Queries by tabtab on Monday February 03, 2020 @01:15PM (#22227125)
Re: Silently converting to empty string, zero, or therelike would eventually return garbage for harder to debug reasons.

It's never been a problem with strings in my many decades of experience, unless somebody does something which I consider poor system engineering. Nearby I invited a solid use-case illustrating a real string need.

[ Parent | on HN ]