By Sveta Smirnova-Oracle on Jun 01, 2010
Translation of Chapter 2 of Methods for searching errors in SQL application just posted.
Chapter 2. Why you get wrong data.
We learned how to find the problem query.
We already examined 2 examples of syntax error and one example of logic
error. But do include these examples every possibilyty of analysing of
any problem query? Of course, not! Although, strictly say, every error
in the query can be reduced to one of these subtypes.
In this chapter we discuss what else can we do with problem query.
Syntax errors are trivial, therefore we would not study them more.
One of most frequent problems is SELECT query which returns wrong data. This can happen because a number of reasons.
Lets look at easiest - in terms of solving - one.
You can find rest of the chapter here.
As always comments and translation corrections are highly appreciated.