Hibernate Reactive with postgresql native query Cannot invoke "String.hashCode()" because "<local6>" is null

[agreedSkiing]

Describe the bug

When trying to use a native query, the sql works in the postgresql container, i'm getting the Cannot invoke "String.hashCode()" because "<local6>" is null error.

Expected behavior

Query executed against db with no error and an empty result list.

Actual behavior

Query executing fails with using the postegresql dialect.

How to Reproduce?

Reproducer project.

https://github.com/agreedSkiing/reactive-postgresql-local6-error/tree/main

Output of uname -a or ver

Linux DI-001000095350 5.15.137.3-microsoft-standard-WSL2 #1 SMP Mon Nov 6 23:32:38 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

Output of java -version

Picked up JAVA_TOOL_OPTIONS: -DargLine="-Dhttp.proxyHost=proxy.digg.se -Dhttp.proxyPort=8080 -Dhttps.proxyHost=proxy.digg.se -Dhttps.proxyPort=8080 -Dhttp.nonProxyHosts=localhost" java 21.0.2 2024-01-16 LTS Java(TM) SE Runtime Environment (build 21.0.2+13-LTS-58) Java HotSpot(TM) 64-Bit Server VM (build 21.0.2+13-LTS-58, mixed mode, sharing)

Quarkus version or git rev

3.8.5.SP1-redhat-00001

Build tool (ie. output of mvnw --version or gradlew --version)

Picked up JAVA_TOOL_OPTIONS: -DargLine="-Dhttp.proxyHost=proxy.digg.se -Dhttp.proxyPort=8080 -Dhttps.proxyHost=proxy.digg.se -Dhttps.proxyPort=8080 -Dhttp.nonProxyHosts=localhost" Apache Maven 3.9.7 (8b094c9513efc1b9ce2d952b3b9c8eaedaf8cbf0) Maven home: /home/eriase/.asdf/installs/maven/3.9.7 Java version: 21.0.2, vendor: Oracle Corporation, runtime: /home/eriase/.asdf/installs/java/oracle-21.0.2 Default locale: en_US, platform encoding: UTF-8 OS name: "linux", version: "5.15.137.3-microsoft-standard-wsl2", arch: "amd64", family: "unix"

Additional information

Needed to use mvn instead of the mvnw package since the company proxy is blocking the mvnw download.

[agreedSkiing]

Just tested the code with plain old hibernate and the query works fine so seem to be an issue releated to hibernate reactive :(.
See branch https://github.com/agreedSkiing/reactive-postgresql-local6-error/tree/hibernate-orm-test

I also tested quarkus 3.14.2 and got the same error but with a different stacktrace see https://github.com/agreedSkiing/reactive-postgresql-local6-error/tree/hibernate-orm-test

[agreedSkiing]

/cc @DavideD (hibernate-reactive), @gavinking (hibernate-reactive)

Sorry for the direct ping but quarkus bot hasn't picked up the issue for some reason

[DavideD]

I will check

[DavideD]

The problem is caused by a bug in Hibernate Reactive that's been solved as part of issue hibernate/hibernate-reactive#1984. Basically, Hibernate Reactive returns null when it should return the column type name of the result. It's fixed by commit 0680041f.

So, the solution is to use a version of Quarkus that contains Hibernate Reactive 2.4.2. I cannot think of any workaround at the moment.
I've updated your project to use Quarkus 3.16.2 and everything seems to work: DavideD/reactive-postgresql-local6-error@6c276ad

There is also an extra commit that refactors the code a little, it's mostly a personal preference and it's not mandatory for the project: DavideD/reactive-postgresql-local6-error@a92adfd

I'm closing the issue, but feel free to continue the discussion here if you have more questions.