Hi Knut, I am using PostgreSQL dialect - in which the parentheses are working, but not required;
Also, I'm using H2 in memory database for unit testing and because of issue/limitation on their side in that use case, I was thinking maybe I can solve it from JOOQ side, The H2 issues: https://github.com/h2database/h2database/issues/2050 https://github.com/h2database/h2database/issues/918 So, I hope you can think on a workaround for me... Thanks, Ohad On Wednesday, August 7, 2019 at 10:23:28 AM UTC+3, Knut Wannheden wrote: > > Hi Ohad, > > Thank you for your message. > > On Wed, Aug 7, 2019 at 9:07 AM Ohad Pinchevsky <[email protected] > <javascript:>> wrote: > >> I noticed that parentheses added to select statement inside a query (for >> example between union statement), is it possible to control it? >> > > No, this isn't easily possible. Can you tell us a little bit more about > why you would like to do this? > > Please also note that depending on the actual dialect the parentheses are > actually required in some context, as for example the UNION clause you > mention. > > Possibly you have found a case (for a certain dialect) where the > parentheses are indeed not required. In that case I suggest you report this > as an issue (https://github.com/jOOQ/jOOQ/issues/new/choose), so that we > can look into improving that. > > Regards, > Knut > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/50be1d2e-d4f9-4051-974c-b75fa4ffc21a%40googlegroups.com.
