Re: Tool to check why queries miss results?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 6 Mar 2006 15:41:52 -0500
Message-ID: <s_Wdneke2ZINA5HZnZ2dnUVZ_sGdnZ2d_at_comcast.com>


"Andreas Koch" <nospam_at_kochandreas.com> wrote in message news:dui6ap$mbp$02$2_at_news.t-online.com...
: Mark C. Stock wrote:
:
:
: > but it still sounds like you're looking for a tool to tell you why the
sets
: > don't match -- which no tool can do, but a well-designed test plan that
: > validates the inputs and/or state of data prior to the test will be able
to
: > accomplish
:
: Strange. I can do it manually, so why should a tool not be able to do
: it? You just have to find which joins blocks the data, and then check
: that branch for which joins blocks the data in that branch, and so on.
: Sounds perfectly doable, at least until you get into PL/SQL functions or
: something.
:
:

[Quoted] that's called reverse engineering

[Quoted] the fact that you can do it manually does not mean that it can be easily automated

are you wanting this magic tool for qa/developers or end-users?

++ mcs Received on Mon Mar 06 2006 - 21:41:52 CET

Original text of this message