Michael Paquier writes: > On Fri, Oct 6, 2017 at 9:19 PM, tushar <tushar.ah...@enterprisedb.com> wrote: >> ERROR: recovery is not in progress > > Perhaps there is a way to blacklist some functions depending on the > server context. This question may be better asked directly where the > project is maintained then: https://github.com/anse1/sqlsmith. I am > adding as well Andreas in CC, he works on sqlsmith.
Blacklisting when testing with sqlsmith typically happens on the error logging side: Logging into a database via --log-to with the schema shipped with sqlsmith filters out boring error messages with triggers. The ERROR reported is actually in the filter tables that ship with sqlsmith. I don't think adding such product-specific filtering on the generating side is necessarily the right thing, as it would reduces code coverage while testing. We might miss a core dump when something becomes buggy in that path. I did make an exception for syntax errors: sqlsmith notices when grammar productions consistently lead to errors. This feature was added to allow testing other products or older postgres, so sqlsmith doesn't waste time generating upsert statements on 9.1. It's more apparent when testing sqlite3: The error rate is 90% on startup, but shrinks to 2% or so after a couple thousand statements have been generated. regards, Andreas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
