Peter Geoghegan writes: > On Sun, Dec 6, 2015 at 9:52 AM, Andreas Seltenreich <seltenre...@gmx.de> > wrote: >> I've added new grammar rules to sqlsmith and improved some older ones. > > Could you possibly teach sqlsmith about INSERT ... ON CONFLICT DO > UPDATE/IGNORE? I think that that could be very helpful, especially if > it could be done in advance of any stable release of 9.5.
In summary, it can't be added ad-hoc, but might still happen in advance of the release of 9.5. Adding upsert needs significiant effort because historically, non-boolean value expression productions yield a random type. This is not a problem for generating queries, but it is for inserts. Also, sqlsmith can at the moment only generate sensible value expressions from column references. Generating a proper upsert would require supporting type-constraining of productions as well as adding productions for pulling values out of thin air (e.g., generating atomic value subselects or calling argumentless functions). 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
