API with Pagination giving error after spring-boot-starter-jpa version upgrade. about spring-data-jpa

[mp911de]

Spring Data JPA isn't in the business of generating SQL statements.

Please enable Hibernate SQL logging and attach a stack trace. While I am afraid that this is a Hibernate issue, we still want to make sure that Spring isn't the one that causes the issue.

[rswain90]

Thanks for looking my issue. I just attached logs which is before & after Spring upgrade. I am surprised why its failing after just spring upgrade without any code changes. Please let me know if you need any more details.
BeforeSpringUpgradeLog.txt
AfterSpringUpgradeLog.txt

[mp911de]

The main difference is count(distinct productsou0_.id) as col_0_0_ vs.

        count(distinct productsou0_.attr_id,
        productsou0_.id,
        productsou0_.map_key) as col_0_0_

Can you please provide a minimal reproducer that contains the entity model and the affected repository query method?

[rswain90]

@mp911de I tried to analysis more & found that after spring boot upgrade its taking primary key(composite) of er_material table & before it was taking primary key of ed_material for getting count. As its taking composite primary key, query is failing for Count(Col1,col2,col3).
Old Query
from
er_material productsou0_
inner join
ed_material material1_
on productsou0_.id=material1_.id

As a resolution we changed our query like below & it starting picking primary key of ed_material.
from
ed_material material1_
inner join
er_material productsou0_
on productsou0_.id=material1_.id

Thanks you so much for looking my issue.