Amazon’s Consumer Business Turned Off Final Oracle Database

Re:Amazon’s Consumer Business Turned Off Final Oracle Database by michannne on Tuesday October 15, 2019 @12:17PM (#21260154)

Using SQL Server exclusively has given me a Never-Oracle mindset. Some of these differences sound insane. and

> any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))

I'd pull the hair outta my head

[ Parent | on HN ]

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 ]

Re:Amazon’s Consumer Business Turned Off Final Oracle Database by hobs on Tuesday October 15, 2019 @12:45PM (#21260529)

But functions in the where clause are an unsargable mess :(

[ Parent | on HN ]