by Kastro
Paper/Archive/CVE-2022-35956

CVE-2022-35956

camilova activerecord-update-by-case — update_by_case before 0.1.3 vulnerable to sql injection

EPSS 0.6%CVSS 9.8
critical.is priorityof 100
40
CVSS 9.8 (NVD)9.8 / 10 × 3029.4Not in CISA KEV+300.0EPSS percentile 51.1.511 × 2010.2No public exploit+100.0SSVC exploitation: none+100.0
Description · from the CVE record

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.

Affected

ProductAffectedFixed inSource
activerecord-update-by-case< 0.1.3–CNA

Scores by source

NVD9.8CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
GitHub_M (CNA)5.8CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L
CISA ADPSSVCExploitation: none · Automatable: no · Technical impact: partial

References

refgithub.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8refgithub.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable