I'm involved in a software testing group, it's the basic testing of an existing enterprise system. My question is about testing a fairly complex piece of software, that does this and that, and then inserts data into an Oracle table.
How do you test something like this "to the penny"? In order to have an independent test, you'd kind of have to build the same logic separately. Then if the program changes, you'd have to update your testing module.
Nevertheless, this is a system test and not a unit test. But still, to balance "to the penny", this is more than a causal glance at the numbers, "Hey, looks good!"
In my example, the logic retrieves data from Oracle where [such and such] = A, B, or C, and we changed the logic to add D, E, F. I'm inclined to inspect the code as our verification method. But to write a query to test this, I'm thinking I have to build the actual logic from the program.
Just looking for a reasonable approach to this.