Status: Waiting for Review
Affects Version/s: None
Fix Version/s: None
Since we upgrade our Spring boot projet to 2.0.3 (before 1.5.9) and upgraded the Spring Data dependency 2.0.8-RELEASE, some native pageable queries doesn't work anymore.
First I've removed the hint "-- #pageable" and keep only the Pageable parameter (like describe in https://jira.spring.io/browse/DATAJPA-928) and its work like a charm for most of native queries.
But i notice for native queries use an ORDER BY in inner join Spring data adds the final query with ", mycolumn" instead of "ORDER BY mycolumn". See QueryUtils
I missed somethings ?
Please find a sample Maven projet in attachment base on the Spring Getting Started JPA
I added two functions in the repository:
=> JIRA checker blocks SQL queries i had some wrong sql selec(t) order ...
findAllCustomerWithPagination => ok
findAllCustomerWithOrderByAndPagination => failed
Note also that the alias of order by c2.id is taken from the inner order
The final working query should be :