Re: Generate Random SQL...
From: Mike Sherrill <MSherrill_at_compuserve.com>
Date: Sat, 15 Feb 2003 08:38:03 -0500
Message-ID: <3e1m4vs2nf4uoass1cea1mkcvcbn1r4490_at_4ax.com>
Date: Sat, 15 Feb 2003 08:38:03 -0500
Message-ID: <3e1m4vs2nf4uoass1cea1mkcvcbn1r4490_at_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 SystemsReceived on Sat Feb 15 2003 - 14:38:03 CET