HikariCP don't work with PGroonga extension

brettwooldridge / HikariCP

光 HikariCP・A solid, high-performance, JDBC connection pool at last.

Apache License 2.0

19.99k stars 2.93k forks source link

HikariCP don't work with PGroonga extension #1333

Closed alxspn closed 5 years ago

alxspn commented 5 years ago

Environment

HikariCP version: 3.3.1
JDK version     : 1.8.0_181
Database        : PostgreSQL9.6
Driver version  : 42.2.5

HikariCP with installed PGroonga extension (https://pgroonga.github.io).

Query "select id from contact where (resume &@ 'test')" throw ERROR: operator does not exist: text &@ unknown.

Request with native JDBC connection works as expected.

brettwooldridge commented 5 years ago

This makes no sense. HikariCP does not parse, alter, or inspect the query in any way. Please step into the HikariCP code with a debugger to verify for yourself.