REF :: Sqllogictest

[Cristian Vasile <cr...@gmail.com>]

Hello,

I remember that sqlite project (https://www.sqlite.org/index.html) do
have a very serious test process (https://www.sqlite.org/testing.html)
in place.
Quote
"Sqllogictest is a program designed to verify that an SQL database
engine computes correct results by comparing the results to identical
queries from other SQL database engines. Sqllogictest was originally
designed to test SQLite, but it is database engine neutral and can
just as easily be used to test other database products."

The link is here:
https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki

Other technique is described here:
https://www.cockroachlabs.com/blog/testing-random-valid-sql-in-cockroachdb/

Hope this helps.

Regards,
Cristian.