Theme Graphic
Theme Graphic

LaniSoft Corner

Programming with a view to maintenance. Code quality and common mistakes
Posted on Tuesday, August 18, 2009 at 2:17 PM

SELECT * = Maintenance Coder's nightmare

While working as a maintenance coder, I was handed a bug report that went something like this. After the last release we received this error message:

"SQL Error 205 - All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists."

The problem with the error message received was that the function being invoked by the program resided in module A; however, the changes made to the program were made in module B. What made the problem even more baffling was that module B's functionality had no direct relation to module A. In fact, module A contained functionality that was exclusive to one segment of the company and module B was exclusive to another group. The only group that had access to functionality in both modules was the admin group and this error was being reported by a non-admin member...
Comments: 0 Tags: SQL, Maintenance code

 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.