MarkusWinand
Joined 12 years ago
Karma
1,995
Submissions
166
Member since
Jan 17
Recent submissions
Comment · 9 months ago
INSERT ... ON CONFLICT has fewer surprises in context of concurrency: https://modern-sql.com/caniuse/merge#illogical-errors
Besides portability, there is IMHO nothing against INSERT ... ON CONFLICT if it does what you need.
Comment · 2 years ago
> Making a pretty diagram where all the behaviours from various DBMSs are listed is left as an exercise to the author. :)
It's there already!
It's in the chart as footnote "b": Outer reference must be the only argument (doesn’t support F441)
That's the one thing SQL Server doesn't eat. Those that are green in the chart work fine in this case.
Comment · 2 years ago
No question, such a query should not be written. That's probably the reason why this odd behavior, which is even different in various DBMSes, is not causing everyday problems.
Comment · 3 years ago
> SQLite also ignores size restrictions on text columns; [...] requires a trigger.
I'd go for CHECK constraints first: https://www.sqlite.org/lang_createtable.html#ckconst
> Procedural SQL [...] Choose your investment here carefully.
I think that the demand for procedual code has dropped drastically in the past decades as the "normal" SQL can solve so many more things with window functions, recursion, and so forth. So I'd say: Yes, choose your investment wisely and stay away from procedural SQL as long as possible.
Comment · 3 years ago
The existing implementations (Oracle DB, SQL Server, MariaDB, Big Query) come with their problems too. I was a big fan of the new features when it came out in 2011, but pratically there is an unsolved elephant in the room: It doesn't cover schema changes.
Comment · 3 years ago
Fair point, looks suspicious on first sight. I've checked my tests briefly: It's accepted as table and column name. As mentioned in footnote [0] I haven't checked different contextes yet.
Can you tell me: what kind of identifier is it (view name, function name) and which SQL context it causes problems (select list, create/drop statement, ...) and which system has problems with it. Thx.
Comment · 3 years ago
Author of the website here.
All charts on modern-sql.com are backed by tests. I also keep them up-to-date by running them for new releases when they appear.
All about SQL:
https://winand.at/ https://use-the-index-luke.com/ https://modern-sql.com/