In short
- CVE-2022-35956 is a CRITICAL (CVSS 9.8) vulnerability affecting update_by_case, update by case (update by case project).
- Chance of exploitation in the next 30 days (EPSS): 0.65%, higher than 51.4% of all vulnerabilities.
- Fix: update to 0.1.3 or later.
Description
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.
NVD description
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.
Running one of these products? Scan your site to see whether it exposes a vulnerable version.
Scan my site free