CVE-2022-35956 json
update_by_case before 0.1.3 vulnerable to sql injection
published 2022-08-11 4 y ago modified 2026-06-17 4 mo ago also GHSA-33wh-w4m7-c6r8 , EUVD-2022-6465
- cvss
- 5.8
- version 3.1, CNA
- cisa kev
- Not listed
- not in CISA's catalog
- epss
- 0.6%
- EPSS 0.6% chance of exploitation in 30 days, percentile 51%
- public exploits
- 0
- none known
Summary
This Rails gem adds two methods to the ActiveRecord::Base class that allow you to update many records on a single database hit, using a case sql statement for it. Before version 0.1.3 `update_by_case` gem used custom sql strings, and it was not sanitized, making it vulnerable to sql injection. Upgrade to version >= 0.1.3 that uses `Arel` instead to construct the resulting sql statement, with sanitized sql.
Patch / fix
- rubygems update_by_case 0.1.3
- update_by_case_project update_by_case 0.1.3
CISA SSVC
- Exploitation
- none
- Automatable
- no
- Technical impact
- partial
- Assessed
- 18 mo ago
Exploit prediction
0.65% chance of exploitation in the next 30 days, higher than 51% of all scored CVEs (FIRST EPSS, 2026-11-08).
CVSS scores
| assigned by | version | score | vector |
|---|---|---|---|
| CNA | 3.1 | 5.8 | CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L |
| NVD | 3.1 | 9.8 | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H |
| GitHub | 3.1 | 5.8 | CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L |
Affected packages
| ecosystem | package | affected | fixed in |
|---|---|---|---|
| rubygems | update_by_case | <0.1.3 |
0.1.3 |
Affected products
- camilova activerecord-update-by-case
Classification
- Weakness
-
- CWE-89 Improper Neutralization of Special Elements used in an SQL Command
References
-
github.com
/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8
web, third-party-advisory
-
github.com
/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable
web, release-notes, third-party-advisory
-
nvd.nist.gov
/vuln/detail/CVE-2022-35956
advisory
-
github.com
/camilova/activerecord-update-by-case
package
-
github.com
/rubysec/ruby-advisory-db/blob/master/gems/update_by_case/CVE-2022-35956.yml
web
Sources
- CVE List CVE-2022-35956
- GitHub Advisory GHSA-33wh-w4m7-c6r8
- NVD CVE-2022-35956
Fencer Vulns keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.