Bug Report

select 'text'::citext = :param fails when :param is set to (String) "TEST".

This seems to be an issue with the driver explicitly setting the type of the string parameter - as noted here: https://stackoverflow.com/a/23721681/7759514

For hibernate, this can be fixed using the properties: spring.datasource.hikari.data-source-properties.stringtype=unspecified / spring.datasource.tomcat.connection-properties.stringtype=unspecified
However these properties seem to have no effect with r2dbc

Versions

• Driver: 0.8.10.RELEASE
• Database: postgres 14
• Java: 17