Re: Generate Random SQL...

From: Mike Sherrill <MSherrill_at_compuserve.com>
Date: Sat, 15 Feb 2003 08:38:03 -0500
Message-ID: <3e1m4vs2nf4uoass1cea1mkcvcbn1r4490@4ax.com>

On Wed, 12 Feb 2003 10:57:51 GMT, "Paul Wo" <pwolmering_at_yahoo.com> wrote:

> I'm in need of a program that will generate random SQL statements
>(Select/Insert/Update/Delete) based on bound conditions; DDL, # of joins, #
>of expressions, etc.
>
> Has anyone built such a beast and/or know where one might exist?

IIRC, somebody from Microsoft wrote a tool and a white paper along those lines. Something like "Massive Stochastic Testing of SQL". I don't recall there being any implementation details in the paper, but it might have bibliography.

-- 
Mike Sherrill
Information Management Systems

Received on Sat Feb 15 2003 - 07:38:03 CST