{"id":"CVE-2022-24827","aliases":["GHSA-8xpj-9j9g-fc9r"],"url":"https://o3.security/vulnerability/CVE-2022-24827","summary":"SQL Injection in elide-datastore-aggregation","details":"### Impact\nWhen leveraging the following together:\n\n- Elide Aggregation Data Store for Analytic Queries\n- Parameterized Columns (A column that requires a client provided parameter)\n- A parameterized column of type TEXT\n\nThere is the potential for a hacker to provide a carefully crafted query that would bypass server side authorization filters through SQL injection.  A recent patch to Elide 6.1.2 allowed the '-' character to be included in parameterized TEXT columns.  This character can be interpreted as SQL comments ('--') and allow the attacker to remove the WHERE clause from the generated query and bypass authorization filters.\n\n### Patches\nA [fix](https://github.com/yahoo/elide/pull/2581) is provided in [Elide 6.1.4](https://github.com/yahoo/elide/releases/tag/6.1.4).\n\n### Workarounds\nThe vulnerability only exists for parameterized columns of type TEXT and only for analytic queries (CRUD is not impacted).   Workarounds include leveraging a different type of parameterized column (TIME, MONEY, etc) or not leveraging parameterized columns.\n\n### For more information\nIf you have any questions or comments about this advisory:\n* Open an issue in [elide](https://github.com/yahoo/elide)\n* Contact us in [Discord](https://discord.com/invite/3vh8ac57cc)\n","published":"2022-04-11T20:13:40Z","modified":"2026-08-12T03:51:38.797955518Z","cvss":{"score":8.1,"severity":"HIGH","vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H"},"epss":null,"cisaKev":null,"exploitsKnown":0,"affectedPackages":[{"ecosystem":"Maven","name":"com.yahoo.elide:elide-datastore-aggregation","fixedVersion":"6.1.4"}],"fix":{"url":"https://github.com/yahoo/elide/pull/2581","label":"yahoo/elide#2581"},"references":[{"type":"WEB","url":"https://github.com/yahoo/elide/releases/tag/6.1.4"},{"type":"ADVISORY","url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2022/24xxx/CVE-2022-24827.json"},{"type":"ADVISORY","url":"https://github.com/yahoo/elide/security/advisories/GHSA-8xpj-9j9g-fc9r"},{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2022-24827"},{"type":"FIX","url":"https://github.com/yahoo/elide/pull/2581"},{"type":"PACKAGE","url":"https://github.com/yahoo/elide"}],"provenance":{"sources":["OSV.dev","FIRST.org (EPSS)"],"lastVerified":"2026-08-12T03:51:38.797955518Z"}}