Querying with "IS NOT EMPTY" jpql against a @OneToMany mappedBy collection is failing in mysql for Hibernate v. 5.4.11 and up

Description

Please see attached test files.

In the attached files, A Stuff has multiple Things. Each of the Things has a parental reference to their Stuff.
The test attempts to do an IS EMPTY check in JPQL against the stuff's @OneToMany mappedBy collection of things. This is the resulting error:

Tested against mysql Ver 14.14 Distrib 5.6.38, for Win64 (x86_64)

Environment

None

Assignee

Unassigned

Reporter

Kean Erickson

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Worked in

5.4.10
5.4.21

Components

Affects versions

Priority

Minor
Configure