| 제목 | GitHub dresende node-sql-query 0.1.25-0.1.28 SQL Injection |
|---|
| 설명 | An SQL fragment injection vulnerability exists in the joinType option of the SelectQuery.from() method.
The library allows developers to specify a JOIN type through an options object:
.from("orders", "user_id", "id", {
joinType: "LEFT"
})
However, the value of joinType is not checked against an allow-list of valid JOIN types. During SQL generation, the value is only converted to uppercase and is then concatenated directly into the generated SQL statement.
The affected code is:
if (from.opts && from.opts.joinType) {
query.push(from.opts.joinType.toUpperCase());
}
query.push("JOIN");
The call to toUpperCase() is not a security validation mechanism. It does not remove SQL keywords, comments, parentheses, subqueries, or other attacker-controlled SQL syntax.
If a downstream application passes untrusted data, such as an HTTP request parameter or JSON property, into joinType, an attacker can inject arbitrary SQL fragments into the generated SELECT statement. |
|---|
| 원천 | ⚠️ https://github.com/windhxy/CVE-my/issues/2 |
|---|
| 사용자 | windhxy (UID 90128) |
|---|
| 제출 | 2026. 06. 23. AM 03:58 (2 개월 ago) |
|---|
| 모더레이션 | 2026. 08. 08. PM 06:29 (2 months later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 387190 [dresende node-sql-query 0.1.25/0.1.26/0.1.27/0.1.28 Request Parameter lib/Select.js SelectQuery.from/SelectQuery.build SQL 주입] |
|---|
| 포인트들 | 20 |
|---|