Hi Rob, Like twitter, we sometimes wish to have an edit button on mailing lists, right? :)
I'm having difficulties to generate the "delta" of your different messages. Some issues you ran into seem not strictly related, and others have been superseded by a subsequent email. Was there a bug somewhere? Or a UX problem? Feel free to create an issue: https://github.com/jOOQ/jOOQ/issues/new/choose Thanks, Lukas On Fri, Mar 5, 2021 at 7:32 PM Rob Sargent <[email protected]> wrote: > Perhaps a more addressable problem statement: referring to a previous CTE > > ( > select distinct unnest(c.loci_ordinals) as ord > from cliqueset c -- CTE referenced here > where 12994 < any(c.loci_ordinals) or 12849 > any(c.loci_ordinals) > ) > > In jOOQ I had to bring in the actual table containing the array > > Field<Integer> lowOrd = DSL.val(pterIndex); > Field<Integer> highOrd = DSL.val(qterIndex); > CommonTableExpression<Record1<Integer>> extras = > name("xm").fields("xord") > > .as(selectDistinct(cliqueset.field("mord").cast(Integer.class).as("xord")) > > .from(cliqueset.join(LD_CLIQUE).on(cliqueset.field("qid").cast(UUID.class).eq(LD_CLIQUE.MARKERSET_ID) > > .and(cliqueset.field("qord").cast(Integer.class).eq(LD_CLIQUE.ORDINAL)))) > .where(lowOrd.gt(DSL.any(LD_CLIQUE.LOCI_ORDINALS))) > .or(highOrd.lt(DSL.any(LD_CLIQUE.LOCI_ORDINALS)))); > > On 3/5/21 10:06 AM, Rob Sargent wrote: > > I'm sure you've given up by now but the orderBy() needs to be on the union > of course not the second CTE > rjs > > On 3/5/21 8:25 AM, Rob Sargent wrote: > > Sorry, the error is > > .from(extras).join(MARKERSET_MEMBER).on(extras.field("xord") == > (MARKERSET_MEMBER.ORDINAL)) > > java equals operator silently kills it > > On 3/5/21 7:58 AM, Rob Sargent wrote: > > Scrap that example. > on(cliqueset.field("qid").cast(UUID.class).eq(LD_CLIQUE.MARKERSET_ID) > become "on false" > so I have more work to do. > > > On 3/5/21 1:04 AM, Lukas Eder wrote: > > We don't have any, though we probably should (especially for CTE, there's > a pending issue for that). What are you looking for, specifically? > > On Thu, Mar 4, 2021 at 10:40 PM Rob Sargent <[email protected]> wrote: > >> Is there a repository of more complex examples of jOOQ code? I'm having >> a lot of fun with CTEs and DSL.any and I think I'm conforming to the >> website examples. >> >> -- >> 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/0c174979-b542-eca3-44cb-adc47ade1310%40gmail.com >> . >> > -- > 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/CAB4ELO7FRKpTKcKXEGfaB533G0XmmARuSuFNkoVNgbANCP5aqg%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAB4ELO7FRKpTKcKXEGfaB533G0XmmARuSuFNkoVNgbANCP5aqg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > > > > > -- > 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/7a23d1dd-af96-17da-955b-7f3adc9b9fa9%40gmail.com > <https://groups.google.com/d/msgid/jooq-user/7a23d1dd-af96-17da-955b-7f3adc9b9fa9%40gmail.com?utm_medium=email&utm_source=footer> > . > -- 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/CAB4ELO6T-TSS4iUqGOPnPrPRs1-EzXbzBBGMpdW-tKiJB8MJyA%40mail.gmail.com.
