Hi Alok, Thanks for the precision and the pun ;-)
In fact, MySQL has a couple of limitations as far as the nesting of set operations are concerned (in addition to the fact that jOOQ 3.5.0 has a regression). Your particular query should work out of the box, once parentheses are used to wrap the two subselects, but there are more complex ways to nest these set operations, which we're going to be providing emulations for, via derived tables. This will all be addressed in jOOQ 3.5.0 via https://github.com/jOOQ/jOOQ/issues/3579 Best Regards, Lukas 2014-10-06 20:16 GMT+02:00 Alok Menghrajani <[email protected]>: > On Sun, Oct 5, 2014 at 3:04 AM, Lukas Eder <[email protected]> wrote: > > Hi there, > > > > Are you using jOOQ 3.5.0-SNAPSHOT? We might still have 1-2 regressions as > > we're implementing more complete SQL standard UNION support. I don't > think > > this issue should appear with jOOQ 3.4.2... > > master (3.5.0-SNAPSHOT I'm guessing?) has the issue. > > In 3.4.2, the parenthesis are missing and the query is invalid. It's > however a little easier to manually add the parenthesis than it is to > reorder the order (pun). > > Alok > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
