Thanks for your message. This looks like an instance of https://github.com/jOOQ/jOOQ/issues/15609. I can't say for sure, because you didn't show the code of your getTable1SelectCondition()
On Fri, Jan 24, 2025 at 7:42 AM 'Kunal Kumar' via jOOQ User Group < [email protected]> wrote: > Hi > While using *Jooq version 3.19.17, *I am facing the issue below, > > If I do this, > dslContext > .named(DaoJooqImpl.class, "getTemp") > .select(Table1.fields()) > .from(Table1) > .join(Table2) > .on(Table1.LEGAL_ENTITY_ID.eq(Table2.ID)) > .where(*getTable1SelectCondition(id, queryText, filters)*) > > the query is coming as > select > "public"."table1"."id", > "public"."table1"."address", > "public"."table1"."name" > from "public"."table1" > join "public"."table2" > on "public"."table1"."legal_entity_id" = "public"."table2"."id" > where ( > "public"."table1"."is_active" = true > and "public"."table1"."id" = cast('abc' as uuid) > and *cast("public"."table1"."name" as varchar) *like (('%' || > cast(cast('ff' as citext) as varchar)) || '%') escape '!' > ) > > > Here *cast("public"."table1"."name" as varchar) *is generated instead > of *public"."table1"."name" * which is causing case sensitive matching > in like operation. > > however the *getTable1SelectCondition(id, queryText, filters) *returns a > *Condition > *object which is this- > ( > "public"."table1"."is_active" = true > and "public"."table1"."id" = 'abc' > and* "public"."table1"."name"* like (('%' || cast(cast('ff' as citext) > as varchar)) || '%') escape '!' > ) > > How to resolve this and prevent casting of field *"public"."table1"."name" > * to varchar? > > Thanks, > Kunal > > -- > 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 visit > https://groups.google.com/d/msgid/jooq-user/e7de2309-d303-4f3c-abd7-28f141ac649dn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/e7de2309-d303-4f3c-abd7-28f141ac649dn%40googlegroups.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 visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7vVC7ZMxn_BuQ%2BhrzvVSwewaVEFOwf7Lv8dP5Pdm3VSQ%40mail.gmail.com.
