Description
Querydsl 5.1.0 and OpenFeign Querydsl 6.8 allows SQL/HQL injection in orderBy in JPAQuery. NOTE: this is disputed by a Querydsl community member because the product is not intended to defend against a developer who uses untrusted input directly in query construction.
Affected packages
| Ecosystem | Package | Affected | Fixed | Record |
|---|---|---|---|---|
| Maven | com.querydsl:querydsl-apt | <= 5.1.0 | — | GHSA-6q3q-6v5j-h6vg |
| Maven | com.querydsl:querydsl-jpa | <= 5.1.0 | — | GHSA-6q3q-6v5j-h6vg |
| Maven | io.github.openfeign.querydsl:querydsl-apt | >= 6.0.0.M1, < 6.10.1 | 6.10.1 | GHSA-6q3q-6v5j-h6vg |
| Maven | io.github.openfeign.querydsl:querydsl-apt | < 5.6.1 | 5.6.1 | GHSA-6q3q-6v5j-h6vg |
| Maven | io.github.openfeign.querydsl:querydsl-jpa | >= 6.0.0.M1, < 6.10.1 | 6.10.1 | GHSA-6q3q-6v5j-h6vg |
| Maven | io.github.openfeign.querydsl:querydsl-jpa | < 5.6.1 | 5.6.1 | GHSA-6q3q-6v5j-h6vg |
References
- https://github.com/querydsl/querydsl/releases/tag/QUERYDSL_5_1_0
- https://www.csirt.sk/querydsl-java-library-vulnerability-permits-sql-hql-injection.html
- https://github.com/querydsl/querydsl/issues/3757
- https://github.com/OpenFeign/querydsl/
- https://github.com/OpenFeign/querydsl/releases/tag/5.6.1
- https://github.com/OpenFeign/querydsl/pull/742
- https://github.com/advisories/GHSA-6q3q-6v5j-h6vg
- https://github.com/OpenFeign/querydsl/releases/tag/6.10.1
- https://github.com/OpenFeign/querydsl/pull/743
- https://github.com/spring-projects/spring-data-jpa/issues/3693