Re:Why Are There No Relational DBMSs? [pdf]
by goto11 on Monday March 13, 2023 @03:17PM
(#35140976)
The problem with SQL is it is based on relational algebra, just not consistently.
SQL allows you to insert a duplicate row or update a row such that it becomes similar to another row. But then it is not possible to delete or change the row again without changing or deleting all the duplicates, because the query language assumes rows are unique. This is obviously a footgun and not useful behavior.
Re:Why Are There No Relational DBMSs? [pdf]
by gweinberg on Monday March 13, 2023 @06:01PM
(#35143579)
Yes. After shooting off nine of my toes, I decided to save the last one by always adding a unique something to every table, an auto_increment if nothing else seemed appropriate.
SQL allows you to insert a duplicate row or update a row such that it becomes similar to another row. But then it is not possible to delete or change the row again without changing or deleting all the duplicates, because the query language assumes rows are unique. This is obviously a footgun and not useful behavior.