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.
