The same named field assignment error in jpa native like query

[qindongliang]

spring boot and jpa version is 2.5.3

query code：

    @Query(nativeQuery = true,
            value = "select userName as answer , LOCATE( :user, userName) as cnt from test where userName like %:user% ")
    List<GroupStatistics> testLikeQuery(@Param("user") String user);

enable logging trace in application.yml

logging:
  level:
    org.hibernate.type: TRACE

when my query user value is "tomcat", binding parameter logging show:

2023-03-14 11:41:34.042 [http-nio-8088-exec-1] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%tomcat%]
2023-03-14 11:41:34.043 [http-nio-8088-exec-1] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%tomcat%]

The value of the first named parameter is wrong because it should not carry %%，

[quaff]

Duplication of #1929

[schauder]

I agree, this is a duplicate.

[qindongliang]

@quaff @schauder Has anyone fixed this?

[schauder]

No, the linked issue is still open.

[klajdipaja]

@schauder I have opened a PR for #1929

EDIT: Closed the pull request as it did not sound like the best solution for the case.
My solution in the PR was to change the parameter names for queries that included repeated parameters but that would be misleading when looking the logs and the queries that where ran.
Example:
Query from user- > SELECT a FROM Article a WHERE a.title=:query OR a.overview LIKE %:query OR a.content LIKE %:escapedWord%
Transformed query - > SELECT a FROM Article a WHERE a.title=:query OR a.overview LIKE :query_ENDING_WITH OR a.content LIKE :query_CONTAINING