HIGH
sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference
Published Dec 24, 2019
7.5
HIGHCVSS 3.1
EPSS 6.81%
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).
Affected products
No data.
Configuration 2
- < 1.0.1.1
Configuration 3
- ≤ 8.0.19
Configuration 4
OR
- 9.0
- 10.0
Configuration 5
OR
- 6.0
- 6.0
- 6.0
Configuration 6
AND
- n/a
Running on/with
- 12.0
Configuration 7
OR
- 15.0
- 15.1
Configuration 8
- n/a
No data.
Red Hat Enterprise Linux 6 Supplementary
chromium-browser-0:80.0.3987.87-1.el6_10
Fixed · RHSA-2020:0514
Red Hat Enterprise Linux 8
sqlite-0:3.26.0-6.el8
Fixed · RHSA-2020:1810
Red Hat Enterprise Linux 8
sqlite-0:3.26.0-6.el8
Fixed · RHSA-2020:1810
Red Hat Enterprise Linux 5
sqlite
Not affected
Red Hat Enterprise Linux 6
sqlite
Not affected
Red Hat Enterprise Linux 7
sqlite
Not affected
| Product | Package | State | Advisory |
|---|---|---|---|
| Red Hat Enterprise Linux 6 Supplementary | chromium-browser-0:80.0.3987.87-1.el6_10 | Fixed | RHSA-2020:0514 |
| Red Hat Enterprise Linux 8 | sqlite-0:3.26.0-6.el8 | Fixed | RHSA-2020:1810 |
| Red Hat Enterprise Linux 8 | sqlite-0:3.26.0-6.el8 | Fixed | RHSA-2020:1810 |
| Red Hat Enterprise Linux 5 | sqlite | Not affected | n/a |
| Red Hat Enterprise Linux 6 | sqlite | Not affected | n/a |
| Red Hat Enterprise Linux 7 | sqlite | Not affected | n/a |
No package ranges for this CVE.
Remediation
No remediation recorded yet.
Metrics
No CVSS v4.0 score for this CVE.
7.5 HIGH NVD
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
Attack Vector Network
Attack Complexity Low
Privileges Required None
User Interaction None
Scope Unchanged
Confidentiality Impact None
Integrity Impact None
Availability Impact High
No CVSS v3.0 score for this CVE.
5.0 MEDIUM NVD
AV:N/AC:L/Au:N/C:N/I:N/A:P
Access Vector Network
Access Complexity Low
Authentication None
Confidentiality Impact None
Integrity Impact None
Availability Impact Partial
This CVE is not in the KEV list.
No CISA SSVC assessment for this CVE yet.
6.81% 0.06810
Estimated probability of exploitation in the wild in the next 30 days (FIRST EPSS). As of Oct 3, 2026.
EPSS probability 0.06810
Score over time
2021–2026- EPSS v1
- EPSS v2
- EPSS v3
- EPSS v4
- EPSS v5
Percentile over time
- EPSS v1
- EPSS v2
- EPSS v3
- EPSS v4
- EPSS v5
Table of values (50 key points)
Flat stretches are collapsed; showing up to 120 newest points.
| Date | Score | Percentile | Model |
|---|---|---|---|
| Oct 3, 2026 | 6.81% (0.06810) | 93.82th | v5 (v2026.06.15) |
| Jun 15, 2026 | 6.81% (0.06810) | 93.16th | v5 (v2026.06.15) |
| Mar 4, 2026 | 6.20% (0.06200) | 90.68th | v4 (v2025.03.14) |
| Mar 1, 2026 | 0.78% (0.00782) | 73.53th | v4 (v2025.03.14) |
| Feb 4, 2026 | 6.20% (0.06200) | 90.63th | v4 (v2025.03.14) |
| Feb 1, 2026 | 0.78% (0.00782) | 73.39th | v4 (v2025.03.14) |
| Jan 4, 2026 | 6.20% (0.06200) | 90.55th | v4 (v2025.03.14) |
| Jan 1, 2026 | 0.78% (0.00782) | 73.33th | v4 (v2025.03.14) |
| Dec 4, 2025 | 6.20% (0.06200) | 90.48th | v4 (v2025.03.14) |
| Dec 1, 2025 | 0.78% (0.00782) | 73.08th | v4 (v2025.03.14) |
| Nov 21, 2025 | 6.20% (0.06200) | 90.45th | v4 (v2025.03.14) |
| Nov 18, 2025 | 11.72% (0.11721) | 92.99th | v4 (v2025.03.14) |
| Nov 17, 2025 | 6.20% (0.06200) | 90.44th | v4 (v2025.03.14) |
| Nov 4, 2025 | 10.52% (0.10516) | 92.92th | v4 (v2025.03.14) |
| Nov 1, 2025 | 1.40% (0.01403) | 79.90th | v4 (v2025.03.14) |
| Oct 4, 2025 | 10.52% (0.10516) | 92.96th | v4 (v2025.03.14) |
| Oct 1, 2025 | 1.40% (0.01403) | 79.84th | v4 (v2025.03.14) |
| Sep 21, 2025 | 10.52% (0.10516) | 92.98th | v4 (v2025.03.14) |
| Sep 6, 2025 | 13.88% (0.13878) | 94.07th | v4 (v2025.03.14) |
| Sep 1, 2025 | 1.90% (0.01903) | 82.60th | v4 (v2025.03.14) |
| Aug 4, 2025 | 13.88% (0.13878) | 94.02th | v4 (v2025.03.14) |
| Aug 1, 2025 | 1.90% (0.01903) | 82.58th | v4 (v2025.03.14) |
| Jul 4, 2025 | 13.88% (0.13878) | 93.98th | v4 (v2025.03.14) |
| Jul 1, 2025 | 1.90% (0.01903) | 82.48th | v4 (v2025.03.14) |
| Jun 4, 2025 | 13.88% (0.13878) | 93.93th | v4 (v2025.03.14) |
| Jun 1, 2025 | 1.90% (0.01903) | 82.40th | v4 (v2025.03.14) |
| May 4, 2025 | 13.88% (0.13878) | 93.89th | v4 (v2025.03.14) |
| May 1, 2025 | 1.90% (0.01903) | 82.31th | v4 (v2025.03.14) |
| Apr 12, 2025 | 13.88% (0.13878) | 93.73th | v4 (v2025.03.14) |
| Apr 11, 2025 | 1.47% (0.01471) | 79.28th | v4 (v2025.03.14) |
| Apr 7, 2025 | 11.12% (0.11123) | 92.86th | v4 (v2025.03.14) |
| Apr 6, 2025 | 1.47% (0.01471) | 79.24th | v4 (v2025.03.14) |
| Mar 30, 2025 | 11.12% (0.11123) | 92.84th | v4 (v2025.03.14) |
| Mar 29, 2025 | 5.08% (0.05075) | 82.62th | v4 (v2025.03.14) |
| Mar 18, 2025 | 11.12% (0.11123) | 92.98th | v4 (v2025.03.14) |
| Mar 17, 2025 | 1.47% (0.01471) | 79.60th | v4 (v2025.03.14) |
| Dec 12, 2024 | 1.06% (0.01057) | 84.74th | v3 (v2023.03.01) |
| Apr 18, 2024 | 1.06% (0.01057) | 83.90th | v3 (v2023.03.01) |
| Nov 30, 2023 | 1.07% (0.01072) | 82.57th | v3 (v2023.03.01) |
| Nov 14, 2023 | 1.10% (0.01104) | 82.80th | v3 (v2023.03.01) |
| Oct 28, 2023 | 1.15% (0.01149) | 83.24th | v3 (v2023.03.01) |
| Mar 7, 2023 | 1.18% (0.01184) | 82.87th | v3 (v2023.03.01) |
| Mar 6, 2023 | 1.54% (0.01537) | 74.52th | v2 (v2022.01.01) |
| Feb 23, 2023 | 1.54% (0.01537) | 74.48th | v2 (v2022.01.01) |
| Apr 1, 2022 | 1.54% (0.01537) | 72.41th | v2 (v2022.01.01) |
| Feb 4, 2022 | 16.31% (0.16306) | 92.84th | v2 (v2022.01.01) |
| Feb 3, 2022 | 8.66% (0.08659) | 85.81th | v1 |
| Jan 6, 2022 | 8.66% (0.08659) | 85.64th | v1 |
| Sep 1, 2021 | 2.07% (0.02069) | 77.27th | v1 |
| Apr 14, 2021 | 2.07% (0.02069) | 0.00th | v1 |
Weaknesses (1)
References (14)
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html vendor-advisoryx_refsource_SUSEMailing ListThird Party Advisory
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html vendor-advisoryx_refsource_SUSEMailing ListThird Party Advisory
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html vendor-advisoryx_refsource_SUSEMailing ListThird Party Advisory
- https://access.redhat.com/errata/RHSA-2020:0514 vendor-advisoryx_refsource_REDHATThird Party Advisory
- https://access.redhat.com/security/cve/CVE-2019-19923 Vendor Advisory
- https://bugzilla.redhat.com/show_bug.cgi?id=1788846 Issue Tracking
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf x_refsource_CONFIRMPatchThird Party Advisory
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35 x_refsource_MISCPatch
- https://nvd.nist.gov/vuln/detail/CVE-2019-19923
- https://security.netapp.com/advisory/ntap-20200114-0003/ x_refsource_CONFIRMThird Party Advisory
- https://usn.ubuntu.com/4298-1/ vendor-advisoryx_refsource_UBUNTUBroken Link
- https://www.cve.org/CVERecord?id=CVE-2019-19923
- https://www.debian.org/security/2020/dsa-4638 vendor-advisoryx_refsource_DEBIANThird Party Advisory
- https://www.oracle.com/security-alerts/cpuapr2020.html x_refsource_MISCPatchThird Party Advisory
Change history (0)
No recorded changes yet.
Sources
CVE.org / MITRE
Status PUBLISHED
Assigner mitre
Published Dec 24, 2019
Updated Aug 5, 2024
Reserved Dec 23, 2019
Link CVE-2019-19923
CISA Vulnrichment
Updated n/a