github_osv/GHSA-33wh-w4m7-c6r8
update_by_case before 0.1.3 can be vulnerable to sql injection
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.
gitlab/gem/update_by_case/CVE-2022-35956
Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
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.
gitlab/gem/update_by_case/GMS-2022-3603
Duplicate
This advisory duplicates another.