Re: Tool to check why queries miss results?

Andreas Koch wrote:
> gazzag wrote:
>

>>>> just a strange idea. Is there some tool that takes
>>>> an SQL query, plus (parts) of an output of that query
>>>> you'd expect to see, and then explains why that part
>>>> of output wasn't created?
>>
>> Ask the right question, with the right data, and the RDBMS *will*
>> return the correct result set.

You need a programming language that handles fuzzy logic. Lisp pops to mind, and AI systems.

You can automate tests (if this data is in that table, and that data in the other, this query would result in that. If not, raise an error. Then take it up to an AI system, and start speculating).

[Quoted] Doubt if you can automate helpdesks (In fact, I *know* you cannot!)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...