Goal Reached Thanks to every supporter — we hit 100%!

Goal: 1000 CNY · Raised: 1359 CNY

100%
Buy Us a Coffee

CVE-2026-80227— SQL string_trim removes only spaces, diverging from in-memory trimming in AshSql

Quick assessment

Affected
ash-project ash_sql
Exploitation
No confirmed in-the-wild exploitation; assess based on exposure
Recommended action
Check the vendor advisory and references for a fixed version. If immediate upgrade is impossible, restrict exposure and increase monitoring.

Ash Framework AshSql是Ash Framework组织的一个数据库系统。 Ash Framework AshSql 0.1.0版本至0.7.1之前版本存在处理逻辑错误漏洞，该漏洞源于string_trim/1函数编译的SQL正则表达式将\s错误解释为单个空格而非空白字符类，导致SQL与内存修剪行为不一致，可能允许用户通过填充制表符、换行、回车或换页字符绕过修剪后的唯一性或相等性检查。

CVSS 2.1 · Low EPSS 0.37% · P29

Possible ATT&CK Techniques 1 AI

T1078 · Valid Accounts

Affected Version Matrix 2

VendorProduct Version RangeStatus
ash-project ash_sql 0.1.0< 0.7.1 affected
dd092ed273dec7bd2194352f24a39229fc8ae68b< 1b11b5d8bc5321e2e6acac21594ef08f61986117 affected
Get alerts for future matching vulnerabilities Log in to subscribe

I. Basic Information for CVE-2026-80227

Vulnerability Information
Have questions about the vulnerability? See if Shenlong's analysis helps!
View Shenlong Deep Dive ↗

Although we use advanced large model technology, its output may still contain inaccurate or outdated information.Shenlong tries to ensure data accuracy, but please verify and judge based on the actual situation.

Vulnerability Title
SQL string_trim removes only spaces, diverging from in-memory trimming in AshSql
Source: CVE Program / CVE List V5
Vulnerability 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.
Source: CVE Program / CVE List V5
CVSS Information
CVSS:4.0/AV:L/AC:L/AT:P/PR:N/UI:N/VC:N/VI:L/VA:N/SC:N/SI:N/SA:N
Source: CVE Program / CVE List V5
Vulnerability Type
不充分的比较
Source: CVE Program / CVE List V5
Vulnerability Title
Ash Framework AshSql 处理逻辑错误漏洞
Source: CNNVD (China National Vulnerability Database)
Vulnerability Description
Ash Framework AshSql是Ash Framework组织的一个数据库系统。 Ash Framework AshSql 0.1.0版本至0.7.1之前版本存在处理逻辑错误漏洞，该漏洞源于string_trim/1函数编译的SQL正则表达式将\s错误解释为单个空格而非空白字符类，导致SQL与内存修剪行为不一致，可能允许用户通过填充制表符、换行、回车或换页字符绕过修剪后的唯一性或相等性检查。
Source: CNNVD (China National Vulnerability Database)
CVSS Information
N/A
Source: CNNVD (China National Vulnerability Database)
Vulnerability Type
N/A
Source: CNNVD (China National Vulnerability Database)

Affected Products

Vendor Product Affected Versions CPE Subscribe
ash-project ash_sql 0.1.0 ~ 0.7.1 cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*
ash-project ash_sql dd092ed273dec7bd2194352f24a39229fc8ae68b ~ 1b11b5d8bc5321e2e6acac21594ef08f61986117 cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*

II. Public POCs for CVE-2026-80227

# POC Description Source Link Shenlong Link
AI-Generated POC Premium

No public POC found.

Login to generate AI POC

III. Intelligence Information for CVE-2026-80227

请登录查看更多情报信息。

Patches & Fixes for CVE-2026-80227 (1)

Vendor Advisories for CVE-2026-80227 (2)

Vendor Pages for CVE-2026-80227 (1)

Same Patch Batch · ash-project · 2026-08-30 · 20 CVEs total

CVE-2026-81636 8.7 HIGH Query-complexity limit bypass via first/last pagination arguments in AshGraphql enables de
CVE-2026-78699 7.2 HIGH rename_tenant returns :ok on a failed rename, enabling cross-tenant access in AshPostgres
CVE-2026-80223 7.1 HIGH Cross-tenant subscription disclosure in AshGraphql authorizes notifications in memory with
CVE-2026-78693 6.9 MEDIUM Incomplete redaction re-attaches the original error path in AshGraphql, leaking internal f
CVE-2026-81633 6.9 MEDIUM Unhandled KeyError in AshGraphql relay node resolution crashes queries via an unknown type
CVE-2026-77970 5.9 MEDIUM Sensitive fields nested in embedded values are not redacted in AshPaperTrail versions
CVE-2026-78038 5.9 MEDIUM Job argument injection via :args overrides primary_key and tenant in AshOban
CVE-2026-78228 5.9 MEDIUM Unbounded handle_error recursion enables denial of service in AshOban triggers
CVE-2026-77454 5.9 MEDIUM exists/2 predicate silently dropped on limited relationships with a parent() filter in Ash
CVE-2026-75847 5.9 MEDIUM Sensitive attribute values stored in a non-sensitive public changes map in AshPaperTrail
CVE-2026-81319 5.9 MEDIUM Unsafe deserialization of decrypted terms enables node DoS in AshCloak
CVE-2026-81643 2.3 LOW Broken access control in AshGraphql subscription batcher applies authorization suppression
CVE-2026-82367 2.3 LOW Re-entrant synchronous publish in AshGraphql subscription batcher delivers one subscriber'
CVE-2026-81316 2.1 LOW Same-named aggregates with differing filters are conflated in AshSql
CVE-2026-81322 2.1 LOW Cloaked plaintext leaks through a non-sensitive action argument in AshCloak
CVE-2026-78691 2.1 LOW Unescaped backslash allows LIKE wildcard injection in AshSql string search
CVE-2026-81318 2.1 LOW Distinct-query aggregate drops the tenant schema prefix, leaking across tenants in AshSql
CVE-2026-77846 2.1 LOW JSON path injection via unescaped get_path segments in AshSqlite
CVE-2026-77831 2.1 LOW Algorithmic-complexity denial of service in AshPaperTrail full-diff list tracking

IV. Related Vulnerabilities

Same product: ash_sql
Same vendor: ash-project
Same weakness: CWE-697

V. Comments for CVE-2026-80227

No comments yet

Leave a comment