CVE-2022-35956
MEDIUMupdate_by_case < 0.1.3 - SQL Injection via Unsanitized Case Statement
Title source: llmDescription
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.
References (2)
Core 2
Core References
Third Party Advisory x_refsource_confirm
https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8
Release Notes, Third Party Advisory x_refsource_misc
https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable
Scores
CVSS v3
5.8
EPSS
0.0023
EPSS Percentile
45.6%
Attack Vector
NETWORK
CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L
CISA SSVC
Vulnrichment
Exploitation
none
Automatable
no
Technical Impact
partial
Details
CWE
CWE-89
Status
published
Products (2)
rubygems/update_by_case
0 - 0.1.3RubyGems
update_by_case_project/update_by_case
< 0.1.3
Published
Aug 12, 2022
Tracked Since
Feb 18, 2026