News for hackers. Stuff that matters.

A comment on Problems with Oracle SQL. Parent comment

Re:Problems with Oracle SQL by yyyk on Friday September 10, 2021 @02:29PM (#28485403)
I don't have the experience to compare them to Oracle, but SQL Server and Postgres do have their own issues.

The infamous MSSQL "string or binary data will be truncated" error (fixed a while ago[0]), or the way either deals with unqualified access to columns which leads to surprises (e.g. in MSSQL subqueries or in Postgres's SECURITY DEFINER procedures).

[0] https://docs.microsoft.com/en-us/sql/t-sql/database-console-...

[ Parent | on HN ]
Re:Problems with Oracle SQL by tomrod on Friday September 10, 2021 @04:54PM (#28486768)
Oh indeed, they all have quirks.

Oracle seems to have more than most, IMO.

I have a journeyman data engineering level experience with each. Rare combo I guess, Data Scientist focus.

[ Parent | on HN ]