{"id":"EEF-CVE-2026-78691","summary":"Unescaped backslash allows LIKE wildcard injection in AshSql string search","details":"## Summary\n\nImproper Neutralization of Special Elements in Data Query Logic vulnerability in ash-project ash_sql allows a user who supplies a search term to `contains/2`, `string_starts_with/2`, or `string_ends_with/2` to inject live SQL `LIKE` wildcards, turning a literal substring search into an attacker-controlled pattern match.\n\nThe escape helpers in `AshSql.Expr` prefix `%` and `_` with a backslash but never escape a backslash already present in the input. Because backslash is the default `LIKE` escape character, the escaping defeats itself: the input `\\%` becomes the pattern fragment `\\\\%`, where `\\\\` is a literal backslash and the attacker's `%` remains a live wildcard. The search value stays parameterized, so this is confined to the LIKE pattern grammar rather than full SQL. An attacker can widen matches to probe values, slip past a negated `contains(...)` guard, or crash the query with a trailing lone backslash.\n\nThis issue affects ash_sql: from 0.1.1-rc.10 before 0.7.1.\n\n## Configurations\n\nAn application must pass untrusted input as the search term of `contains/2`, `string_starts_with/2`, or `string_ends_with/2` (for example a user-controlled substring search).","aliases":["CVE-2026-78691","GHSA-5jgp-7mhc-6qqh"],"modified":"2026-09-08T03:45:09.848297727Z","published":"2026-08-30T11:55:20.331Z","database_specific":{"cwe_ids":["CWE-943"],"capec_ids":["CAPEC-116"],"cpe_ids":["cpe:2.3:a:ash-project:ash_sql:*:*:*:*:*:*:*:*"]},"references":[{"type":"ADVISORY","url":"https://github.com/ash-project/ash_sql/security/advisories/GHSA-5jgp-7mhc-6qqh"},{"type":"WEB","url":"https://cna.erlef.org/cves/CVE-2026-78691.html"},{"type":"FIX","url":"https://github.com/ash-project/ash_sql/commit/d95c55c64b1b42cc2fd30211a4913f3145156cd4"},{"type":"PACKAGE","url":"https://hex.pm/packages/ash_sql"}],"affected":[{"package":{"name":"ash_sql","ecosystem":"Hex","purl":"pkg:hex/ash_sql"},"ranges":[{"type":"SEMVER","events":[{"introduced":"0.1.1-rc.10"},{"fixed":"0.7.1"}]}],"versions":["0.1.1-rc.10","0.1.1-rc.11","0.1.1-rc.12","0.1.1-rc.13","0.1.1-rc.14","0.1.1-rc.15","0.1.1-rc.16","0.1.1-rc.17","0.1.1-rc.18","0.1.1-rc.19","0.1.1-rc.20","0.1.2","0.1.3","0.2.0","0.2.1","0.2.10","0.2.11","0.2.12","0.2.13","0.2.14","0.2.15","0.2.16","0.2.17","0.2.18","0.2.19","0.2.2","0.2.20","0.2.21","0.2.22","0.2.23","0.2.24","0.2.25","0.2.26","0.2.27","0.2.28","0.2.29","0.2.3","0.2.30","0.2.31","0.2.32","0.2.33","0.2.34","0.2.35","0.2.36","0.2.37","0.2.38","0.2.39","0.2.4","0.2.40","0.2.41","0.2.42","0.2.43","0.2.44","0.2.45","0.2.46","0.2.47","0.2.48","0.2.49","0.2.5","0.2.50","0.2.51","0.2.52","0.2.53","0.2.54","0.2.55","0.2.56","0.2.57","0.2.58","0.2.59","0.2.6","0.2.60","0.2.61","0.2.62","0.2.63","0.2.64","0.2.65","0.2.66","0.2.67","0.2.68","0.2.69","0.2.7","0.2.70","0.2.71","0.2.72","0.2.73","0.2.74","0.2.75","0.2.76","0.2.77","0.2.78","0.2.79","0.2.8","0.2.80","0.2.81","0.2.82","0.2.83","0.2.84","0.2.85","0.2.86","0.2.87","0.2.88","0.2.89","0.2.9","0.2.90","0.2.91","0.2.92","0.2.93","0.3.0","0.3.1","0.3.10","0.3.11","0.3.12","0.3.13","0.3.14","0.3.15","0.3.16","0.3.2","0.3.3","0.3.4","0.3.5","0.3.6","0.3.7","0.3.8","0.3.9","0.4.0","0.4.1","0.4.2","0.4.3","0.4.4","0.4.5","0.5.0","0.5.1","0.5.2","0.5.3","0.5.4","0.5.5","0.6.0","0.6.1","0.6.2","0.6.3","0.6.4","0.6.5","0.6.6","0.6.7","0.6.8","0.6.9","0.7.0"],"database_specific":{"source":"https://cna.erlef.org/osv/EEF-CVE-2026-78691.json"}},{"ranges":[{"type":"GIT","repo":"https://github.com/ash-project/ash_sql","events":[{"introduced":"cfc7da474c5be2190fd62664a83a689377a8d512"},{"fixed":"d95c55c64b1b42cc2fd30211a4913f3145156cd4"}]}],"versions":["v0.7.0","v0.6.9","v0.6.8","v0.6.7","v0.6.6","v0.6.5","v0.6.4","v0.6.3","v0.6.2","v0.6.1","v0.6.0","v0.5.5","v0.5.4","v0.5.3","v0.5.2","v0.5.1","v0.5.0","v0.4.5","v0.4.4","v0.4.3","v0.4.2","v0.4.1","v0.4.0","v0.3.16","v0.3.15","v0.3.14","v0.3.13","v0.3.12","v0.3.11","v0.3.10","v0.3.9","v0.3.8","v0.3.7","v0.3.6","v0.3.5","v0.3.4","v0.3.3","v0.3.2","v0.3.1","v0.3.0","v0.2.93","v0.2.92","v0.2.91","v0.2.90","v0.2.89","v0.2.88","v0.2.87","v0.2.86","v0.2.85","v0.2.84","v0.2.83","v0.2.82","v0.2.81","v0.2.80","v0.2.79","v0.2.78","v0.2.77","v0.2.76","v0.2.75","v0.2.74","v0.2.73","v0.2.72","v0.2.71","v0.2.70","v0.2.69","v0.2.68","v0.2.67","v0.2.66","v0.2.65","v0.2.64","v0.2.63","v0.2.62","v0.2.61","v0.2.60","v0.2.59","v0.2.58","v0.2.57","v0.2.56","v0.2.55","v0.2.54","v0.2.53","v0.2.52","v0.2.51","v0.2.50","v0.2.49","v0.2.48","v0.2.47","v0.2.46","v0.2.45","v0.2.44","v0.2.43","v0.2.41","v0.2.39","v0.2.38","v0.2.37","v0.2.36","v0.2.35","v0.2.34","v0.2.33","v0.2.32","v0.2.31","v0.2.30","v0.2.29","v0.2.28","v0.2.27","v0.2.26","v0.2.25","v0.2.24","v0.2.23","v0.2.22","v0.2.21","v0.2.20","v0.2.19","v0.2.18","v0.2.17","v0.2.16","v0.2.15","v0.2.14","v0.2.12","v0.2.11","v0.2.10","v0.2.9","v0.2.8","v0.2.7","v0.2.6","v0.2.5","v0.2.4","v0.2.3","v0.2.2","v0.2.1","v0.2.0","v0.1.3","v0.1.2","v0.1.1-rc.20","v0.1.1-rc.19","v0.1.1-rc.18","v0.1.1-rc.17","v0.1.1-rc.16","v0.1.1-rc.15","v0.1.1-rc.14","v0.1.1-rc.13","v0.1.1-rc.12","v0.1.1-rc.11","v0.1.1-rc.10"],"database_specific":{"source":"https://cna.erlef.org/osv/EEF-CVE-2026-78691.json"}}],"schema_version":"1.9.0","severity":[{"type":"CVSS_V4","score":"CVSS:4.0/AV:L/AC:L/AT:P/PR:N/UI:N/VC:L/VI:N/VA:N/SC:N/SI:N/SA:N"}],"credits":[{"name":"Peter Ullrich","type":"FINDER"},{"name":"Peter Ullrich","type":"REPORTER"},{"name":"Zach Daniel / Ash Project","type":"REMEDIATION_DEVELOPER"},{"name":"Jonatan Männchen / EEF","type":"COORDINATOR"}]}