Description
flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).
Fixed in Linux distributions
Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.
Debian
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Debian 14 | chromium | 80.0.3987.106-1 | — |
| Debian 14 | sqlite3 | 3.30.1+fossil191229-1 | — |
| Debian 13 | chromium | 80.0.3987.106-1 | — |
| Debian 13 | sqlite3 | 3.30.1+fossil191229-1 | — |
| Debian 12 | chromium | 80.0.3987.106-1 | — |
| Debian 12 | sqlite3 | 3.30.1+fossil191229-1 | — |
| Debian 10 | chromium | 80.0.3987.132-1~deb10u1 | DSA-4638-1 |
Ubuntu
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu 18.04 LTS | sqlite3 | 3.22.0-1ubuntu0.3 | USN-4298-1 |
| Ubuntu 16.04 LTS | sqlite3 | 3.11.0-1ubuntu1.4 | USN-4298-1 |
Red Hat
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 8 | lemon +4 | 3.26.0-6.el8 | RHSA-2020:1810 |
| RHEL 6 | chromium-browser | 80.0.3987.87-1.el6_10 | RHSA-2020:0514 |
SUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 15 SP3 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLES 15 SP2 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLES 15 SP1 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLES 15 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLES 12 SP5 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
Show 23 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 12 SP4 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SLES 12 SP3 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SLES 12 SP2 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SLES for SAP 15 SP1 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLES for SAP 15 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLES for SAP 12 SP5 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SLES for SAP 12 SP4 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SLES for SAP 12 SP3 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SLE Micro 5.0 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLE HPC 15 SP1 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SLE HPC 15 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SUSE Package Hub 15 SP1 | chromium | 80.0.3987.87-bp151.3.59.1 | openSUSE-SU-2020:0210-1 |
| SUSE Package Hub 12 SP3 | chromium | 80.0.3987.87-31.1 | openSUSE-SU-2020:0233-1 |
| SUSE Package Hub 12 SP3 | re2 | 20200101-25.1 | openSUSE-SU-2020:0233-1 |
| SUSE Package Hub 12 | chromium | 80.0.3987.87-31.1 | openSUSE-SU-2020:0233-1 |
| SUSE Package Hub 12 | re2 | 20200101-25.1 | openSUSE-SU-2020:0233-1 |
| SUSE OpenStack Cloud Crowbar 9 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SUSE OpenStack Cloud Crowbar 8 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SUSE OpenStack Cloud 9 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SUSE OpenStack Cloud 8 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SUSE Manager Server 4.0 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SUSE Manager Retail Branch Server 4.0 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SUSE Manager Proxy 4.0 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
| SUSE HPE Helion OpenStack 8 | sqlite3 | 3.36.0-9.18.1 | SUSE-SU-2021:3215-1 |
| SUSE Enterprise Storage 6 | sqlite3 | 3.36.0-3.12.1 | SUSE-SU-2021:2320-1 |
openSUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| openSUSE Tumbleweed | chromium | 93.0.4577.82-1.1 | openSUSE-SU-2024:12948-1, openSUSE-SU-2024:10681-1 |
| openSUSE Leap 15.3 | sqlite3 | 3.36.0-3.12.1 | openSUSE-SU-2021:2320-1 |
| openSUSE Leap 15.2 | sqlite3 | 3.36.0-lp152.4.3.1 | openSUSE-SU-2021:1058-1 |
| openSUSE Leap 15.1 | chromium | 80.0.3987.87-lp151.2.63.1 | openSUSE-SU-2020:0189-1 |
Oracle Linux
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Oracle Linux 8 | lemon +4 | 3.26.0-6.el8 | ELSA-2020-1810 |
Advisories 21
- WID-SEC-2026-4026 Red Hat OpenShift: Mehrere Schwachstellen BSI CERT-Bund (WID) · Oct 18, 2026
- RHSA-2020:1810 Red Hat Security Advisory: sqlite security and bug fix update Red Hat Security Advisories (RHSA) · Oct 15, 2026
- RHSA-2020:0514 Red Hat Security Advisory: chromium-browser security update Red Hat Security Advisories (RHSA) · Oct 15, 2026
- SSA-398330 SSA-398330: Vulnerabilities in the additional GNU/Linux subsystem of the SIMATIC S7-1500 CPU 1518(F)-4 PN/DP MFP >= V3.1.0 and < V3.1.5 Siemens ProductCERT · Oct 13, 2026
- USN-4298-1 sqlite3 vulnerabilities Ubuntu Security Notices (USN) · Apr 27, 2026
- DSA-4638-1 chromium - security update Debian Security (DSA / DLA) · Mar 9, 2026
- openSUSE-SU-2020:0210-1 Security update for chromium SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2020:0189-1 Security update for chromium SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2021:1058-1 Security update for sqlite3 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:10681-1 chromedriver-93.0.4577.82-1.1 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2021:3215-1 Security update for sqlite3 SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2021:2320-1 Security update for sqlite3 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2021:2320-1 Security update for sqlite3 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:12948-1 ungoogled-chromium-113.0.5672.92-1.1 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2020:0233-1 Security update for chromium, re2 SUSE / openSUSE Security Updates · Feb 4, 2026
- ICSA-23-348-10 Siemens SIMATIC S7-1500 CISA ICS & IT advisories · Aug 12, 2025
- ICSA-22-069-09 Siemens SINEC INS CISA ICS & IT advisories · May 6, 2025
- WID-SEC-2023-1614 Tenable Security Nessus Network Monitor: Mehrere Schwachstellen BSI CERT-Bund (WID) · Oct 25, 2023
- WID-SEC-2023-1049 Oracle MySQL: Mehrere Schwachstellen BSI CERT-Bund (WID) · Apr 20, 2023
- SSA-389290 SSA-389290: Third-Party Component Vulnerabilities in SINEC INS Siemens ProductCERT · Mar 8, 2022
- ELSA-2020-1810 Moderate: sqlite security and bug fix update (Oracle Linux 8) Oracle Linux Security Advisories (ELSA) · May 5, 2020
References
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- https://security.netapp.com/advisory/ntap-20200114-0003/
- openSUSE-SU-2020:0189 vendor-advisory
- openSUSE-SU-2020:0210 vendor-advisory
- RHSA-2020:0514 vendor-advisory
- openSUSE-SU-2020:0233 vendor-advisory
- DSA-4638 vendor-advisory
- USN-4298-1 vendor-advisory
- https://www.oracle.com/security-alerts/cpuapr2020.html
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf