Translation of Chapter 4. Miscellaneous. of "Methods for searching errors in SQL application" just published
By Sveta Smirnova-Oracle on Jun 16, 2010
This chapter starts as:
Chapter 4. Miscellaneous.
There are cases when wrong output is just symptom of wrong input made before.
For example, you start to receive wrong data at particular step of the
scenario. After analysis of the SELECT query (or queries) is clear what
queries are correct and return exactly same data which exists in the
table (or tables).
This means wrong data was inserted at the earlier step.
How to know when it happened?
Start from the step of the scenario which exists just before
step which does output, check every query as was described in earlier
chapters. If everything works correctly, examine earlier step, repeat
until you find the error.
We can examine example with list from Chapter 1 as example of such behavior.
Lets see at output one more time.
Really I could put here longer quotes, but I don't like how this interface prints code. So you can find rest of the chapter here.
Comments and translation corrections are welcome.