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. I have taken the dump of output of queries mentioned in code in
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 thread.
Thanks and regards,
Kunal