# CVE-2019-9936: lemon: In SQLite 3.27.2, running fts5 prefix queries inside a transaction could trigger a heap-based buffer over-read in fts...

CVE-2019-9936 is fixed in 4 products on 1 platform, first by lemon 3.22.0-1ubuntu0.1, released May 30, 2019. It is not reported as exploited. Patch Radar priority: Routine.

- Web page: https://patchblox.com/security/cve/CVE-2019-9936
- Priority: Routine
- CVSS: n/a (Medium)
- EPSS: 0.0535
- CISA KEV: not listed
- Exploited (vendor report): no
- Publicly disclosed: no
- Published: Mar 21, 2019

## Description

In SQLite 3.27.2, running fts5 prefix queries inside a transaction could trigger a heap-based buffer over-read in fts5HashEntrySort in sqlite3.c, which may lead to an information leak. This is related to ext/fts5/fts5_hash.c.

## Where it's fixed

| Platform | Product | Fixed in | Fix | Released |
|---|---|---|---|---|
| Linux | lemon Ubuntu 18.04.6 LTS (bionic) | 3.22.0-1ubuntu0.1 | [lemon 3.22.0-1ubuntu0.1](https://patchblox.com/security/data/fix/linux/ubuntu-bionic-lemon-3.22.0-1ubuntu0.1.md) | May 30, 2019 |
| Linux | libsqlite3-0 Ubuntu 18.04.6 LTS (bionic) | 3.22.0-1ubuntu0.1 | [libsqlite3-0 3.22.0-1ubuntu0.1](https://patchblox.com/security/data/fix/linux/ubuntu-bionic-libsqlite3-0-3.22.0-1ubuntu0.1.md) | May 30, 2019 |
| Linux | libsqlite3-tcl Ubuntu 18.04.6 LTS (bionic) | 3.22.0-1ubuntu0.1 | [libsqlite3-tcl 3.22.0-1ubuntu0.1](https://patchblox.com/security/data/fix/linux/ubuntu-bionic-libsqlite3-tcl-3.22.0-1ubuntu0.1.md) | May 30, 2019 |
| Linux | sqlite3 Ubuntu 18.04.6 LTS (bionic) | 3.22.0-1ubuntu0.1 | [sqlite3 3.22.0-1ubuntu0.1](https://patchblox.com/security/data/fix/linux/ubuntu-bionic-sqlite3-3.22.0-1ubuntu0.1.md) | May 30, 2019 |

---

Data as of 2026-11-07T18:46:35Z UTC. Source: Patchblox Patch Radar (https://patchblox.com/security/patch-radar). Patchblox finds out-of-date software on Windows, macOS and Linux and updates it through release rings: https://patchblox.com/demo

Free to use with attribution: show "Data: Patchblox Patch Radar" with a link to https://patchblox.com/security/patch-radar. Terms, including what needs a written agreement: https://patchblox.com/security/patch-radar/use-the-data

Product names, logos and trademarks shown on Patch Radar belong to their respective owners. They are used only to identify the software each security fix applies to and to help readers find their platform. Their use does not imply any affiliation with, or endorsement by, those owners, and Patchblox is not affiliated with any of them.