NamedParameterUtils.parseSqlStatement should parse :{x} style parameter correctly [SPR-16663]

[spring-projects-issues]

Zhang Jie opened SPR-16663 and commented

In my opinion, we should parse :{x} style parameter as x is parameter using NamedParameterUtils.parseSqlStatement,
so the condition j - i > 2 is the correct condition, not j - i > 3, because if i is the index of : in :{x}, and j is the index of } in :{x},
j - i == 3 is true.

---

Affects: 4.3.14, 5.0.4

Issue Links:

• NamedParameterJdbcTemplate fails on PostgreSQL array [SPR-16340] #20887 NamedParameterJdbcTemplate fails on PostgreSQL array

Referenced from: pull request #1758, and commits 82cb5db, f3dd22d

Backported to: 4.3.15

[spring-projects-issues]

Juergen Hoeller commented

Good catch! Merged for 5.0.5 now; I'll backport it to 4.3.15 later today.

[spring-projects-issues]

Zhang Jie commented

Thanks for responsing so quickly, I have added some text formating in description.
PS: If I could preview the description, I will not have edited the description so much times.