Hello, I’ve noticed an issue in mysql and mariadb going from hibernate 5.4.10 to 5.4.11 This issue still exists also in the most recent 5.4.17 It looks like extra parentheses are added to the select columns corresponding to an “collection IS NOT EMPTY” check in JPQL, where the collection is a @On…

I can confirm this issue after updating from 5.4.10 to 5.4.17 with “collection IS EMPTY”, i get the same error.

Hi, just wondering if I can file this somewhere so it can get triaged. Thanks

Potential mysql bug in Hibernate 5.4.11-Final

kerickson August 1, 2020, 5:32am 4

I filed a bug entry with testcase here. Please vote for it if you’re having this problem for mysql

Topic		Replies	Views
SQLSyntaxErrorException: Unknown column <columnName> in field list Hibernate ORM	20	27002	November 14, 2018
Hibernate 5.4.10 (HH-12895 ) Regression Hibernate ORM	2	464	December 11, 2019
Problem in loading collection using loader query after migrating from hibernate4 to hibernate5 Hibernate ORM	2	317	December 8, 2023
I/O Error when using Hibernate Criteria on big database Hibernate ORM	12	1547	September 21, 2019
Subselect error with Postgres Hibernate ORM	5	3275	May 17, 2018