Skip to content
OpenAdvisories
Low · 2.1 CVE-2026-80227 EEF-CVE-2026-80227EUVD-2026-68187GHSA-76wx-w7ww-5xfq

SQL string_trim removes only spaces, diverging from in-memory trimming in AshSql

Published Aug 30, 2026 · Updated Aug 31, 2026 · Assigned by EEF

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.

Affected products

VendorProductAffectedFixed
ash-project ash_sql 0.1.0 – < 0.7.1 0.7.1

Affected packages

EcosystemPackageAffectedFixedRecord
Hex ash_sql >= 0.1.0, < 0.7.1 0.7.1 EEF-CVE-2026-80227

References