CVE-2026-80227 SQL string_trim removes only spaces, diverging from in-memory trimming in AshSql
- Published
- Updated
- Exploit status
- No public exploit known
- CISA SSVC
- Proof of concept public · automatable: no · technical impact: partial
Description
Incorrect Comparison vulnerability in ash-project ash_sql allows a user to pad a string field with tab, newline, carriage-return, or form-feed characters and pass a trimmed uniqueness or equality check in the database that the same expression would fail in memory (or the reverse).
string_trim/1 compiles to REGEXP_REPLACE patterns built from an Elixir string in which \s is the escape for a single space (codepoint 32), not a regex whitespace class. The generated SQL therefore removes only literal spaces and leaves tabs, newlines, carriage returns, and form feeds in place, whereas String.trim/1 in Elixir removes them all. Any Ash filter, validation, or identity that relies on string_trim/1 then behaves differently depending on whether Ash pushes the expression down to SQL or evaluates it in memory, so padded input can register a near-duplicate value or slip past a trimmed comparison.
This issue affects ash_sql: from 0.1.0 before 0.7.1.
Upgrade path
1 package: 1 fixed.
| Package | Affected | Fixed in | Status |
|---|---|---|---|
| ash-project ash sql | >= 0.1.0, < 0.7.1; >= dd092ed273dec7bd2194352f24a39229fc8ae68b, < 1b11b5d8bc5321e2e6acac21594ef08f61986117 | 0.7.1, 1b11b5d8bc5321e2e6acac21594ef08f61986117 | Fixed |
Affected products
| Product | Affected versions | Fixed in |
|---|---|---|
| ash-project ash sql | >= 0.1.0, < 0.7.1 | 0.7.1 |
| ash-project ash sql | >= dd092ed273dec7bd2194352f24a39229fc8ae68b, < 1b11b5d8bc5321e2e6acac21594ef08f61986117 | 1b11b5d8bc5321e2e6acac21594ef08f61986117 |
References
- github.com exploit related vendor-advisory
- EEF CNA record for CVE-2026-80227 related
- OSV record EEF-CVE-2026-80227 related
- Fix commit 1b11b5d in ash-project/ash_sql patch
- Introducing commit dd092ed in ash-project/ash_sql related
- ENISA EUVD EUVD-2026-68187 third-party-advisory