Sniffing out SQL Code Smells: Inconsistent use of Symbolic names and Datatypes
- by Phil Factor
It is an awkward feeling. You’ve just delivered a database application that
seems to be working fine in production, and you just run a few checks on it. You discover that there is a potential bug
that, out of sheer good chance, hasn’t kicked in to produce an error; but it lurks, like a smoking bomb. Worse, maybe
you find that the bug has started…