News for hackers. Stuff that matters.

A comment on Amazon’s Consumer Business Turned Off Final Oracle Database. Parent comment

Re:Amazon’s Consumer Business Turned Off Final Oracle Database by alexis_fr on Tuesday October 15, 2019 @04:45PM (#21263533)
My top 1 is this one:

> Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different

Any programmer who doesn’t distinguish NULL and "" has not passed the 2-year experience. Being generous. How did this make it to production?

[ Parent | on HN ]
Re:Amazon’s Consumer Business Turned Off Final Oracle Database by irrational on Wednesday October 16, 2019 @08:20AM (#21269564)
Do you mean why does Oracle treat NULL and empty string as the same thing? Internally Oracle changes empty string to NULL values. Oracle won't let you insert an empty string.
[ Parent | on HN ]