Re: Generate Random SQL...

From: Mike Sherrill <>
Date: Sat, 15 Feb 2003 08:38:03 -0500
Message-ID: <>

On Wed, 12 Feb 2003 10:57:51 GMT, "Paul Wo" <> 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 - 14:38:03 CET

Original text of this message