A random SQL query generator
consistent()
about anymultirange and anycompatible* types (@df7cb)v1.2.1 contains the following fixes for v1.2:
Release 1.2 includes the following changes:
SQLsmith is a random SQL query generator for PostgreSQL. It is inspired by Csmith, which generates random C code.
Use cases are quality assurance through fuzz testing and benchmarking. Besides PostgreSQL developers, users developing extensions might also be interested in exposing their code to SQLsmith's random workload.
During its development, it already found about thirty bugs in PostgresSQL alphas, betas and releases, including security vulnerabilities in released versions. There is a score list maintained by its users in a wiki:
https://github.com/anse1/sqlsmith/wiki#score-list
Version 1.0 supports generating queries for PostgreSQL 9.5 or later only. SQLsmith was designed with testing different versions and even products in mind, but this has not manifested yet for the first release.
SQLsmith is available under GPLv3. Use it at your own risk. It may damage your database (one of the purposes of this tool is to try and break things). See the file COPYING for details.
Packages for Debian/Ubuntu are available via apt.postgresql.org.