Moderate severityNVD Advisory· Published Aug 12, 2022· Updated Apr 23, 2025
update_by_case before 0.1.3 vulnerable to sql injection
CVE-2022-35956
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.
Affected packages
Versions sourced from the GitHub Security Advisory.
| Package | Affected versions | Patched versions |
|---|---|---|
update_by_caseRubyGems | < 0.1.3 | 0.1.3 |
Affected products
1- Range: < 0.1.3
Patches
0No patches discovered yet.
Vulnerability mechanics
AI mechanics synthesis has not run for this CVE yet.
References
5- github.com/advisories/GHSA-33wh-w4m7-c6r8ghsaADVISORY
- nvd.nist.gov/vuln/detail/CVE-2022-35956ghsaADVISORY
- github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stableghsax_refsource_MISCWEB
- github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8ghsax_refsource_CONFIRMWEB
- github.com/rubysec/ruby-advisory-db/blob/master/gems/update_by_case/CVE-2022-35956.ymlghsaWEB
News mentions
0No linked articles in our index yet.