Quote: example of comparing random SQL across multiple database systems; 0.07% had possible errors

Quotation

This section contains examples of RAGS on a very small database (less than 4KB). ... [p. 621] Each of the 10 [concurrent] clients executed 2500 [stochastically generated] SQL statements in transactions that contained an average of 5 statements. ... 13.8% had expected errors [e.g., deadlock, divide by zero] and 0.07% indicated possible errors (18 occurrences of 2 different error codes] ... [When comparing results of the 2000 Select statements, about 1700 either agreed or caused an error on all four systems. This test identified an error in SQL Server.]   Google-1   Google-2

By permission of the Very Large Database Endowment

Related Topics

Topic: automated testing (25 items)