The Hidden Dangers of SQL's Design Flaws The world of software development is built on the assumption that our systems are reliable, efficient, and correct.
However, a closer examination of database design reveals disturbing flaws in SQL that can lead to catastrophic consequences. A recent example highlights concurrency bugs arising from innocuous looking code.
A textbook money transfer procedure in TSQL was designed to send ten dollars from Alice's account to Bob's while ensuring Alice didn't overdraft her account. Upon inspection, several critical bugs emerged.