Skip to content
OpenAdvisories
Medium · 5.8 CVE-2022-35956 EUVD-2022-6465GHSA-33wh-w4m7-c6r8

update_by_case before 0.1.3 vulnerable to sql injection

Published Aug 12, 2022 · Updated Apr 23, 2025 · Assigned by GitHub_M

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 products

VendorProductAffectedFixed
camilova activerecord-update-by-case < 0.1.3 —

Affected packages

EcosystemPackageAffectedFixedRecord
RubyGems update_by_case < 0.1.3 0.1.3 GHSA-33wh-w4m7-c6r8

References