Thanks a lot for your reproducer. I can see it now. I've created an issue for this: https://github.com/jOOQ/jOOQ/issues/17958
A workaround in this particular case is to use a plain SQL template: https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating/ On Wed, Feb 5, 2025 at 1:59 PM 'Kunal Kumar' via jOOQ User Group < [email protected]> wrote: > I am facing an issue where *citext* variable are getting casted to > *varchar* in new jooq version(*v3.19.18*). In older version like jooq > *v3.19.11*, this issue was not there. *citext* variable should give > case-insensitive result when *like* operation is being applied. There is > discrepancy in *contains()* operation in jooq which causes auto casting > of *citext* to *varchar* in new jooq versions. I have created a producer > example here <https://github.com/kkumarspotnana/jooqIssue>. I have taken > the dump of output of queries mentioned in code in sampleOutput > <https://github.com/kkumarspotnana/jooqIssue/tree/main/sampleOutput>. > Kindly let me know how to address this issue and prevent auto casting of > *citext* to *varchar* in new jooq version. > > This is in continuation to this > <https://groups.google.com/u/1/g/jooq-user/c/GS5Snot21Y8> thread. > > Thanks and regards, > 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/116f0dc9-5fed-4880-a27f-89e6f2d465a9n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/116f0dc9-5fed-4880-a27f-89e6f2d465a9n%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/CAB4ELO6aYjo%3DHiHa2r8P%3DA6158vrfyJcwrYiR3jG3%3Dj7SUkKbg%40mail.gmail.com.
