Security
Headlines
HeadlinesLatestCVEs

Headline

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.

ghsa
#sql#git#ruby
  1. GitHub Advisory Database
  2. GitHub Reviewed
  3. CVE-2022-35956

update_by_case before 0.1.3 can be vulnerable to sql injection

Package

bundler update_by_case (RubyGems)

Affected versions

< 0.1.3

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.

References

  • GHSA-33wh-w4m7-c6r8

Weaknesses

GHSA ID

GHSA-33wh-w4m7-c6r8

Source code

Related news

CVE-2022-35956: Release v0.1.3-stable · camilova/activerecord-update-by-case

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.