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...