> 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@dalibo.com>: > > > You should try sqlsmith (https://github.com/anse1/sqlsmith), which works > > very well. > > I had found this one before, but all I could get was queries using > "standard" tables, like the ones from pg_catalog and > information_schema. It didn't generate queries from the tables I've > created. Was I doing something wrong?
It should pick your relations with the same likelihood it picks the catalog tables. You could verify this for with, e.g.,
sqlsmith --dry-run | grep your_table_name
Thanks to Julien, sqlsmith's master branch now has an option --exclude-catalog that inhibits use of catalog relations. If you are building from github, you might want to give it another chance with this option. I'll probably do a proper release in next two weeks.
Feedback welcome :-)
regards, Andreas
Yes, I was talking in private with him and he came up with this solution. Thank you again, Julien.
I need to try it again, did a quick test on friday, but it looks like it works perfectly! :)