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 jooq-user+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/116f0dc9-5fed-4880-a27f-89e6f2d465a9n%40googlegroups.com.
