Hi Vladislav > Those are MySQL-specific extensions. I'm planning to add support for > the SQL:2003/2008 standard MERGE INTO clause: > http://sourceforge.net/apps/trac/jooq/ticket/486 > > Once that has been established for those RDBMS that support it, I'll > try to map the MERGE statement to any proprietary variants, such as > the one you mentioned. Today, I don't think you can do it with jOOQ.
I have decided that a mapping of the SQL:2008 standard MERGE statement onto the MySQL variant doesn't make sense. While they produce similar behaviour, they work quite differently. MySQL's ON DUPLICATE KEY UPDATE clause is much more concise but also less flexible. It might be easier to implement an ON DUPLICATE KEY UPDATE clause and map that to a MERGE statement for other dialects, since I have all KEY information in jOOQ to form the MERGE statement's USING clause. So here's the ticket for 1.6.0 to support MySQL's ON DUPLICATE KEY UPDATE clause explicitly: https://sourceforge.net/apps/trac/jooq/ticket/541 Cheers Lukas
