Re: Bizarre behavior

Maybe a bit late to report back, but I haven't tested this for a long time. So, using 3.11.11, this issue with CHAR(1) in MySQL dialects are no longer happening, and it seems that all initial concerns that I had 2-3 years back are resolved. Excellent! The actual code used is; class Mixin

Re: [REQUEST FOR FEEDBACK]: What small but incredibly useful utility are you missing the most in jOOQ?

I'm super late to the party was going to see about using the feature but it looks like this was more complicated than expected? Mostly chiming in for anyone else reading this to see that the feature was rolled back. On Tue, Jun 18, 2019 at 8:07 AM Lukas Eder wrote: > Hi Samir, > > This issue

Re: unexpected log of delete without where

Dear Knut, Thanks for your quick reply. I have double checked my logging configuration file. It is exactly the same that I have been using with jooq 3.10.4. I have attached it. It is pretty standard. What I find interesting is that when I use withExecuteLogging(true), I do not get the

Re: How can i find the greatest between three date columns using Jooq query ?

Hi Kunt, I am using Jooq 3.11.8 and I dont see that greatest() available in DSL for that version. Do i need to change the version ? Can you please suggest ? Thanks, Deba On Wednesday, July 31, 2019 at 12:55:12 AM UTC-7, Debapriya Patra wrote: > > Hi, > > I have a table which contains three

Re: Interaction between window() and limit() in jOOL Seq

Hi Knut, I just opened this bug in the jOOL project. (Feel free to continue this discussion in comments to that bug instead of in this thread.) WRT your suggestion about using window functions in my DB query, unfortunately the DB I'm using (MongoDB)

Re: How can i find the greatest between three date columns using Jooq query ?

Hi, Thank you for your message. The standard SQL GREATEST() function should do what you are looking for. So just use DSL.greatest() as in e.g. DSL.greatest(MY_TABLE.COL1, MY_TABLE.COL2, MY_TABLE.COL3) Hope this helps, Knut On Wed, Jul 31, 2019 at 9:55 AM wrote: > Hi, > > I have a table

How can i find the greatest between three date columns using Jooq query ?

Hi, I have a table which contains three Timestamp columns. I wanted to find the latest date from the three columns. How can i achieve that ? Any help would be greatly appreciated. Thanks, Deba *Table* *-* *Col1 Timestamp* *Col2 **Timestamp* *COl3 **Timestamp* -- You

Re: Interaction between window() and limit() in jOOL Seq

Hi Nat, Thanks for your message. At the moment this is how window() works, but your use case sounds reasonable. Would you mind reporting and issue for this on GitHub ( https://github.com/jOOQ/jOOL) so we can discuss and track this feature request there? Since you mention that you are pulling