40 IT failures caused by software bugs

Dangerous logical bugs in widely used products: A while back the Life Insurance company debited my account twice in the same month (luckily I had enough money on the account cover it).

A large US supermarket chain debited a large number of customers debit and credit card transactions more than once.

What these problems have in common is the same transactions being duplicated.

I suspect that the route of these problems lies in SQL generating duplicate rows.

Generating duplicate rows is a logical bug in SQL. According to relational theory, data should only be represented as relations, and as a relation is a set of tuples (rows, roughly in SQL speak) there should be no duplicates (as we all know a set cannot have duplicates).

We should call on vendors and the SQL standards committee to fix this bug as soon as possible.; Posted by: jorwell Posted on: 10/01/07 You are currently: a Guest | Members login | Terms of Use

Reply to Story Reply to Message

Subscribe to this discussion via Email or RSS

duplicate rows Erik Engbrecht | 10/02/07

Set Theory Vs. Engineering DannyO_0x98 | 10/02/07

Bad Algorithms... jasonp@... | 10/02/07

These are custom ... bjbrock | 10/02/07

Don't buy their products Erik Engbrecht | 10/02/07

| 10/02/07

Not really Erik Engbrecht | 10/02/07

| 10/02/07

Indemnification... jasonp@... | 10/02/07

What do you think?

Building the Virtualized Enterprise with VMware Iinfrastructure VMware VMware virtualization software has been adopted by over 120,000 enterprise ... Download Now
Reducing Server Total Cost of Ownership with VMware Virtualization Software VMware VMware virtualization enables customers to reduce their server TCO and ... Download Now
VMware Infrastructure: A Guide to Bottom-Line Benefits VMware Frustrated by the costs of maintain ever larger data centers?or building ... Download Now

Here to help you with your Document Management Needs
Check out Doc’s Blog on ZDNet
Help your company, help the earth I want to share with you the Environmental Defense Fund Paper Calculator, which allows you to gauge your organization's environmental impact.
Which is Greener: Paper or Digital? The Answer May Surprise You Anything we can do to reduce paper consumption is good. But what about the impact of digital waste?
Produced by
ZDNet and