Quarkus 3.28.4 generating syntax errors on DB2

[danillob]

Describe the bug

After upgrading Quarkus version from 3.28.1 to 3.28.4, using the quarkus-jdbc-db2 dependency, HQL started presenting syntax error on execution.

Expected behavior

Queries executed correctly.

Actual behavior

Erro generated:

org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=(;. JOIN INNER LEFT RIGHT FULL CROSS, DRIVER=4.34.30]

How to Reproduce?

Upgrade a working project that uses PanacheEntityBase models that have table joins from verson <= 3.28.1 to >= 3.28.4, and execute a previous working query.

Output of uname -a or ver

No response

Output of java -version

21.0.1

Quarkus version or git rev

3.28.4

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

Maven 3.9.6

Additional information

No response

[quarkus-bot]

/cc @mswatosh (db2)

[geoand]

Do newer versions exhibit the same issue?

[geoand]

cc @yrodiere

[danillob]

Do newer versions exhibit the same issue?

Yes. I tested on version 3.30.6 and had the same result.

[geoand]

Thanks for checking

[xwigny]

Same issue on 3.27.X. See discussion #52114

[yrodiere]

Hey @beikov @mbellade @gavinking, this rings a bell... did you touch something related upstream?

[beikov]

Yeah, I fixed that already in the latest 6.6, 7.1 and 7.2. Maybe quarkus just needs to bump the ORM version?

[yrodiere]

Alright, thanks. Do you have a HHH issue that I can use to find out which version of Quarkus should have the fix?

@danillob Whatever happens, 3.28 is unmaintained so it won't get a fix.

I would expect main already has the fix, possibly 3.32.0.CR1 and maybe even 3.31, but I need to check this.

3.27 most likely doesn't have the fix yet, but it might be in the pipeline.

[beikov]

Here are a couple of related issues:

• https://hibernate.atlassian.net/browse/HHH-19895
• https://hibernate.atlassian.net/browse/HHH-19929
• https://hibernate.atlassian.net/browse/HHH-20041

[yrodiere]

Thanks. So fix versions of Hibernate ORM are:

• 7.1.15
• 7.2.1

The corresponding upgrades in Quarkus are:

• [3.27] Update Hibernate Search to 8.1.3.Final / Update Apache Avro to 1.12.1 / Update Hibernate ORM to 7.1.16.Final / Update Hibernate Reactive to 3.1.13.Final #52659 for 3.27.next (not released yet)
• Upgrade to Hibernate ORM 7.2.1 + Flyway integration test fix #52046 for 3.31.0

@danillob can you please check your problem is gone in Quarkus 3.31.0 or later?