GHSA-4FQR-96Q8-XRFX
Possible SQL query truncation when a string is 4 GiB or larger
Overview
Description
sqlite3-ruby cast Ruby string lengths (long) to int before passing them to SQLite. On 64-bit platforms, a string of 4 GiB (2^32 bytes) or larger had its length wrap, so SQLite saw only the first length mod 2^32 bytes. An attacker who controls the length of a SQL string could truncate the query, for example dropping a trailing WHERE clause. The affected paths are:
- the SQL passed to Database#prepare, #execute, and related methods
- String and Blob values passed to Statement#bind_param and related methods
- String and Blob values returned from SQL functions and aggregates defined in Ruby (Database#create_function, #create_aggregate, and related methods)
AFTER PATCH
sqlite3 v2.10.2 raises RangeError when any of these strings is longer than INT_MAX bytes.
Credit
This issue was responsibly reported by Luke Jahnke from elttam.
Source: OX vulnerability database
Severity
MEDIUM
No CVSS vector in the source. Severity comes from the advisory.
Affected packages · 1
| Ecosystem | Package | Vulnerable | Fixed in |
|---|---|---|---|
| RubyGems | sqlite3 | — | 2.10.2 |
Open a package to see all its vulnerabilities.
Operating systems
No Linux distribution reports this ID.
References
- github.com https://github.com/sparklemotion/sqlite3-ruby/blob/main/CHANGELOG.md#2102--2026-10-26
- github.com https://github.com/sparklemotion/sqlite3-ruby/pull/762
- github.com https://github.com/sparklemotion/sqlite3-ruby/releases/tag/v2.10.2
- github.com https://github.com/sparklemotion/sqlite3-ruby/security/advisories/GHSA-4fqr-96q8-xrfx
- rubygems.org https://rubygems.org/gems/sqlite3/versions/2.10.2
OX Radar and Response Center
Find threats in your stack.
OX Radar can check high-priority threats, like critical package CVEs, against your context.
Each incident is marked Detected or Not Detected with a remediation plan and proof all tracked in the Response Center.