| OK, so I talked to Steve and here we are:
- the JPA spec does not allow subqueries in the SELECT clause
- us supporting that was more of a bug than a feature (it was a side effect of a bug we fixed during the 5.4 cycle)
- that being said, as it used to work (I checked against 5.2, 5.1 and 5.0 and we support that since at least 5.0), we'd better make it work again
- we now have a JPA compliance mode so we will throw an exception if in JPA compliance mode and go back to the previous behavior if the JPA compliance mode is not enabled
- the JPA compliance mode is not enabled by default so subqueries in select will work again with a default setup
eXsio thanks for testing the CR and raising this issue. |